10289: CURSOR c_get_class_code_id(l_class_category VARCHAR2,
10290: l_class_code VARCHAR2 )
10291: IS
10292: SELECT class_code_id
10293: FROM PA_CLASS_CODES
10294: WHERE class_category = l_class_category
10295: AND class_code = l_class_code;
10296:
10297: l_old_class_code_id pa_class_codes.class_code_id%type;
10293: FROM PA_CLASS_CODES
10294: WHERE class_category = l_class_category
10295: AND class_code = l_class_code;
10296:
10297: l_old_class_code_id pa_class_codes.class_code_id%type;
10298: l_new_class_code_id pa_class_codes.class_code_id%type;
10299: -- END of Addition for bug# 5294891.
10300:
10301: -- for opportunity value changes
10294: WHERE class_category = l_class_category
10295: AND class_code = l_class_code;
10296:
10297: l_old_class_code_id pa_class_codes.class_code_id%type;
10298: l_new_class_code_id pa_class_codes.class_code_id%type;
10299: -- END of Addition for bug# 5294891.
10300:
10301: -- for opportunity value changes
10302: -- adarora --Changes BEGIN for Bug 4473105