2756: l_partner_level_desc VARCHAR2(240);
2757:
2758: CURSOR l_get_partner_level(cv_attribute_id NUMBER, cv_attr_code_id NUMBER) IS
2759: SELECT description
2760: FROM pv_attribute_codes_vl
2761: WHERE attribute_id = cv_attribute_id
2762: AND attr_code_id = cv_attr_code_id ;
2763:
2764: BEGIN
2788: l_attr_code_desc VARCHAR2(240);
2789:
2790: CURSOR lc_attr_code_desc(cv_attribute_id NUMBER, cv_attr_code VARCHAR2) IS
2791: SELECT description
2792: FROM pv_attribute_codes_vl
2793: WHERE attribute_id = cv_attribute_id
2794: AND attr_code = cv_attr_code;
2795:
2796: BEGIN