[Home] [Help]
SELECT /* $Header: hxtbis.odf 120.1 2005/09/26 12:49:58 jdupont noship $ */ 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
SELECT /* $HEADER: HXTBIS.ODF 120.1 2005/09/26 12:49:58 JDUPONT NOSHIP $ */ 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
|
|
|
|