APPS.OE_ITORD_UTIL dependencies on HZ_PARTIES

Line 143: HZ_PARTIES party

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

Line 945: FROM hz_parties party,

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