DBA Data[Home] [Help]

APPS.OE_ITORD_UTIL dependencies on HZ_CUST_ACCOUNTS

Line 142: HZ_CUST_ACCOUNTS cust,

138: IF NOT OE_GLOBALS.Equal( p_customer_id , G_CUST_ID ) then
139: SELECT party.CATEGORY_CODE
140: into l_customer_category_code
141: FROM
142: HZ_CUST_ACCOUNTS cust,
143: HZ_PARTIES party
144: WHERE cust.party_id = party.party_id
145: and cust.cust_account_id = p_customer_id;
146:

Line 946: hz_cust_accounts acct

942:
943: SELECT party.party_name
944: INTO l_rule_level_value
945: FROM hz_parties party,
946: hz_cust_accounts acct
947: WHERE acct.party_id = party.party_id
948: AND acct.cust_account_id = l_rule_level_id;
949:
950: ELSIF p_rule_level = 'CUST_CLASS'