APPS.OKS_EXTWAR_UTIL_PVT dependencies on PER_ALL_PEOPLE_F

Line 4989: FROM per_all_people_f ppl,

4985: emp.full_name mgr_name, ppl.business_group_id org_id,
4986: org.NAME org_name, ppl.first_name first_name,
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,

Line 4994: per_all_people_f emp

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
4996: AND TRUNC (SYSDATE) BETWEEN ppl.effective_start_date
4997: AND ppl.effective_end_date
4998: AND ppl.employee_number IS NOT NULL

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

Line 5032: AND parent_table = 'PER_ALL_PEOPLE_F'

5028: SELECT phone_number
5029: FROM per_phones
5030: WHERE parent_id = p_source_id
5031: AND phone_type = p_phone_type
5032: AND parent_table = 'PER_ALL_PEOPLE_F'
5033: AND TRUNC (SYSDATE) BETWEEN date_from AND NVL (date_to, SYSDATE);
5034:
5035: -- Following cursor definition was modified to add check for JTOT_OBJECT1_CODE
5036: -- and a check for sales person effectivity dates. If there are multiple active