DBA Data[Home] [Help]

APPS.CSF_REQUIRED_SKILLS_PKG dependencies on JTF_TASKS_B

Line 32: From jtf_tasks_b

28: RETURN boolean
29: IS
30: Cursor c_task is
31: Select 1
32: From jtf_tasks_b
33: Where task_id = p_task_id;
34: l_dummy_var number;
35: BEGIN
36: /* Check if the task exists. */

Line 188: ') does not exist in JTF_TASKS_B table.';

184: If not task_exists (p_task_id) then
185: X_return_status := fnd_api.g_ret_sts_error;
186: X_msg_count := 1;
187: X_msg_data := 'Task Id ('||to_char(p_task_id)||
188: ') does not exist in JTF_TASKS_B table.';
189: return;
190: end if;
191:
192: /* Checks if skill type and id exist. */

Line 334: from jtf_tasks_b tb

330: l_task_id number ;
331:
332: Cursor c_ProdSkill is
333: select mtl.inventory_item_id
334: from jtf_tasks_b tb
335: , cs_incidents_all_b sr
336: , mtl_system_items_kfv mtl
337: where mtl.organization_id = fnd_profile.value('CSF_INVENTORY_ORG')
338: and sysdate between nvl(mtl.start_date_active,sysdate) and nvl(mtl.end_date_active,sysdate)