APPS.PA_RBS_MAPPING dependencies on PA_RESOURCE_ASSIGNMENTS

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 1972: PA_RESOURCE_ASSIGNMENTS RA

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
1976: AND TO_NUMBER(LOG.ATTRIBUTE1) = WBS.PROJECT_ID

Line 1984: SELECT /*+ORDERED INDEX (RA PA_RESOURCE_ASSIGNMENTS_N1) */

1980: AND RA.TXN_ACCUM_HEADER_ID IS NOT NULL
1981: -- AND LOG.WORKER_ID = p_worker_id -- Commented for bug 12799162
1982: and map.worker_id = log.worker_id /* added */
1983: UNION ALL
1984: SELECT /*+ORDERED INDEX (RA PA_RESOURCE_ASSIGNMENTS_N1) */
1985: DISTINCT RA.PROJECT_ID, RA.TXN_ACCUM_HEADER_ID
1986: FROM gmap MAP,
1987: (
1988: SELECT WORKER_ID , EVENT_TYPE , ATTRIBUTE1

Line 1999: PA_RESOURCE_ASSIGNMENTS RA

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
2003: AND RA.TXN_ACCUM_HEADER_ID IS NOT NULL

Line 2069: , pa_resource_assignments ra

2065: , pa_rbs_prj_assignments asg
2066: , pa_rbs_versions_b rbv1
2067: , pa_rbs_versions_b rbv2
2068: , pa_budget_versions bv
2069: , pa_resource_assignments ra
2070: WHERE
2071: LOG.event_type = 'RBS_PUSH' AND
2072: LOG.worker_id = p_worker_id AND
2073: asg.rbs_version_id = TO_NUMBER(LOG.attribute2) AND

Line 2343: SELECT /*+ORDERED INDEX (RA PA_RESOURCE_ASSIGNMENTS_N1) */

2339: FROM PJI_FP_TXN_ACCUM1 ACCUM1
2340: WHERE ( p_calling_mode = 'FULL' or p_event_type = 'RBS_ASSOC' )
2341: AND ACCUM1.PROJECT_ID = p_project_id
2342: UNION ALL
2343: SELECT /*+ORDERED INDEX (RA PA_RESOURCE_ASSIGNMENTS_N1) */
2344: DISTINCT RA.PROJECT_ID, RA.TXN_ACCUM_HEADER_ID
2345: FROM pa_budget_versions bv ,
2346: PA_RESOURCE_ASSIGNMENTS RA
2347: WHERE ( p_calling_mode = 'FULL' or p_event_type = 'RBS_ASSOC' )

Line 2346: PA_RESOURCE_ASSIGNMENTS RA

2342: UNION ALL
2343: SELECT /*+ORDERED INDEX (RA PA_RESOURCE_ASSIGNMENTS_N1) */
2344: DISTINCT RA.PROJECT_ID, RA.TXN_ACCUM_HEADER_ID
2345: FROM pa_budget_versions bv ,
2346: PA_RESOURCE_ASSIGNMENTS RA
2347: WHERE ( p_calling_mode = 'FULL' or p_event_type = 'RBS_ASSOC' )
2348: AND bv.PROJECT_ID = p_project_id
2349: AND bv.PROJECT_ID = RA.PROJECT_ID
2350: AND bv.fin_plan_type_id <> 10

Line 2401: , pa_resource_assignments ra

2397: , pa_rbs_prj_assignments asg
2398: , pa_rbs_versions_b rbv1
2399: , pa_rbs_versions_b rbv2
2400: , pa_budget_versions bv
2401: , pa_resource_assignments ra
2402: WHERE
2403: LOG.event_type = 'RBS_PUSH' AND
2404: LOG.worker_id = p_worker_id AND
2405: LOG.attribute19 = p_project_id AND

Line 3050: PA_RESOURCE_ASSIGNMENTS res_assign,

3046: (txn_accum_header_id,
3047: struct_version_id)
3048: SELECT distinct tmp.txn_accum_header_id, prj_assign.rbs_version_id
3049: FROM PA_RBS_PLANS_IN_TMP tmp,
3050: PA_RESOURCE_ASSIGNMENTS res_assign,
3051: PA_RBS_PRJ_ASSIGNMENTS prj_assign
3052: WHERE tmp.source_id = res_assign.resource_assignment_id AND
3053: res_assign.project_id = prj_assign.project_id AND
3054: tmp.txn_accum_header_id not in