DBA Data[Home] [Help]

APPS.OE_GSA_UTIL dependencies on HZ_CUST_ACCOUNTS

Line 207: from hz_parties hp,hz_cust_accounts hca

203: --added the following select and assignment statement to fix bug 1738379 Begin
204: l_customer_id := p_line_rec.sold_to_org_id;
205: select nvl(gsa_indicator_flag,'N')
206: into l_gsa_flag
207: from hz_parties hp,hz_cust_accounts hca
208: where hp.party_id = hca.party_id
209: and hca.cust_account_id = l_customer_id ;
210: IF l_debug_level > 0 THEN
211: oe_debug_pub.add( 'GSA_FLAG VALUE2:'||L_GSA_FLAG , 5 ) ;