DBA Data[Home] [Help]

APPS.OE_ITORD_PUB dependencies on HZ_CUST_ACCOUNTS

Line 316: hz_cust_accounts acct

312: begin
313: SELECT 'Y'
314: INTO l_exists
315: FROM hz_parties party,
316: hz_cust_accounts acct
317: WHERE acct.party_id = party.party_id
318: AND acct.status = 'A'
319: AND acct.cust_account_id = p_Item_Orderability_Import_Rec.customer_id ;
320: Exception

Line 642: hz_cust_accounts acct

638: begin
639: SELECT 'Y'
640: INTO l_exists
641: FROM hz_parties party,
642: hz_cust_accounts acct
643: WHERE acct.party_id = party.party_id
644: AND acct.cust_account_id = p_Item_Orderability_Import_Rec.end_customer_id ;
645: Exception
646: when no_data_found then