DBA Data[Home] [Help]

APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_LINKS_F

Line 2813: ,pay_element_links_f pel

2809: ,pap.business_group_id
2810: ,pap.accrual_plan_id
2811: FROM pay_accrual_plans pap
2812: ,pay_element_types_f pet
2813: ,pay_element_links_f pel
2814: ,pay_element_entries_f pee
2815: ,pay_assignment_actions paa
2816: ,pay_payroll_actions ppa
2817: WHERE pet.element_type_id = pap.accrual_plan_element_type_id

Line 3854: ,pay_element_links_f el

3850: ,eev1.screen_entry_value screen_entry_value
3851: FROM per_all_assignments_f asg1
3852: ,per_all_assignments_f asg2
3853: ,per_all_people_f per
3854: ,pay_element_links_f el
3855: ,pay_element_types_f et
3856: ,pay_input_values_f iv1
3857: ,pay_element_entries_f ee
3858: ,pay_element_entry_values_f eev1

Line 3882: ,pay_element_links_f el

3878: CURSOR csr_tax_details(p_assignment_id NUMBER, p_input_value VARCHAR2) IS
3879: SELECT ee.effective_start_date
3880: ,eev1.screen_entry_value screen_entry_value
3881: FROM per_all_assignments_f asg1
3882: ,pay_element_links_f el
3883: ,pay_element_types_f et
3884: ,pay_input_values_f iv1
3885: ,pay_element_entries_f ee
3886: ,pay_element_entry_values_f eev1

Line 4397: ,pay_element_links_f el

4393: -- Cursor to get the 'Tax Period Override Element' details
4394: CURSOR csr_tax_period_override (p_assignment_id NUMBER, p_input_value VARCHAR2) IS
4395: SELECT eev1.screen_entry_value screen_entry_value
4396: FROM per_all_assignments_f asg1
4397: ,pay_element_links_f el
4398: ,pay_element_types_f et
4399: ,pay_input_values_f iv1
4400: ,pay_element_entries_f ee
4401: ,pay_element_entry_values_f eev1