APPS.OKS_EXTWAR_UTIL_PVT dependencies on PER_ALL_PEOPLE_F

Line 4943: FROM per_all_people_f ppl,

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

Line 4948: per_all_people_f emp

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
4950: AND TRUNC (SYSDATE) BETWEEN ppl.effective_start_date
4951: AND ppl.effective_end_date
4952: AND ppl.employee_number IS NOT NULL

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

Line 4986: AND parent_table = 'PER_ALL_PEOPLE_F'

4982: SELECT phone_number
4983: FROM per_phones
4984: WHERE parent_id = p_source_id
4985: AND phone_type = p_phone_type
4986: AND parent_table = 'PER_ALL_PEOPLE_F'
4987: AND TRUNC (SYSDATE) BETWEEN date_from AND NVL (date_to, SYSDATE);
4988:
4989: -- Following cursor definition was modified to add check for JTOT_OBJECT1_CODE
4990: -- and a check for sales person effectivity dates. If there are multiple active