APPS.PA_RES_LIST_UPGRADE_PKG dependencies on PA_RESOURCE_TYPES

Line 153: FROM pa_resource_lists_all_bg b, pa_resource_types t

149: b.last_update_login, b.creation_date, b.created_by, b.last_update_date,
150: b.last_updated_by, b.name,t.resource_type_code,
151: decode(nvl(t.resource_type_code,'None'),'None',0, 'REVENUE_CATEGORY',300,
152: 'EXPENDITURE_CATEGORY',100, 'ORGANIZATION',200, 0 ) grp_seq
153: FROM pa_resource_lists_all_bg b, pa_resource_types t
154: WHERE t.resource_type_id(+) = b.group_resource_type_id and
155: b.resource_list_id = c_res_list_id and
156: EXISTS ( select 'X' from pa_resource_list_members m
157: WHERE m.res_format_id is null and m.resource_list_id = b.resource_list_id

Line 166: FROM pa_resource_list_members m,pa_resource_types t,

162: m.organization_id,m.revenue_category, m.expenditure_category,m.expenditure_type,
163: decode(rl.uncategorized_flag,'Y',9,decode(nvl(t.resource_type_code,'None'),'None',0 , 'EMPLOYEE',1, 'EXPENDITURE_CATEGORY',
164: 2, 'EXPENDITURE_TYPE', 3, 'JOB',4,'ORGANIZATION',5, 'REVENUE_CATEGORY',6,'EVENT_TYPE',
165: 7,'VENDOR', 8, 'UNCATEGORIZED',9,-1 )) + decode(nvl(track_as_labor_flag,'N'),'Y',0,15) res_seq,t.resource_type_code
166: FROM pa_resource_list_members m,pa_resource_types t,
167: pa_resource_lists_all_bg rl
168: WHERE m.resource_list_id = l_res_list_id
169: AND m.resource_type_id = t.resource_type_id(+)
170: AND m.res_format_id is null