DBA Data[Home] [Help]

APPS.OE_SYNC_ORDER_PVT dependencies on HZ_RELATIONSHIPS

Line 88: hz_relationships r

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
91: AND cust_account_role_id = p_cust_acct_role_id
92: AND r.directional_flag = 'F'