APPS.OKS_EXTWAR_UTIL_PVT dependencies on PER_ALL_ASSIGNMENTS_F

Line 4991: per_all_assignments_f asg,

4987: ppl.last_name last_name, ppl.middle_names middle_name,
4988: LOWER (ppl.attribute26) new_email
4989: FROM per_all_people_f ppl,
4990: hr_all_organization_units org,
4991: per_all_assignments_f asg,
4992: per_jobs job,
4993: hr_locations loc,
4994: per_all_people_f emp
4995: WHERE ppl.person_id = p_source_id

Line 5011: FROM per_all_people_f pep, per_all_assignments_f asg1

5007: AND asg.supervisor_id = emp.person_id(+)
5008: AND TRUNC (SYSDATE) BETWEEN emp.effective_start_date(+) AND emp.effective_end_date(+)
5009: AND NOT EXISTS (
5010: SELECT pep.person_id
5011: FROM per_all_people_f pep, per_all_assignments_f asg1
5012: WHERE pep.person_id = ppl.person_id
5013: AND TRUNC (SYSDATE) BETWEEN pep.effective_start_date
5014: AND pep.effective_end_date
5015: AND pep.employee_number IS NOT NULL