APPS.PJI_PJ_PROJ_CLASS_EXTR dependencies on PA_CLASS_CATEGORIES

Line 54: -- "C" means that this record comes from PA_CLASS_CATEGORIES

50: -- Extract class categories
51:
52: -- We use column record_type is used in the following way:
53: --
54: -- "C" means that this record comes from PA_CLASS_CATEGORIES
55: -- "T" means this is one of the three project type
56: -- categories: contract, capital or indirect.
57: -- "A" means that this is the fourth project type
58: -- category - category "All" - that includes all

Line 98: PA_CLASS_CATEGORIES

94: CLASS_CATEGORY CLASS_CATEGORY,
95: CLASS_CATEGORY NAME,
96: 'C' RECORD_TYPE
97: from
98: PA_CLASS_CATEGORIES
99: where
100: INCLUDE_IN_PJI_FLAG = 'Y'
101: union all
102: select

Line 499: FROM pa_class_categories

495: DELETE FROM PJI_PJ_EXTR_PRJCLS
496: WHERE worker_id = g_worker_id
497: AND class_category IN (
498: SELECT class_category
499: FROM pa_class_categories
500: WHERE NVL(include_in_pji_flag,'N') = 'N'
501: );
502:
503: Pji_Utils.write2log('Deleted ' || SQL%ROWCOUNT ||

Line 523: SELECT 1 FROM pa_class_categories cat

519: DELETE pji_pj_extr_prjcls extr
520: WHERE worker_id = g_worker_id
521: AND record_type = 'C'
522: AND NOT EXISTS (
523: SELECT 1 FROM pa_class_categories cat
524: WHERE extr.class_category = cat.class_category
525: );
526:
527: Pji_Utils.write2log('Deleted ' || SQL%ROWCOUNT ||