DBA Data[Home] [Help]

APPS.PAY_DK_ARCHIVE dependencies on PAY_ELEMENT_ENTRIES_F

Line 1858: ,pay_element_entries_f pee

1854: ,pap.accrual_plan_id
1855: FROM pay_accrual_plans pap
1856: ,pay_element_types_f pet
1857: ,pay_element_links_f pel
1858: ,pay_element_entries_f pee
1859: ,pay_assignment_actions paa
1860: ,pay_payroll_actions ppa
1861: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
1862: AND pel.element_type_id = pet.element_type_id

Line 2662: ,pay_element_entries_f ee

2658: ,per_all_people_f per
2659: ,pay_element_links_f el
2660: ,pay_element_types_f et
2661: ,pay_input_values_f iv1
2662: ,pay_element_entries_f ee
2663: ,pay_element_entry_values_f eev1
2664: WHERE asg1.assignment_id = p_assignment_id
2665: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
2666: AND p_date_earned BETWEEN asg2.effective_start_date AND asg2.effective_end_date

Line 2690: ,pay_element_entries_f ee

2686: FROM per_all_assignments_f asg1
2687: ,pay_element_links_f el
2688: ,pay_element_types_f et
2689: ,pay_input_values_f iv1
2690: ,pay_element_entries_f ee
2691: ,pay_element_entry_values_f eev1
2692: WHERE asg1.assignment_id = p_assignment_id
2693: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
2694: AND et.element_name = 'Tax'