APPS.OE_ITORD_UTIL dependencies on HZ_CUST_PROFILE_CLASSES

Line 52: hz_cust_profile_classes cpc

48: SELECT cp.profile_class_id
49: into l_customer_class_id
50: FROM
51: HZ_CUSTOMER_PROFILES cp ,
52: hz_cust_profile_classes cpc
53: WHERE cpc.profile_class_id=cp.PROFILE_CLASS_ID
54: AND cp.site_use_id IS NULL
55: AND cp.cust_account_id= p_customer_id;
56:

Line 956: FROM hz_cust_profile_classes cpc

952: l_rule_level_id := TO_NUMBER(p_rule_level_value);
953:
954: SELECT cpc.name
955: INTO l_rule_level_value
956: FROM hz_cust_profile_classes cpc
957: WHERE profile_class_id = l_rule_level_id;
958:
959: ELSIF p_rule_level = 'CUST_CATEGORY'
960: THEN