eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PER_CONTACT_RELATIONSHIPS

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,