DBA Data[Home] [Help]

APPS.HXC_TIMECARD_UTILITIES dependencies on PAY_ELEMENT_LINKS_F

Line 1707: ,pay_element_links_f pel

1703: IS
1704: SELECT pap.accrual_plan_id
1705: FROM pay_accrual_plans pap
1706: ,pay_element_types_f pet
1707: ,pay_element_links_f pel
1708: ,pay_element_entries_f pee
1709: WHERE pap.accrual_plan_element_type_id = pet.element_type_id
1710: AND pet.element_type_id = pel.element_type_id
1711: AND pee.effective_start_date BETWEEN pet.effective_start_date