APPS.PAY_GB_WNU_RULES dependencies on PER_ALL_ASSIGNMENTS_F

Line 28: per_all_assignments_f aaf

24: --
25: cursor csr_employee is
26: select upper(apf.current_employee_flag)
27: from per_all_people_f apf,
28: per_all_assignments_f aaf
29: where aaf.person_id = apf.person_id
30: and aaf.assignment_id = p_assignment_id
31: and p_effective_date between
32: apf.effective_start_date and apf.effective_end_date;

Line 45: per_all_assignments_f aaf

41: --
42: cursor csr_bg is
43: select pbg.legislation_code
44: from per_business_groups pbg,
45: per_all_assignments_f aaf
46: where aaf.assignment_id = p_assignment_id
47: and aaf.business_group_id = pbg.business_group_id
48: and p_effective_date between
49: aaf.effective_start_date and aaf.effective_end_date;

Line 203: from per_all_assignments_f aaf

199: and information_type = 'GB_WNU';
200: --
201: cursor csr_assignment is
202: select aaf.assignment_id assignment_id
203: from per_all_assignments_f aaf
204: where aaf.person_id = p_person_id
205: and p_effective_date between
206: aaf.effective_start_date and aaf.effective_end_date;
207: --

Line 211: per_all_assignments_f aaf

207: --
208: cursor csr_bg(c_assignment_id NUMBER) is
209: select pbg.legislation_code
210: from per_business_groups pbg,
211: per_all_assignments_f aaf
212: where aaf.assignment_id = c_assignment_id
213: and aaf.business_group_id = pbg.business_group_id
214: and p_effective_date between
215: aaf.effective_start_date and aaf.effective_end_date;

Line 219: from per_all_assignments_f aaf,

215: aaf.effective_start_date and aaf.effective_end_date;
216: --
217: cursor csr_agg_assignment is
218: select min(aaf.assignment_id) assignment_id
219: from per_all_assignments_f aaf,
220: hr_soft_coding_keyflex hsck,
221: pay_all_payrolls_f papf,
222: per_assignment_status_types past
223: where aaf.person_id = p_person_id

Line 236: per_all_assignments_f paaf,

232: AND p_effective_date BETWEEN papf.effective_start_date AND papf.effective_end_date
233: AND hsck.segment1 in ( SELECT distinct(hsck.segment1)
234: FROM hr_soft_coding_keyflex hsck2,
235: pay_all_payrolls_f papf2,
236: per_all_assignments_f paaf,
237: per_assignment_status_types past2
238: WHERE hsck2.soft_coding_keyflex_id = papf2.soft_coding_keyflex_id
239: AND papf2.payroll_id =paaf.payroll_id
240: AND past2.assignment_status_type_id = paaf.assignment_status_type_id