APPS.OE_ITORD_PUB dependencies on HZ_PARTIES

Line 352: FROM hz_parties party,

348: ELSE
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 ;

Line 678: FROM hz_parties party,

674:
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