DBA Data[Home] [Help]

APPS.PAY_SE_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_ENTRIES_F

Line 2379: ,pay_element_entries_f ee

2375: ,per_all_people_f per
2376: ,pay_element_links_f el
2377: ,pay_element_types_f et
2378: ,pay_input_values_f iv1
2379: ,pay_element_entries_f ee
2380: ,pay_element_entry_values_f eev1
2381: WHERE asg1.assignment_id = p_assignment_id
2382: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
2383: AND p_date_earned BETWEEN asg2.effective_start_date AND asg2.effective_end_date

Line 2407: ,pay_element_entries_f ee

2403: FROM per_all_assignments_f asg1
2404: ,pay_element_links_f el
2405: ,pay_element_types_f et
2406: ,pay_input_values_f iv1
2407: ,pay_element_entries_f ee
2408: ,pay_element_entry_values_f eev1
2409: WHERE asg1.assignment_id = p_assignment_id
2410: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
2411: AND et.element_name = 'Tax'