View: HXTFV_TIMECARDS

Product:	HXT - Time and Labor
Description:
Implementation/DBA Data:	APPS.HXTFV_TIMECARDS

View Text

SELECT /* $HEADER: HXTVIEW.LDT 115.3 2001/08/31 15:17:25 PKM SHIP $ */ BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, PEO.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PAY.PAYROLL_NAME PAYROLL_NAME
, PTP.END_DATE PERIOD_END_DATE
, PTP.START_DATE PERIOD_START_DATE
, PBH.BATCH_NAME BATCH_NAME
, PEO2.FULL_NAME APPROVER_NAME
, TIM.APPROVED_TIMESTAMP APPROVED_TIMESTAMP
, HR_GENERAL.DECODE_LOOKUP('HXT_TIMECARD_SOURCE'
, TIM.AUTO_GEN_FLAG) TIMECARD_SOURCE
, HR_GENERAL.DECODE_LOOKUP('HXT_BATCH_STATUS'
, HBS.STATUS) BATCH_STATUS
, TIM.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, '_DF:HXT:HXT_TIMECARDS_F:TIM' /* IDS */
, TIM.APPROV_PERSON_ID APPROVING_PERSON_ID
, PEO.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, TIM.BATCH_ID BATCH_ID
, TIM.PAYROLL_ID PAYROLL_ID
, TIM.FOR_PERSON_ID PERSON_ID
, TIM.ID TIMECARD_ID
, TIM.TIME_PERIOD_ID TIME_PERIOD_ID
FROM HXT_TIMECARDS_F TIM
, PER_TIME_PERIODS PTP
, PER_PEOPLE_F PEO
, PER_ALL_PEOPLE_F PEO2
, PAY_PAYROLLS_F PAY
, HXT_BATCH_STATES HBS
, PAY_BATCH_HEADERS PBH
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE TIM.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
AND TIM.FOR_PERSON_ID = PEO.PERSON_ID
AND TIM.PAYROLL_ID = PAY.PAYROLL_ID
AND TIM.BATCH_ID = HBS.BATCH_ID (+)
AND TIM.BATCH_ID = PBH.BATCH_ID (+)
AND BGRT.ORGANIZATION_ID = PEO.BUSINESS_GROUP_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND TIM.APPROV_PERSON_ID = PEO2.PERSON_ID(+)
AND TIM.APPROVED_TIMESTAMP BETWEEN PEO2.EFFECTIVE_START_DATE(+)
AND PEO2.EFFECTIVE_END_DATE(+)
AND PTP.END_DATE BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND PTP.END_DATE BETWEEN PAY.EFFECTIVE_START_DATE
AND PAY.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN TIM.EFFECTIVE_START_DATE
AND TIM.EFFECTIVE_END_DATE
AND PEO.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, PEO.BUSINESS_GROUP_ID) WITH READ ONLY

Columns