APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PER_PEOPLE_F

Line 570: FROM per_people_f pep

566:
567: CURSOR csr_get_marital_status (c_person_id NUMBER, c_effective_date DATE)
568: IS
569: SELECT marital_status
570: FROM per_people_f pep
571: WHERE pep.person_id = c_person_id
572: AND c_effective_date BETWEEN pep.effective_start_date
573: AND pep.effective_end_date
574: ORDER BY pep.effective_start_date DESC;

Line 581: FROM per_people_f pep, per_contact_relationships pcr

577:
578: CURSOR csr_get_spouses_details (c_person_id NUMBER, c_effective_date DATE)
579: IS
580: SELECT pep.date_of_birth, pep.first_name, pep.middle_names
581: FROM per_people_f pep, per_contact_relationships pcr
582: WHERE pcr.person_id = c_person_id
583: AND pcr.contact_type = 'S'
584: AND c_effective_date BETWEEN NVL (
585: pcr.date_start,