APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PA_RBS_VERSIONS_B

Line 242: pa_rbs_versions_b rvb --Added for bug#5728852

238: pa_budget_versions bv,
239: pa_proj_fp_options fpo,
240: pji_pa_proj_events_log pel,
241: pa_projects_all ppa,
242: pa_rbs_versions_b rvb --Added for bug#5728852
243: WHERE 1=1
244: AND ppa.project_id = map.project_id
245: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
246: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.

Line 305: PA_RBS_VERSIONS_B rvb --Added for bug#5728852

301: PA_PROJ_FP_OPTIONS fpo,
302: PJI_PA_PROJ_EVENTS_LOG pel,
303: PA_RBS_PRJ_ASSIGNMENTS rpa,
304: PA_PROJECTS_ALL ppa,
305: PA_RBS_VERSIONS_B rvb --Added for bug#5728852
306: WHERE 1=1
307: AND ppa.project_id = map.project_id
308: AND bv.project_id = map.project_id
309: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.

Line 367: PA_RBS_VERSIONS_B rvb,

363: PA_PROJ_FP_OPTIONS fpo,
364: PJI_PA_PROJ_EVENTS_LOG pel,
365: PA_RBS_PRJ_ASSIGNMENTS rpa,
366: PA_PROJECTS_ALL ppa,
367: PA_RBS_VERSIONS_B rvb,
368: (
369: SELECT -3 pvi FROM dual UNION ALL
370: SELECT -4 pvi FROM dual
371: ) pln_ver

Line 882: from pa_rbs_versions_b

878:
879: DELETE FROM pji_pjp_rbs_header -- Old RBS versions are to be replaced with new ones.
880: WHERE 1=1
881: AND rbs_version_id in (select rbs_version_id
882: from pa_rbs_versions_b
883: where rbs_header_id = l_rbs_header_id) --Modified for Bug#5728852 by VVJOSHI
884: AND plan_version_id > 0;
885:
886: print_time ( ' Number of records in rbs hdr tbl that were deleted is.. = ' || SQL%ROWCOUNT );