APPS.PAY_DK_GENERAL dependencies on PAY_ELEMENT_TYPES_F

Line 23: ,pay_element_types_f et

19: FROM per_all_assignments_f asg1
20: ,per_all_assignments_f asg2
21: ,per_all_people_f per
22: ,pay_element_links_f el
23: ,pay_element_types_f et
24: ,pay_input_values_f iv1
25: ,pay_element_entries_f ee
26: ,pay_element_entry_values_f eev1
27: WHERE asg1.assignment_id = p_assignment_id

Line 112: ,pay_element_types_f et

108: SELECT ee.effective_start_date effective_start_date, ee.effective_end_date effective_end_date
109: FROM per_all_assignments_f asg
110: ,per_all_people_f per
111: ,pay_element_links_f el
112: ,pay_element_types_f et
113: ,pay_element_entries_f ee
114: WHERE asg.assignment_id = p_assignment_id
115: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
116: AND et.element_name = 'Tax'

Line 183: ,pay_element_types_f et

179: SELECT ee.effective_start_date effective_start_date, ee.effective_end_date effective_end_date
180: FROM per_all_assignments_f asg
181: ,per_all_people_f per
182: ,pay_element_links_f el
183: ,pay_element_types_f et
184: ,pay_element_entries_f ee
185: WHERE asg.assignment_id = p_assignment_id
186: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
187: AND et.element_name = 'Employee ATP'

Line 266: ,pay_element_types_f et

262: FROM per_all_assignments_f asg1
263: ,per_all_assignments_f asg2
264: ,per_all_people_f per
265: ,pay_element_links_f el
266: ,pay_element_types_f et
267: ,pay_input_values_f iv1
268: ,pay_element_entries_f ee
269: ,pay_element_entry_values_f eev1
270: WHERE asg1.assignment_id = p_assignment_id

Line 318: ,pay_element_types_f et

314: FROM per_all_assignments_f asg1
315: ,per_all_assignments_f asg2
316: ,per_all_people_f per
317: ,pay_element_links_f el
318: ,pay_element_types_f et
319: ,pay_input_values_f iv1
320: ,pay_element_entries_f ee
321: ,pay_element_entry_values_f eev1
322: WHERE asg1.assignment_id = p_assignment_id