APPS.GMS_SUMMARIZE_BUDGETS dependencies on PA_RESOURCE_LISTS

Line 106: l_res_list_name pa_resource_lists.name%type ;

102: l_award_count number ;
103: l_res_categorized VARCHAR2(1) ;
104: l_validate_profile VARCHAR2(1) := 'N' ;
105: l_time_phased_type_code VARCHAR2(1) ;
106: l_res_list_name pa_resource_lists.name%type ;
107: x_err_code varchar2(1);
108:
109: BEGIN
110: x_return_status := 'S';

Line 167: from GMS_BUDGET_VERSIONS gb , pa_resource_lists rl

163: If l_bem_count >= 1 and l_res_list_count = 1 then
164:
165: select distinct rl.name
166: into l_res_list_name
167: from GMS_BUDGET_VERSIONS gb , pa_resource_lists rl
168: where gb.resource_list_id = rl.resource_list_id
169: and budget_status_code = 'B'
170: and current_flag = 'Y'
171: and project_id = x_project_id ;

Line 279: from pa_resource_lists prl , pa_implementations pai

275:
276: If l_res_categorized = 'N' then
277: select resource_list_id
278: into G_pa_res_list_id_none
279: from pa_resource_lists prl , pa_implementations pai
280: where prl.business_group_id = pai.business_group_id
281: and prl.uncategorized_flag = 'Y'
282: and NVL(prl.migration_code ,'M') = 'M' ;
283: END if ;