DBA Data[Home] [Help]

APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_LINKS_F

Line 2824: ,pay_element_links_f pel

2820: ,pap.business_group_id
2821: ,pap.accrual_plan_id
2822: FROM pay_accrual_plans pap
2823: ,pay_element_types_f pet
2824: ,pay_element_links_f pel
2825: ,pay_element_entries_f pee
2826: ,pay_assignment_actions paa
2827: ,pay_payroll_actions ppa
2828: WHERE pet.element_type_id = pap.accrual_plan_element_type_id

Line 3865: ,pay_element_links_f el

3861: ,eev1.screen_entry_value screen_entry_value
3862: FROM per_all_assignments_f asg1
3863: ,per_all_assignments_f asg2
3864: ,per_all_people_f per
3865: ,pay_element_links_f el
3866: ,pay_element_types_f et
3867: ,pay_input_values_f iv1
3868: ,pay_element_entries_f ee
3869: ,pay_element_entry_values_f eev1

Line 3893: ,pay_element_links_f el

3889: CURSOR csr_tax_details(p_assignment_id NUMBER, p_input_value VARCHAR2) IS
3890: SELECT ee.effective_start_date
3891: ,eev1.screen_entry_value screen_entry_value
3892: FROM per_all_assignments_f asg1
3893: ,pay_element_links_f el
3894: ,pay_element_types_f et
3895: ,pay_input_values_f iv1
3896: ,pay_element_entries_f ee
3897: ,pay_element_entry_values_f eev1

Line 4408: ,pay_element_links_f el

4404: -- Cursor to get the 'Tax Period Override Element' details
4405: CURSOR csr_tax_period_override (p_assignment_id NUMBER, p_input_value VARCHAR2) IS
4406: SELECT eev1.screen_entry_value screen_entry_value
4407: FROM per_all_assignments_f asg1
4408: ,pay_element_links_f el
4409: ,pay_element_types_f et
4410: ,pay_input_values_f iv1
4411: ,pay_element_entries_f ee
4412: ,pay_element_entry_values_f eev1