DBA Data[Home] [Help]

APPS.OE_ITORD_UTIL dependencies on HZ_CUST_ACCOUNTS

Line 173: HZ_CUST_ACCOUNTS cust,

169: IF NOT OE_GLOBALS.Equal( p_customer_id , G_CUST_ID ) then
170: SELECT party.CATEGORY_CODE
171: into l_customer_category_code
172: FROM
173: HZ_CUST_ACCOUNTS cust,
174: HZ_PARTIES party
175: WHERE cust.party_id = party.party_id
176: and cust.cust_account_id = p_customer_id;
177:

Line 977: hz_cust_accounts acct

973:
974: SELECT party.party_name
975: INTO l_rule_level_value
976: FROM hz_parties party,
977: hz_cust_accounts acct
978: WHERE acct.party_id = party.party_id
979: AND acct.cust_account_id = l_rule_level_id;
980:
981: ELSIF p_rule_level = 'CUST_CLASS'