DBA Data[Home] [Help]

APPS.PA_PROJECT_PUB dependencies on PA_CLASS_CODES

Line 10293: FROM PA_CLASS_CODES

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;

Line 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

Line 10298: l_new_class_code_id pa_class_codes.class_code_id%type;

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