APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PA_RBS_VERSIONS_B

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

335: pa_budget_versions bv,
336: pa_proj_fp_options fpo,
337: pji_pa_proj_events_log pel,
338: pa_projects_all ppa,
339: pa_rbs_versions_b rvb --Added for bug#5728852
340: WHERE 1=1
341: AND ppa.project_id = map.project_id
342: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
343: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.

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

398: PA_PROJ_FP_OPTIONS fpo,
399: PJI_PA_PROJ_EVENTS_LOG pel,
400: PA_RBS_PRJ_ASSIGNMENTS rpa,
401: PA_PROJECTS_ALL ppa,
402: PA_RBS_VERSIONS_B rvb --Added for bug#5728852
403: WHERE 1=1
404: AND ppa.project_id = map.project_id
405: AND bv.project_id = map.project_id
406: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.

Line 464: PA_RBS_VERSIONS_B rvb,

460: PA_PROJ_FP_OPTIONS fpo,
461: PJI_PA_PROJ_EVENTS_LOG pel,
462: PA_RBS_PRJ_ASSIGNMENTS rpa,
463: PA_PROJECTS_ALL ppa,
464: PA_RBS_VERSIONS_B rvb,
465: (
466: SELECT -3 pvi FROM dual UNION ALL
467: SELECT -4 pvi FROM dual
468: ) pln_ver

Line 979: from pa_rbs_versions_b

975:
976: DELETE FROM pji_pjp_rbs_header -- Old RBS versions are to be replaced with new ones.
977: WHERE 1=1
978: AND rbs_version_id in (select rbs_version_id
979: from pa_rbs_versions_b
980: where rbs_header_id = l_rbs_header_id) --Modified for Bug#5728852 by VVJOSHI
981: AND plan_version_id > 0;
982:
983: print_time ( ' Number of records in rbs hdr tbl that were deleted is.. = ' || SQL%ROWCOUNT );