APPS.PER_ES_COMP_CERT_ARCHIVE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 172: FROM per_all_assignments_f asl

168: ,c_start_date DATE
169: ,c_end_date DATE
170: ,c_business_group_id NUMBER) IS
171: SELECT assignment_id
172: FROM per_all_assignments_f asl
173: ,per_periods_of_service ppos
174: ,hr_soft_coding_keyflex hr
175: ,hr_organization_information hoi
176: WHERE asl.person_id BETWEEN stperson AND endperson

Line 208: FROM per_all_assignments_f asl

204: ,c_start_date DATE
205: ,c_end_date DATE
206: ,c_business_group_id NUMBER) IS
207: SELECT assignment_id
208: FROM per_all_assignments_f asl
209: ,hr_soft_coding_keyflex hr
210: ,hr_organization_information hoi
211: ,per_absence_attendance_types pat
212: ,per_absence_attendances paa

Line 302: l_assignment_id per_all_assignments_f.assignment_id%type;

298: p_effective_date in date) IS
299:
300:
301: l_person_id per_all_people_f.person_id%type;
302: l_assignment_id per_all_assignments_f.assignment_id%type;
303: l_type VARCHAR2(1);
304: l_end_date DATE;
305:
306: BEGIN

Line 473: ,per_all_assignments_f paa

469: ,pps.pds_information8 vacation_reamining
470: ,fnd_date.canonical_to_date(pps.pds_information9) vacation_from
471: ,fnd_date.canonical_to_date(pps.pds_information10) vacation_to
472: FROM per_all_people_f pap
473: ,per_all_assignments_f paa
474: ,per_periods_of_service pps
475: ,pay_assignment_actions paas
476: ,pay_payroll_actions ppa
477: ,hr_soft_coding_keyflex hr

Line 521: ,per_all_assignments_f paa

517: ,pps.pds_information8 vacation_reamining
518: ,fnd_date.canonical_to_date(pps.pds_information9) vacation_from
519: ,fnd_date.canonical_to_date(pps.pds_information10) vacation_to
520: FROM per_all_people_f pap
521: ,per_all_assignments_f paa
522: ,pay_assignment_actions paas
523: ,pay_payroll_actions ppa
524: ,per_periods_of_service pps
525: ,hr_soft_coding_keyflex hr

Line 540: from per_all_assignments_f paaf

536: from per_all_people_f papf
537: where papf.person_id = pap.person_id
538: AND papf.effective_start_date <= ppa.effective_date)
539: AND paa.effective_start_date = (select max(paaf.effective_start_date)
540: from per_all_assignments_f paaf
541: where paaf.assignment_id = paa.Assignment_id
542: AND paaf.effective_start_date <= ppa.effective_date)
543: AND hr.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
544: AND hr.segment2 = hoi.org_information1