DBA Data[Home] [Help]

APPS.OE_ITORD_UTIL dependencies on HZ_PARTIES

Line 174: HZ_PARTIES party

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:
178: G_CUST_ID := p_customer_id;

Line 976: FROM hz_parties party,

972: l_rule_level_id := TO_NUMBER(p_rule_level_value);
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: