APPS.PJI_RM_SUM_ROLLUP_RES dependencies on PJI_RM_WORK_TYPE_INFO

Line 197: from PJI_RM_WORK_TYPE_INFO

193: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
194:
195: select count(*)
196: into l_count
197: from PJI_RM_WORK_TYPE_INFO
198: where RECORD_TYPE = 'CHANGE_OLD' or
199: RECORD_TYPE = 'CHANGE_NEW';
200:
201: if (l_count > 0) then

Line 532: PJI_RM_WORK_TYPE_INFO wt,

528: 'Y', tmp1.CONF_HRS_S, 0) REDUCE_CAPACITY_HRS_S,
529: tmp1.CONF_OVERCOM_HRS_S CONF_OVERCOM_HRS_S,
530: tmp1.PROV_OVERCOM_HRS_S PROV_OVERCOM_HRS_S
531: from
532: PJI_RM_WORK_TYPE_INFO wt,
533: PJI_RM_AGGR_RES1 tmp1
534: where
535: tmp1.WORKER_ID = p_worker_id and
536: tmp1.RECORD_TYPE <> 'N' and

Line 675: PJI_RM_WORK_TYPE_INFO wt_old,

671: end REDUCE_CAPACITY_HRS_S,
672: 0 CONF_OVERCOM_HRS_S,
673: 0 PROV_OVERCOM_HRS_S
674: from
675: PJI_RM_WORK_TYPE_INFO wt_old,
676: PJI_RM_WORK_TYPE_INFO wt_new,
677: PJI_RM_RES_WT_F rmr,
678: PJI_ORG_EXTR_INFO info
679: where

Line 676: PJI_RM_WORK_TYPE_INFO wt_new,

672: 0 CONF_OVERCOM_HRS_S,
673: 0 PROV_OVERCOM_HRS_S
674: from
675: PJI_RM_WORK_TYPE_INFO wt_old,
676: PJI_RM_WORK_TYPE_INFO wt_new,
677: PJI_RM_RES_WT_F rmr,
678: PJI_ORG_EXTR_INFO info
679: where
680: l_extraction_type = 'INCREMENTAL' and