83:
84: CURSOR get_category_id(c_category VARCHAR2)
85: IS
86: SELECT class_category_id
87: FROM PA_CLASS_CATEGORIES
88: WHERE class_category = c_category;
89:
90: CURSOR get_code_id(c_category VARCHAR2, c_code VARCHAR2)
91: IS
983:
984: CURSOR get_class_category_id(c_class_category VARCHAR2)
985: IS
986: SELECT class_category_id
987: FROM PA_CLASS_CATEGORIES
988: WHERE class_category = c_class_category;
989:
990: CURSOR get_class_code_id(c_class_category VARCHAR2, c_class_code VARCHAR2)
991: IS