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:
983: l_rule_level_id := TO_NUMBER(p_rule_level_value);
984:
985: SELECT cpc.name
986: INTO l_rule_level_value
987: FROM hz_cust_profile_classes cpc
988: WHERE profile_class_id = l_rule_level_id;
989:
990: ELSIF p_rule_level = 'CUST_CATEGORY'
991: THEN