APPS.PA_RBS_MAPPING dependencies on PA_RBS_VERSIONS_B

Line 2021: pa_rbs_versions_b rbsv,

2017: hd2.plan_version_id = ra.budget_version_id AND
2018: hd2.project_id = ra.project_id )
2019: ) det,
2020: pa_rbs_prj_assignments ASSIGN,
2021: pa_rbs_versions_b rbsv,
2022: pa_rbs_headers_b rbsh
2023: WHERE
2024: det.project_id = ASSIGN.project_id AND
2025: det.txn_accum_header_id NOT IN

Line 2046: , pa_rbs_versions_b rbv1

2042: ra.txn_accum_header_id
2043: , rbv2.rbs_version_id
2044: FROM pji_pa_proj_events_log LOG
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

Line 2047: , pa_rbs_versions_b rbv2

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

Line 2110: FROM pa_rbs_versions_b

2106: BEGIN
2107:
2108: SELECT job_group_id
2109: INTO l_job_group_id
2110: FROM pa_rbs_versions_b
2111: WHERE rbs_version_id = l_rbs_struct_version_id(i) ;
2112:
2113: EXCEPTION
2114: WHEN NO_DATA_FOUND THEN

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

2316:
2317:
2318: /* added for bug#4027727 */
2319: BEGIN
2320: SELECT job_group_id INTO l_job_group_id FROM pa_rbs_versions_b WHERE rbs_version_id = p_rbs_version_id ;
2321: EXCEPTION
2322: WHEN NO_DATA_FOUND THEN
2323: NULL;
2324: END;