DBA Data[Home] [Help]

APPS.PAY_DK_GENERAL dependencies on PER_ALL_PEOPLE_F

Line 21: ,per_all_people_f per

17: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE , p_input_value VARCHAR2 ) IS
18: SELECT eev1.screen_entry_value screen_entry_value
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

Line 110: ,per_all_people_f per

106: --
107: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE ) IS
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

Line 181: ,per_all_people_f per

177: --
178: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE ) IS
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

Line 264: ,per_all_people_f per

260: CURSOR get_details(p_assignment_id NUMBER,p_effective_date DATE ) IS
261: SELECT eev1.screen_entry_value atp_override_hours
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

Line 316: ,per_all_people_f per

312: , eev1.screen_entry_value screen_entry_value
313: , iv1.name
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