DBA Data[Home] [Help]

APPS.PA_PROJECTS_MAINT_PVT dependencies on PA_CLASS_CODES

Line 3023: FROM PA_PROJECT_CLASSES ppc, PA_CLASS_CATEGORIES cat, PA_CLASS_CODES code

3019: -- Bug 2904327
3020: CURSOR l_get_classification
3021: IS
3022: SELECT cat.class_category_id, code.class_code_id
3023: FROM PA_PROJECT_CLASSES ppc, PA_CLASS_CATEGORIES cat, PA_CLASS_CODES code
3024: WHERE ppc.rowid = p_rowid
3025: AND ppc.class_category = cat.class_category
3026: AND ppc.class_category = code.class_category
3027: AND ppc.class_code = code.class_code;

Line 3776: FROM PA_CLASS_CODES

3772:
3773: CURSOR get_code_id
3774: IS
3775: SELECT class_code_id
3776: FROM PA_CLASS_CODES
3777: WHERE class_category = p_class_category
3778: AND class_code = p_class_code;
3779:
3780: l_category_id NUMBER;