HXT Manual and Autogen

Description
Categories: BI Publisher, Human Resources
Application: Time and Labor
Source: Manual and Autogen Report (XML)
Short Name: HXT970A_XML
DB package: HXT_HXT970A_XMLP_PKG
select tim.FOR_PERSON_ID, 
	tim.ID timecard_id, 
	tim.PAYROLL_ID, 
	tim.TIME_PERIOD_ID,  
	per.LAST_NAME, 
	per.FIRST_NAME,  
	per.EMPLOYEE_NUMBER,   
	per.FULL_NAME,  
	per.PERSON_ID, 
	tim.AUTO_GEN_FLAG, 
	fcl.MEANING, 
	HXT_HXT970A_XMLP_PKG.cf_status1formula(tim.ID) CF_STATUS1
from HXT_TIMECARDS_X tim, PER_PEOPLE_F per,  FND_COMMON_LOOKUPS fcl,
PER_TIME_PERIODS ptp
where tim.TIME_PERIOD_ID = :P_TIME_PERIOD_ID
AND tim.PAYROLL_ID in ( SELECT ptp.payroll_id FROM per_time_periods ptp where ptp.time_period_id = :P_TIME_PERIOD_ID)
AND tim.FOR_PERSON_ID = per.PERSON_ID
AND (tim.AUTO_GEN_FLAG = 'M' OR tim.AUTO_GEN_FLAG = 'U')
AND  FCL.LOOKUP_CODE = tim.AUTO_GEN_FLAG
AND  sysdate BETWEEN  NVL(START_DATE_ACTIVE, sysdate) AND               NVL(END_DATE_ACTIVE, sysdate)
AND   FCL.APPLICATION_ID = 808
AND   FCL.ENABLED_FLAG = 'Y'
AND   (FCL.LOOKUP_TYPE = 'HXT_TIMECARD_SOURCE')
AND  FCL.LOOKUP_CODE = tim.AUTO_GEN_FLAG
AND  sysdate BETWEEN  NVL(START_DATE_ACTIVE, sysdate) AND               NVL(END_DATE_ACTIVE, sysdate)
AND   FCL.APPLICATION_ID = 808
AND   FCL.ENABLED_FLAG = 'Y'
AND   (FCL.LOOKUP_TYPE = 'HXT_TIMECARD_SOURCE')
AND tim.TIME_PERIOD_ID = ptp.TIME_PERIOD_ID
AND PER.EFFECTIVE_END_DATE >= ptp.START_DATE
AND PER.EFFECTIVE_START_DATE <= ptp.END_DATE
ORDER BY per.LAST_NAME
Parameter NameSQL textValidation
Time Period
 
LOV Oracle
Payroll Name
 
LOV Oracle