APPS.PER_RI_WORKBENCH_UTILITY dependencies on PER_RI_SETUP_TASKS

Line 55: FROM per_ri_setup_tasks

51:
52: CURSOR csr_setup_task_status (p_workbench_item_code varchar2,
53: p_workbench_item_type varchar2) IS
54: SELECT DISTINCT setup_task_status
55: FROM per_ri_setup_tasks
56: WHERE workbench_item_code = p_workbench_item_code
57: ORDER BY setup_task_status;
58:
59: l_proc varchar2(72) := g_package || 'get_item_status_name';

Line 179: FROM per_ri_setup_tasks

175: return varchar2 IS
176:
177: CURSOR csr_modified_date (p_workbench_item_code varchar2) IS
178: SELECT max(setup_task_last_modified_date)
179: FROM per_ri_setup_tasks
180: WHERE workbench_item_code = p_workbench_item_code;
181:
182: l_proc varchar2(72) := g_package || 'get_item_last_modified_date';
183: l_item_last_modified_date varchar2(60);

Line 203: -- or 'Per_RI_Setup_tasks.Setup_task_code' as function name and

199: --------------------------------------------------------------------------
200: -- This function checks whether the function name passed is
201: -- attached to the current responsibility
202: -- The function expects either 'Per_Ri_Workbench_Items.WorkbenchItemCode'
203: -- or 'Per_RI_Setup_tasks.Setup_task_code' as function name and
204: -- item type (whether Workbench Item or Setup Task Item) as inputs
205: --------------------------------------------------------------------------
206:
207: