89:
90: CURSOR get_code_id(c_category VARCHAR2, c_code VARCHAR2)
91: IS
92: SELECT class_code_id
93: FROM PA_CLASS_CODES
94: WHERE class_category = c_category
95: AND class_code = c_code;
96:
97:
989:
990: CURSOR get_class_code_id(c_class_category VARCHAR2, c_class_code VARCHAR2)
991: IS
992: SELECT class_code_id
993: FROM PA_CLASS_CODES
994: WHERE class_category = c_class_category
995: AND class_code = c_class_code;
996:
997: CURSOR check_cat_assoc(c_class_category_id NUMBER)