DBA Data[Home] [Help]

APPS.OE_SYNC_ORDER_PVT dependencies on HZ_ORG_CONTACTS

Line 86: FROM hz_org_contacts oc,

82: END IF;
83:
84: SELECT org_contact_id
85: INTO l_org_contact_id
86: FROM hz_org_contacts oc,
87: hz_cust_account_roles car,
88: hz_relationships r
89: WHERE r.party_id = car.party_id
90: AND r.relationship_id = oc.party_relationship_id