DBA Data[Home] [Help]

APPS.PAY_SE_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_ENTRIES_F

Line 2367: ,pay_element_entries_f ee

2363: ,per_all_people_f per
2364: ,pay_element_links_f el
2365: ,pay_element_types_f et
2366: ,pay_input_values_f iv1
2367: ,pay_element_entries_f ee
2368: ,pay_element_entry_values_f eev1
2369: WHERE asg1.assignment_id = p_assignment_id
2370: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
2371: AND p_date_earned BETWEEN asg2.effective_start_date AND asg2.effective_end_date

Line 2395: ,pay_element_entries_f ee

2391: FROM per_all_assignments_f asg1
2392: ,pay_element_links_f el
2393: ,pay_element_types_f et
2394: ,pay_input_values_f iv1
2395: ,pay_element_entries_f ee
2396: ,pay_element_entry_values_f eev1
2397: WHERE asg1.assignment_id = p_assignment_id
2398: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
2399: AND et.element_name = 'Tax'