APPS.OKS_EXTWAR_UTIL_PVT dependencies on PER_ALL_ASSIGNMENTS_F

Line 4945: per_all_assignments_f asg,

4941: ppl.last_name last_name, ppl.middle_names middle_name,
4942: LOWER (ppl.attribute26) new_email
4943: FROM per_all_people_f ppl,
4944: hr_all_organization_units org,
4945: per_all_assignments_f asg,
4946: per_jobs job,
4947: hr_locations loc,
4948: per_all_people_f emp
4949: WHERE ppl.person_id = p_source_id

Line 4965: FROM per_all_people_f pep, per_all_assignments_f asg1

4961: AND asg.supervisor_id = emp.person_id(+)
4962: AND TRUNC (SYSDATE) BETWEEN emp.effective_start_date(+) AND emp.effective_end_date(+)
4963: AND NOT EXISTS (
4964: SELECT pep.person_id
4965: FROM per_all_people_f pep, per_all_assignments_f asg1
4966: WHERE pep.person_id = ppl.person_id
4967: AND TRUNC (SYSDATE) BETWEEN pep.effective_start_date
4968: AND pep.effective_end_date
4969: AND pep.employee_number IS NOT NULL