DBA Data[Home] [Help]

APPS.OE_EXTERNAL_CREDIT_PVT dependencies on HZ_CUST_ACCOUNTS

Line 699: FROM hz_cust_accounts hca,

695: -- check for valid customer_id
696: BEGIN
697: SELECT hca.cust_account_id
698: INTO l_customer_id
699: FROM hz_cust_accounts hca,
700: hz_parties hp
701: WHERE hca.party_id = hp.party_id
702: AND hp.party_name = p_customer_name
703: AND hca.account_number = p_customer_number;