APPS.PA_ALLOC_UTILS dependencies on PA_RESOURCE_LIST_MEMBERS

Line 590: from pa_resource_list_members prlm

586: If p_alloc_type In ('SOURCE' , 'S') Then
587: If l_source_res_struct_type = 'RL' Then
588: select prlm.alias
589: Into X_name
590: from pa_resource_list_members prlm
591: where prlm.resource_list_member_id = p_resource_id;
592: Elsif l_source_res_struct_type = 'RBS' Then
593: Select pa_alloc_utils.Get_Resource_Name_TL (RBS_ELEMENT_NAME_ID)
594: Into X_name

Line 604: from pa_resource_list_members prlm

600: ElsIf p_alloc_type In ('BASIS', 'B' ) Then
601: If l_basis_res_struct_type = 'RL' Then
602: select prlm.alias
603: Into X_name
604: from pa_resource_list_members prlm
605: where prlm.resource_list_member_id = p_resource_id;
606: Elsif l_basis_res_struct_type = 'RBS' Then
607: select pa_alloc_utils.Get_Resource_Name_TL (RBS_ELEMENT_NAME_ID)
608: Into X_name

Line 789: l_self_name pa_resource_list_members.alias%type;

785: Function GET_CONCATENATED_NAME (p_resource_id in Number , p_struct_type in Varchar2 ) Return
786:
787: Varchar2 Is
788: X_Resource_Name Varchar2(10000);
789: l_self_name pa_resource_list_members.alias%type;
790: l_parent_name pa_resource_list_members.alias%type;
791: l_element_name Varchar2(240);
792: l_count Number;
793: Cursor C_Member_Name

Line 790: l_parent_name pa_resource_list_members.alias%type;

786:
787: Varchar2 Is
788: X_Resource_Name Varchar2(10000);
789: l_self_name pa_resource_list_members.alias%type;
790: l_parent_name pa_resource_list_members.alias%type;
791: l_element_name Varchar2(240);
792: l_count Number;
793: Cursor C_Member_Name
794: Is Select slf.alias , prt.alias

Line 795: from pa_resource_list_members slf , pa_resource_list_members prt

791: l_element_name Varchar2(240);
792: l_count Number;
793: Cursor C_Member_Name
794: Is Select slf.alias , prt.alias
795: from pa_resource_list_members slf , pa_resource_list_members prt
796: Where prt.resource_list_member_id (+) = slf.parent_member_id
797: and slf.resource_list_member_id = p_resource_id;
798: Cursor c_element_name
799: IS SELECT pa_alloc_utils.Get_Resource_Name_TL(ele.rbs_element_name_id) Resource_Name