APPS.PQH_PSU_BUS dependencies on PER_CONTACT_RELATIONSHIPS

Line 861: FROM per_contact_relationships

857: CURSOR csr_contact_dtls(p_contact_person_id NUMBER,
858: p_person_id NUMBER,
859: p_contact_relationship VARCHAR2) IS
860: SELECT date_start,date_end
861: FROM per_contact_relationships
862: WHERE contact_person_id = p_contact_person_id
863: AND person_id = p_person_id
864: AND contact_type = p_contact_relationship;
865: lr_contact csr_contact_dtls%ROWTYPE;