DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_PYSA dependencies on PAY_ELEMENT_LINKS_F

Line 1455: ,pay_element_links_f pel

1451: ,pap.business_group_id
1452: ,pap.accrual_plan_id
1453: FROM pay_accrual_plans pap
1454: ,pay_element_types_f pet
1455: ,pay_element_links_f pel
1456: ,pay_element_entries_f pee
1457: ,pay_assignment_actions paa
1458: ,pay_payroll_actions ppa
1459: WHERE pet.element_type_id = pap.accrual_plan_element_type_id

Line 1817: ,pay_element_links_f el

1813: ,eev1.screen_entry_value screen_entry_value
1814: FROM per_all_assignments_f asg1
1815: ,per_all_assignments_f asg2
1816: ,per_all_people_f per
1817: ,pay_element_links_f el
1818: ,pay_element_types_f et
1819: ,pay_input_values_f iv1
1820: ,pay_element_entries_f ee
1821: ,pay_element_entry_values_f eev1

Line 1845: ,pay_element_links_f el

1841: CURSOR csr_tax_details(p_assignment_id NUMBER, p_input_value VARCHAR2) IS
1842: SELECT ee.effective_start_date
1843: ,eev1.screen_entry_value screen_entry_value
1844: FROM per_all_assignments_f asg1
1845: ,pay_element_links_f el
1846: ,pay_element_types_f et
1847: ,pay_input_values_f iv1
1848: ,pay_element_entries_f ee
1849: ,pay_element_entry_values_f eev1