APPS.PA_PROGRESS_PUB dependencies on PA_RESOURCE_LIST_MEMBERS

Line 13687: from pa_resource_list_members

13683:
13684: -- cursor to get resource_list_member_id's resource_class code
13685: cursor get_resource_class_code is
13686: select resource_class_code
13687: from pa_resource_list_members
13688: where resource_list_member_id = l_res_list_member_id;
13689:
13690: -- cursor to check if resource_list_memebr_id is that of a planned assignment
13691: cursor get_assignment_info is

Line 14266: from pa_resource_list_members

14262:
14263: if (l_uncategorized_flag = 'Y') then
14264: select resource_list_member_id
14265: into l_ppl_res_list_mem_id
14266: from pa_resource_list_members
14267: where resource_class_code = 'PEOPLE'
14268: and resource_class_flag = 'Y'
14269: and resource_list_id = res_list_ids_tbl(l_index);
14270: end if;