APPS.PA_RBS_MAPPING dependencies on PA_RESOURCE_ASSIGNMENTS

Line 1963: pa_resource_assignments ra ,

1959: ra.txn_accum_header_id
1960: FROM
1961: pji_pjp_proj_batch_map map, -- Bug#5223360 - Peformance Fix
1962: pji_pjp_wbs_header wbs,
1963: pa_resource_assignments ra ,
1964: ( SELECT worker_id
1965: , event_type
1966: , attribute1
1967: FROM pji_pa_proj_events_log

Line 1993: pa_resource_assignments ra,

1989: ra.txn_accum_header_id
1990: FROM
1991: pji_pjp_proj_batch_map map,
1992: pji_pjp_wbs_header hd2, -- sub
1993: pa_resource_assignments ra,
1994: ( SELECT worker_id
1995: , event_type
1996: , attribute1
1997: FROM pji_pa_proj_events_log

Line 2049: , pa_resource_assignments ra

2045: , pa_rbs_prj_assignments asg
2046: , pa_rbs_versions_b rbv1
2047: , pa_rbs_versions_b rbv2
2048: , pa_budget_versions bv
2049: , pa_resource_assignments ra
2050: WHERE
2051: LOG.event_type = 'RBS_PUSH' AND
2052: LOG.worker_id = p_worker_id AND
2053: asg.rbs_version_id = TO_NUMBER(LOG.attribute2) AND

Line 2715: PA_RESOURCE_ASSIGNMENTS res_assign,

2711: (txn_accum_header_id,
2712: struct_version_id)
2713: SELECT distinct tmp.txn_accum_header_id, prj_assign.rbs_version_id
2714: FROM PA_RBS_PLANS_IN_TMP tmp,
2715: PA_RESOURCE_ASSIGNMENTS res_assign,
2716: PA_RBS_PRJ_ASSIGNMENTS prj_assign
2717: WHERE tmp.source_id = res_assign.resource_assignment_id AND
2718: res_assign.project_id = prj_assign.project_id AND
2719: tmp.txn_accum_header_id not in