DBA Data[Home] [Help]

APPS.OE_SYNC_ORDER_PVT dependencies on HZ_ORG_CONTACTS

Line 97: FROM hz_org_contacts oc,

93: END IF;
94:
95: SELECT org_contact_id
96: INTO l_org_contact_id
97: FROM hz_org_contacts oc,
98: hz_cust_account_roles car,
99: hz_relationships r
100: WHERE r.party_id = car.party_id
101: AND r.relationship_id = oc.party_relationship_id