APPS.PJI_PJI_EXTRACTION_UTILS dependencies on PA_RESOURCES_DENORM

Line 906: -- This procedure incrementally synchronizes PA_RESOURCES_DENORM with

902:
903: -- -----------------------------------------------------
904: -- procedure UPDATE_RESOURCE_DATA
905: --
906: -- This procedure incrementally synchronizes PA_RESOURCES_DENORM with
907: -- PJI_RESOURCES_DENORM.
908: --
909: -- -----------------------------------------------------
910: procedure UPDATE_RESOURCE_DATA (p_process in varchar2) is

Line 954: PA_RESOURCES_DENORM pa,

950: then 'Y'
951: else 'N'
952: end
953: from
954: PA_RESOURCES_DENORM pa,
955: PJI_RESOURCES_DENORM pji
956: where
957: pa.PERSON_ID = pji.PERSON_ID (+) and
958: pa.RESOURCE_ID = pji.RESOURCE_ID (+) and

Line 965: -- Determine delta between PA_RESOURCES_DENORM and PJI_RESOURCES_DENORM

961: pa.RESOURCE_EFFECTIVE_START_DATE = pji.START_DATE (+) and
962: nvl(pa.RESOURCE_EFFECTIVE_END_DATE, l_max_date) = pji.END_DATE (+);
963:
964: -- --------------------------------------------------------------------
965: -- Determine delta between PA_RESOURCES_DENORM and PJI_RESOURCES_DENORM
966: -- --------------------------------------------------------------------
967:
968: if (l_extraction_type <> 'FULL') then
969:

Line 1015: PA_RESOURCES_DENORM pa,

1011: then 'Y'
1012: end
1013: from
1014: PJI_ROWID_RESOURCES_DENORM res_r,
1015: PA_RESOURCES_DENORM pa,
1016: PJI_RESOURCES_DENORM pji
1017: where
1018: res_r.PJI_ROWID is not null and
1019: res_r.CHANGE_FLAG = 'Y' and

Line 1031: PA_RESOURCES_DENORM pa

1027: pa.RESOURCE_EFFECTIVE_START_DATE,
1028: nvl(pa.RESOURCE_EFFECTIVE_END_DATE, l_max_date),
1029: 'Y'
1030: from
1031: PA_RESOURCES_DENORM pa
1032: where
1033: pa.UTILIZATION_FLAG = 'Y' and
1034: pa.ROWID in
1035: (

Line 1047: -- Synchronize PA_RESOURCES_DENORM and PJI_RESOURCES_DENORM

1043:
1044: end if;
1045:
1046: -- --------------------------------------------------------
1047: -- Synchronize PA_RESOURCES_DENORM and PJI_RESOURCES_DENORM
1048: -- --------------------------------------------------------
1049:
1050: delete /*+ use_nl(denorm) rowid(denorm) */
1051: from PJI_RESOURCES_DENORM denorm

Line 1077: PA_RESOURCES_DENORM pa

1073: pa.JOB_ID,
1074: pa.UTILIZATION_FLAG
1075: from
1076: PJI_ROWID_RESOURCES_DENORM res_r,
1077: PA_RESOURCES_DENORM pa
1078: where
1079: res_r.PJI_ROWID = denorm.ROWID and
1080: pa.ROWID = res_r.PA_ROWID
1081: )

Line 1117: PA_RESOURCES_DENORM pa

1113: pa.JOB_ID,
1114: pa.RESOURCE_ORGANIZATION_ID,
1115: pa.UTILIZATION_FLAG
1116: from
1117: PA_RESOURCES_DENORM pa
1118: where
1119: pa.ROWID in
1120: (
1121: select /*+ index(res_r, PJI_ROWID_RESOURCES_DENORM_N1) */