APPS.RCV_RMA_TRANSACTIONS dependencies on HZ_CUST_ACCOUNTS

Line 773: FROM hz_cust_accounts acct

769: END IF;
770:
771: SELECT acct.cust_account_id
772: INTO x_cascaded_table(n).customer_id
773: FROM hz_cust_accounts acct
774: WHERE acct.account_number = x_cascaded_table(n).customer_account_number;
775:
776: IF (g_asn_debug = 'Y') THEN
777: asn_debug.put_line('Derived customer_id ' || x_cascaded_table(n).customer_id);

Line 792: hz_cust_accounts acct

788: BEGIN
789: SELECT acct.cust_account_id
790: INTO x_cascaded_table(n).customer_id
791: FROM hz_parties party,
792: hz_cust_accounts acct
793: WHERE acct.party_id = party.party_id
794: AND party.party_name = x_cascaded_table(n).customer_party_name;
795: EXCEPTION
796: WHEN TOO_MANY_ROWS THEN