APPS.PA_RBS_MAPPING dependencies on PA_RBS_VERSIONS_B

Line 2034: pa_rbs_versions_b rbsv,

2030: FROM
2031: pa_rbs_map_t1 t1 where t1.worker_id = p_worker_id
2032: ) det,
2033: pa_rbs_prj_assignments ASSIGN,
2034: pa_rbs_versions_b rbsv,
2035: pa_rbs_headers_b rbsh
2036: WHERE
2037: det.project_id = ASSIGN.project_id AND
2038: NOT EXISTS -- Bug#5578221 Performance Fix

Line 2066: , pa_rbs_versions_b rbv1

2062: ra.txn_accum_header_id
2063: , rbv2.rbs_version_id
2064: FROM pji_pa_proj_events_log LOG
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

Line 2067: , pa_rbs_versions_b rbv2

2063: , rbv2.rbs_version_id
2064: FROM pji_pa_proj_events_log LOG
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

Line 2139: FROM pa_rbs_versions_b

2135: BEGIN
2136:
2137: SELECT job_group_id
2138: INTO l_job_group_id
2139: FROM pa_rbs_versions_b
2140: WHERE rbs_version_id = l_rbs_struct_version_id(i) ;
2141:
2142: EXCEPTION
2143: WHEN NO_DATA_FOUND THEN

Line 2368: pa_rbs_versions_b rbsv,

2364: FROM
2365: pa_rbs_map_t1 t1 where t1.worker_id = p_worker_id
2366: ) det,
2367: pa_rbs_prj_assignments ASSIGN,
2368: pa_rbs_versions_b rbsv,
2369: pa_rbs_headers_b rbsh
2370: WHERE
2371: p_calling_mode in ( 'FULL' , 'INCREMENTAL') AND
2372: ASSIGN.project_id = p_project_id AND

Line 2398: , pa_rbs_versions_b rbv1

2394: ra.txn_accum_header_id
2395: , rbv2.rbs_version_id
2396: FROM pa_pjt_events LOG
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

Line 2399: , pa_rbs_versions_b rbv2

2395: , rbv2.rbs_version_id
2396: FROM pa_pjt_events LOG
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

Line 2470: FROM pa_rbs_versions_b

2466: BEGIN
2467:
2468: SELECT job_group_id
2469: INTO l_job_group_id
2470: FROM pa_rbs_versions_b
2471: WHERE rbs_version_id = l_rbs_struct_version_id(i) ;
2472:
2473: EXCEPTION
2474: WHEN NO_DATA_FOUND THEN

Line 2655: SELECT job_group_id INTO l_job_group_id FROM pa_rbs_versions_b WHERE rbs_version_id = p_rbs_version_id ;

2651:
2652:
2653: /* added for bug#4027727 */
2654: BEGIN
2655: SELECT job_group_id INTO l_job_group_id FROM pa_rbs_versions_b WHERE rbs_version_id = p_rbs_version_id ;
2656: EXCEPTION
2657: WHEN NO_DATA_FOUND THEN
2658: NULL;
2659: END;