APPS.PA_RBS_MAPPING dependencies on PJI_PJP_WBS_HEADER

Line 1958: SELECT /*+ORDERED INDEX (RA PA_RESOURCE_ASSIGNMENTS_N1) index ( wbs pji_pjp_wbs_header_n1 ) */

1954: FROM gmap MAP,
1955: PJI_FP_TXN_ACCUM1 ACCUM1
1956: WHERE ACCUM1.PROJECT_ID = MAP.PROJECT_ID
1957: UNION ALL
1958: SELECT /*+ORDERED INDEX (RA PA_RESOURCE_ASSIGNMENTS_N1) index ( wbs pji_pjp_wbs_header_n1 ) */
1959: DISTINCT RA.PROJECT_ID, RA.TXN_ACCUM_HEADER_ID
1960: FROM gmap MAP, /* changed the order */
1961: (
1962: SELECT WORKER_ID , EVENT_TYPE , ATTRIBUTE1

Line 1971: PJI_PJP_WBS_HEADER WBS,

1967: SELECT p_worker_id , EVENT_TYPE , ATTRIBUTE1
1968: FROM PA_PJI_PROJ_EVENTS_LOG
1969: WHERE event_type = 'RBS_ASSOC' -- Moved the filter conditions to inline view Bug: 12799162
1970: )LOG,
1971: PJI_PJP_WBS_HEADER WBS,
1972: PA_RESOURCE_ASSIGNMENTS RA
1973: WHERE l_rbs_assoc_flag = 'Y'
1974: AND MAP.PROJECT_ID = WBS.PROJECT_ID
1975: -- AND LOG.EVENT_TYPE = 'RBS_ASSOC' -- Commented for bug 12799162

Line 1998: PJI_PJP_WBS_HEADER HD2,

1994: FROM PA_PJI_PROJ_EVENTS_LOG
1995: WHERE event_type = 'RBS_PRG' -- Moved the filter conditions to inline view Bug: 12799162
1996: )LOG,
1997: PJI_XBS_DENORM DEN,
1998: PJI_PJP_WBS_HEADER HD2,
1999: PA_RESOURCE_ASSIGNMENTS RA
2000: WHERE l_rbs_assoc_flag = 'Y'
2001: AND MAP.PROJECT_ID = HD2.PROJECT_ID
2002: -- AND LOG.EVENT_TYPE = 'RBS_PRG' -- Commented for bug 12799162