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 561: PA_WORK_TYPES_B pa,

557: (
558: select
559: pji.ROWID
560: from
561: PA_WORK_TYPES_B pa,
562: PJI_RM_WORK_TYPE_INFO pji
563: where
564: pa.WORK_TYPE_ID = pji.WORK_TYPE_ID (+) and
565: pji.RECORD_TYPE (+)= 'NORMAL' AND

Line 608: PA_WORK_TYPES_B pa,

604: then 'Y'
605: else 'N'
606: end
607: from
608: PA_WORK_TYPES_B pa,
609: PJI_RM_WORK_TYPE_INFO pji
610: where
611: pa.WORK_TYPE_ID = pji.WORK_TYPE_ID (+) and
612: pji.RECORD_TYPE (+)= 'NORMAL') wt_r,

Line 613: PA_WORK_TYPES_B pa

609: PJI_RM_WORK_TYPE_INFO pji
610: where
611: pa.WORK_TYPE_ID = pji.WORK_TYPE_ID (+) and
612: pji.RECORD_TYPE (+)= 'NORMAL') wt_r,
613: PA_WORK_TYPES_B pa
614: where
615: wt_r.PJI_ROWID = wt.ROWID and
616: pa.ROWID = wt_r.PA_ROWID
617: )

Line 636: PA_WORK_TYPES_B pa,

632: then 'Y'
633: else 'N'
634: end CHANGE_FLAG
635: from
636: PA_WORK_TYPES_B pa,
637: PJI_RM_WORK_TYPE_INFO pji
638: where
639: pa.WORK_TYPE_ID = pji.WORK_TYPE_ID (+) and
640: pji.RECORD_TYPE (+)= 'NORMAL') wt_r

Line 675: PA_WORK_TYPES_B pa

671: pa.CREATED_BY,
672: pa.LAST_UPDATE_DATE,
673: pa.LAST_UPDATED_BY
674: from
675: PA_WORK_TYPES_B pa
676: where
677: pa.ROWID in
678: (
679: select

Line 694: PA_WORK_TYPES_B pa,

690: then 'Y'
691: else 'N'
692: end
693: from
694: PA_WORK_TYPES_B pa,
695: PJI_RM_WORK_TYPE_INFO pji
696: where
697: pa.WORK_TYPE_ID = pji.WORK_TYPE_ID (+) and
698: pji.RECORD_TYPE (+)= 'NORMAL') wt_r