APPS.IBE_MSITE_PRTY_ACCSS_MGR_PVT dependencies on HZ_CUST_ACCOUNTS_ALL

Line 430: FROM hz_cust_accounts_all

426: AND P.party_type = L.lookup_code;
427:
428: -- Get the party account data
429: OPEN x_cust_account_csr FOR SELECT party_id, account_number
430: FROM hz_cust_accounts_all
431: WHERE status = 'A' and party_id IN
432: (SELECT party_id FROM ibe_msite_prty_accss
433: WHERE msite_id = p_msite_id)
434: ORDER BY party_id, account_number;