APPS.PAY_DK_GENERAL dependencies on PER_ALL_ASSIGNMENTS_F

Line 19: FROM per_all_assignments_f asg1

15: ,p_daily_tax_deduction OUT NOCOPY NUMBER) RETURN NUMBER IS
16: --
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

Line 20: ,per_all_assignments_f asg2

16: --
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

Line 109: FROM per_all_assignments_f asg

105: ) RETURN NUMBER IS
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

Line 180: FROM per_all_assignments_f asg

176: ) RETURN NUMBER IS
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

Line 262: FROM per_all_assignments_f asg1

258: ) RETURN NUMBER IS
259: --
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

Line 263: ,per_all_assignments_f asg2

259: --
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

Line 314: FROM per_all_assignments_f asg1

310: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE ) IS
311: SELECT ee.element_entry_id element_entry_id
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

Line 315: ,per_all_assignments_f asg2

311: SELECT ee.element_entry_id element_entry_id
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

Line 461: FROM per_all_assignments_f paaf

457: CURSOR csr_get_asg_hs_flag( p_assignment_id IN NUMBER
458: ,p_effective_date IN DATE
459: ) IS
460: SELECT paaf.hourly_salaried_code
461: FROM per_all_assignments_f paaf
462: WHERE paaf.assignment_id = p_assignment_id
463: AND p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date;
464:
465: rec_get_asg_hs_flag csr_get_asg_hs_flag%ROWTYPE;

Line 507: FROM per_all_assignments_f paaf

503: ,p_assignment_id IN NUMBER) RETURN DATE IS
504:
505: CURSOR csr_asg IS
506: SELECT MIN(paaf.effective_start_date) effective_start_date
507: FROM per_all_assignments_f paaf
508: WHERE paaf.business_group_id = p_business_group_id
509: AND paaf.assignment_id = p_assignment_id
510: ;
511: