DBA Data[Home] [Help]

APPS.PJI_PJ_PROJ_CLASS_EXTR dependencies on PA_CLASS_CODES

Line 151: pa_class_codes

147: class_code class_code
148: , class_category class_category
149: , 'C' record_type
150: FROM
151: pa_class_codes
152: WHERE
153: class_category IN
154: (
155: SELECT class_category

Line 510: SELECT 1 FROM pa_class_codes cls

506: DELETE pji_pj_extr_prjcls extr
507: WHERE worker_id = g_worker_id
508: AND record_type = 'C'
509: AND NOT EXISTS (
510: SELECT 1 FROM pa_class_codes cls
511: WHERE extr.class_code = cls.class_code
512: AND extr.class_category = cls.class_category
513: );
514: