APPS.PJI_PJI_EXTRACTION_UTILS dependencies on PA_WORK_TYPES_B

Line 527: --with PA_WORK_TYPES_B when extraction type is FULL

523: return;
524: END IF;
525:
526: --Synchronize NORMAL slice of PJI_RM_WORK_TYPE_INFO
527: --with PA_WORK_TYPES_B when extraction type is FULL
528: --or INCREMENTAL
529: insert into PJI_RM_WORK_TYPE_ROWID
530: (
531: PA_ROWID,

Line 547: PA_WORK_TYPES_B pa,

543: then 'Y'
544: else 'N'
545: end
546: from
547: PA_WORK_TYPES_B pa,
548: PJI_RM_WORK_TYPE_INFO pji
549: where
550: pa.WORK_TYPE_ID = pji.WORK_TYPE_ID (+) and
551: pji.RECORD_TYPE (+)= 'NORMAL';

Line 593: PA_WORK_TYPES_B pa

589: pa.LAST_UPDATE_DATE,
590: pa.LAST_UPDATED_BY
591: from
592: PJI_RM_WORK_TYPE_ROWID wt_r,
593: PA_WORK_TYPES_B pa
594: where
595: wt_r.PJI_ROWID = wt.ROWID and
596: pa.ROWID = wt_r.PA_ROWID
597: )

Line 639: PA_WORK_TYPES_B pa

635: pa.CREATED_BY,
636: pa.LAST_UPDATE_DATE,
637: pa.LAST_UPDATED_BY
638: from
639: PA_WORK_TYPES_B pa
640: where
641: pa.ROWID in
642: (
643: select