APPS.CSL_SERVICE_REQUESTS_PKG dependencies on HZ_RELATIONSHIPS

Line 70: SELECT b.party_id FROM HZ_RELATIONSHIPS b

66:
67: CURSOR c_org_rel_contacts
68: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE
69: ) IS
70: SELECT b.party_id FROM HZ_RELATIONSHIPS b
71: WHERE b.object_id = b_customer_id
72: AND object_table_name = 'HZ_PARTIES'
73: AND status = 'A'
74: AND b.relationship_code in ('CONTACT_OF','EMPLOYEE_OF')

Line 81: SELECT b.subject_id FROM HZ_RELATIONSHIPS b

77:
78: CURSOR c_person_contacts
79: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE
80: ) IS
81: SELECT b.subject_id FROM HZ_RELATIONSHIPS b
82: WHERE b.object_id = b_customer_id
83: AND object_table_name = 'HZ_PARTIES'
84: AND status = 'A'
85: AND rownum <= 1;