DBA Data[Home] [Help]

APPS.PA_RES_LIST_UPGRADE_PKG dependencies on PA_RESOURCE_CLASSES_TL

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 205: TYPE res_alias_tbl is table of pa_resource_classes_tl.name%type

201: TYPE res_class_csr_tbl is table of res_class_csr%ROWTYPE
202: index by binary_integer;
203: l_res_class_csr_tbl res_class_csr_tbl;
204:
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