APPS.PA_ALLOC_UTILS dependencies on PA_RESOURCE_LIST_MEMBERS

Line 603: from pa_resource_list_members prlm

599: If p_alloc_type In ('SOURCE' , 'S') Then
600: If l_source_res_struct_type = 'RL' Then
601: select prlm.alias
602: Into X_name
603: from pa_resource_list_members prlm
604: where prlm.resource_list_member_id = p_resource_id;
605: Elsif l_source_res_struct_type = 'RBS' Then
606: Select pa_alloc_utils.Get_Resource_Name_TL (RBS_ELEMENT_NAME_ID)
607: Into X_name

Line 617: from pa_resource_list_members prlm

613: ElsIf p_alloc_type In ('BASIS', 'B' ) Then
614: If l_basis_res_struct_type = 'RL' Then
615: select prlm.alias
616: Into X_name
617: from pa_resource_list_members prlm
618: where prlm.resource_list_member_id = p_resource_id;
619: Elsif l_basis_res_struct_type = 'RBS' Then
620: select pa_alloc_utils.Get_Resource_Name_TL (RBS_ELEMENT_NAME_ID)
621: Into X_name

Line 802: l_self_name pa_resource_list_members.alias%type;

798: Function GET_CONCATENATED_NAME (p_resource_id in Number , p_struct_type in Varchar2 ) Return
799:
800: Varchar2 Is
801: X_Resource_Name Varchar2(10000);
802: l_self_name pa_resource_list_members.alias%type;
803: l_parent_name pa_resource_list_members.alias%type;
804: l_element_name Varchar2(240);
805: l_count Number;
806: Cursor C_Member_Name

Line 803: l_parent_name pa_resource_list_members.alias%type;

799:
800: Varchar2 Is
801: X_Resource_Name Varchar2(10000);
802: l_self_name pa_resource_list_members.alias%type;
803: l_parent_name pa_resource_list_members.alias%type;
804: l_element_name Varchar2(240);
805: l_count Number;
806: Cursor C_Member_Name
807: Is Select slf.alias , prt.alias

Line 808: from pa_resource_list_members slf , pa_resource_list_members prt

804: l_element_name Varchar2(240);
805: l_count Number;
806: Cursor C_Member_Name
807: Is Select slf.alias , prt.alias
808: from pa_resource_list_members slf , pa_resource_list_members prt
809: Where prt.resource_list_member_id (+) = slf.parent_member_id
810: and slf.resource_list_member_id = p_resource_id;
811: Cursor c_element_name
812: IS SELECT pa_alloc_utils.Get_Resource_Name_TL(ele.rbs_element_name_id) Resource_Name