APPS.PA_CBS_LEVEL_HIERARCHY_PVT dependencies on PA_RBS_VERSIONS_B

Line 250: rbs_version_id = (select rbs_version_id from pa_rbs_versions_b where rbs_header_id = P_CbsHeaderId);

246: END IF;
247:
248: delete from PA_RBS_ELEMENTS where
249: rbs_level = (P_Structure_Level)+1 and
250: rbs_version_id = (select rbs_version_id from pa_rbs_versions_b where rbs_header_id = P_CbsHeaderId);
251:
252: DELETE FROM PA_CBS_HIERARCHY
253: WHERE CBS_HEADER_ID = P_CbsHeaderId
254: AND STRUCTURE_LEVEL = P_Structure_Level

Line 283: (select rbs_version_id from pa_rbs_versions_b where rbs_header_id = P_CBS_HEADER_ID));

279: EXISTS
280: (SELECT *
281: FROM PA_PROJECTS_ALL
282: WHERE CBS_VERSION_ID =
283: (select rbs_version_id from pa_rbs_versions_b where rbs_header_id = P_CBS_HEADER_ID));
284:
285: begin
286:
287: open c1;