APPS.PA_RES_LIST_UPGRADE_PKG dependencies on PA_RESOURCE_CLASSES_B

Line 138: FROM pa_res_formats_b fmt, pa_resource_classes_b cls,pa_plan_res_defaults def,

134: cursor res_class_csr is
135: SELECT fmt.resource_class_id,cls.resource_class_code,fmt.res_format_id,
136: def.spread_curve_id, def.etc_method_code, def.mfc_cost_type_id,
137: def.object_id,def.object_type,b.res_type_code
138: FROM pa_res_formats_b fmt, pa_resource_classes_b cls,pa_plan_res_defaults def,
139: pa_res_types_b b
140: WHERE fmt.resource_class_flag = 'Y'
141: AND fmt.resource_class_id = cls.resource_class_id
142: AND def.resource_class_id = cls.resource_class_id

Line 177: FROM pa_resource_classes_tl t,pa_resource_classes_b c

173: ORDER BY m.parent_member_id desc;
174:
175: cursor get_alias_csr is
176: SELECT t.name,t.resource_class_id
177: FROM pa_resource_classes_tl t,pa_resource_classes_b c
178: WHERE t.resource_class_id = c.resource_class_id
179: AND language = userenv('LANG');
180:
181: cursor res_list_form_exists_csr(c_res_list_id pa_resource_lists_all_bg.resource_list_id%type,c_res_for_id pa_res_formats_b.res_format_id%type) is

Line 209: TYPE res_class_id_tbl is table of pa_resource_classes_b.resource_class_id%TYPE

205: TYPE res_alias_tbl is table of pa_resource_classes_tl.name%type
206: index by binary_integer;
207: l_res_alias_tbl res_alias_tbl;
208:
209: TYPE res_class_id_tbl is table of pa_resource_classes_b.resource_class_id%TYPE
210: index by binary_integer;
211: l_res_class_id_tbl res_class_id_tbl;
212:
213: TYPE res_class_flag_tbl is table of pa_res_formats_b.resource_class_flag%TYPE