APPS.PA_PROGRESS_PUB dependencies on PA_RESOURCE_LIST_MEMBERS

Line 14174: from pa_resource_list_members

14170:
14171: -- cursor to get resource_list_member_id's resource_class code
14172: cursor get_resource_class_code is
14173: select resource_class_code
14174: from pa_resource_list_members
14175: where resource_list_member_id = l_res_list_member_id;
14176:
14177: -- cursor to check if resource_list_memebr_id is that of a planned assignment
14178: cursor get_assignment_info is

Line 14413: pa_resource_list_members rlm

14409: CURSOR get_res_assignment_name (l_resource_assignment_id NUMBER)
14410: IS
14411: SELECT rlm.ALIAS
14412: FROM pa_resource_assignments ra,
14413: pa_resource_list_members rlm
14414: WHERE ra.resource_list_member_id=rlm.resource_list_member_id
14415: AND ra.resource_assignment_id =l_resource_assignment_id;
14416: CURSOR get_budget_version_name(l_budget_version_id NUMBER)
14417: IS

Line 14422: l_res_assignment_name pa_resource_list_members.alias%type;

14418: SELECT version_name
14419: FROM pa_budget_versions
14420: WHERE budget_version_id=l_budget_version_id;
14421: l_element_number pa_proj_elements.element_number%type;
14422: l_res_assignment_name pa_resource_list_members.alias%type;
14423: l_plan_version_name pa_budget_versions.version_name%type;
14424: --added for the Bug 13640836
14425: BEGIN
14426: pa_debug.set_process('PLSQL');

Line 14794: from pa_resource_list_members

14790:
14791: if (l_uncategorized_flag = 'Y') then
14792: select resource_list_member_id
14793: into l_ppl_res_list_mem_id
14794: from pa_resource_list_members
14795: where resource_class_code = 'PEOPLE'
14796: and resource_class_flag = 'Y'
14797: and resource_list_id = res_list_ids_tbl(l_index);
14798: end if;