DBA Data[Home] [Help]

APPS.QP_VALIDATE_QUALIFIERS dependencies on HZ_CUST_ACCOUNTS

Line 739: from hz_cust_accounts cust_acct,hz_parties party

735:
736: oe_debug_pub.add('GSA = Y');
737: select decode(party.party_type,'ORGANIZATION',party.gsa_indicator_flag,'N')
738: into l_customer_gsa_indicator
739: from hz_cust_accounts cust_acct,hz_parties party
740: where cust_acct.party_id = party.party_id and
741: cust_acct.cust_account_id = to_number(p_QUALIFIERS_rec.qualifier_attr_value);
742:
743: IF SQL%NOTFOUND