APPS.CLN_SYNCITEM_PKG dependencies on HZ_CUST_ACCOUNTS

Line 55: FROM hz_cust_accounts hca

51: END IF;
52:
53: SELECT hca.cust_account_id cust_account_id
54: INTO l_cust_acct_id
55: FROM hz_cust_accounts hca
56: WHERE hca.party_id = CLN_SYNCITEM_PKG.GET_PARTY_ID();
57:
58: IF (l_Debug_Level <= 2) THEN
59: cln_debug_pub.Add('Customer Account ID '||l_cust_acct_id,2);

Line 315: HZ_CUST_ACCOUNTS HZC,

311: po_hazard_classes_tl phct,
312: MTL_CUSTOMER_ITEMS MCI,
313: HZ_PARTIES HZP,
314: MFG_LOOKUPS MFL ,
315: HZ_CUST_ACCOUNTS HZC,
316: AR_LOOKUPS ARL
317: WHERE mcix.customer_item_id = mci.customer_item_id AND
318: mcix.inventory_item_id(+)= msib.inventory_item_id AND
319: mcix.master_organization_id =msib.organization_id AND