DBA Data[Home] [Help]

APPS.RCV_DEFAULT_PKG dependencies on HZ_CUST_ACCOUNTS

Line 365: hz_cust_accounts acct

361:
362: SELECT acct.cust_account_id
363: INTO x_customer_id
364: FROM hz_parties party,
365: hz_cust_accounts acct
366: WHERE party.party_id = acct.party_id
367: AND party.party_name = p_customer_party_name
368: AND acct.account_number = p_customer_account_number;
369:

Line 397: hz_cust_accounts acct

393:
394: SELECT party.party_name
395: INTO x_customer_party_name
396: FROM hz_parties party,
397: hz_cust_accounts acct
398: WHERE party.party_id = acct.party_id
399: AND acct.cust_account_id = p_customer_id;
400:
401: RETURN x_customer_party_name;

Line 426: FROM hz_cust_accounts acct

422: END IF;
423:
424: SELECT acct.account_number
425: INTO x_customer_account_number
426: FROM hz_cust_accounts acct
427: WHERE acct.cust_account_id = p_customer_id;
428:
429: RETURN x_customer_account_number;
430: EXCEPTION