DBA Data[Home] [Help]

APPS.PA_PROJECT_PUB dependencies on PA_CLASS_CODES

Line 10555: FROM PA_CLASS_CODES

10551: CURSOR c_get_class_code_id(l_class_category VARCHAR2,
10552: l_class_code VARCHAR2 )
10553: IS
10554: SELECT class_code_id
10555: FROM PA_CLASS_CODES
10556: WHERE class_category = l_class_category
10557: AND class_code = l_class_code;
10558:
10559: l_old_class_code_id pa_class_codes.class_code_id%type;

Line 10559: l_old_class_code_id pa_class_codes.class_code_id%type;

10555: FROM PA_CLASS_CODES
10556: WHERE class_category = l_class_category
10557: AND class_code = l_class_code;
10558:
10559: l_old_class_code_id pa_class_codes.class_code_id%type;
10560: l_new_class_code_id pa_class_codes.class_code_id%type;
10561: -- END of Addition for bug# 5294891.
10562:
10563: -- for opportunity value changes

Line 10560: l_new_class_code_id pa_class_codes.class_code_id%type;

10556: WHERE class_category = l_class_category
10557: AND class_code = l_class_code;
10558:
10559: l_old_class_code_id pa_class_codes.class_code_id%type;
10560: l_new_class_code_id pa_class_codes.class_code_id%type;
10561: -- END of Addition for bug# 5294891.
10562:
10563: -- for opportunity value changes
10564: -- adarora --Changes BEGIN for Bug 4473105