APPS.RCV_RMA_TRANSACTIONS dependencies on HZ_CUST_ACCOUNTS

Line 772: FROM hz_cust_accounts acct

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

Line 791: hz_cust_accounts acct

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