DBA Data[Home] [Help]

APPS.PA_RBS_ELEMENTS_PUB dependencies on PA_RBS_ELEMENT_NAMES_VL

Line 11: from pa_rbs_elements pre , pa_rbs_element_names_vl v

7: procedure cbs_generate_cost_code(P_RBS_Version_Id IN Number,P_Element_Id IN number,P_Cost_Code IN varchar2,P_Cost_Code_Name IN varchar2)
8: IS
9: Cursor Cur_get_child_node is
10: select rbs_element_id,level_code,RESOURCE_NAME
11: from pa_rbs_elements pre , pa_rbs_element_names_vl v
12: where pre.rbs_element_name_id=v.rbs_element_name_id and pre.rbs_version_id=P_RBS_Version_Id
13: START WITH pre.parent_element_id = p_element_id
14: CONNECT BY PRIOR pre.rbs_element_id = pre.parent_element_id;
15: BEGIN