349: begin
350: SELECT 'Y'
351: INTO l_exists
352: FROM hz_parties party,
353: hz_cust_accounts acct
354: WHERE acct.party_id = party.party_id
355: AND acct.status = 'A'
356: AND acct.cust_account_id = p_Item_Orderability_Import_Rec.customer_id ;
357: Exception
675: begin
676: SELECT 'Y'
677: INTO l_exists
678: FROM hz_parties party,
679: hz_cust_accounts acct
680: WHERE acct.party_id = party.party_id
681: AND acct.cust_account_id = p_Item_Orderability_Import_Rec.end_customer_id ;
682: Exception
683: when no_data_found then