APPS.AML_SALES_LEADS_V2_PUB dependencies on HZ_ORG_CONTACTS

Line 105: FROM hz_org_contacts hzoc, hz_relationships hzr

101:
102: CURSOR C_get_org_contact_id (p_customer_id IN NUMBER, p_contact_id IN NUMBER)
103: IS
104: SELECT org_contact_id
105: FROM hz_org_contacts hzoc, hz_relationships hzr
106: WHERE hzoc.party_relationship_id = hzr.relationship_id
107: AND subject_id = p_customer_id
108: AND object_id = p_contact_id;
109: