APPS.AS_SALES_METH_WF dependencies on JTF_TASKS_B

Line 410: CURSOR c_current_stage IS SELECT a.task_id FROM jtf_tasks_b a,as_sales_meth_task_map b,

406: l_task_name VARCHAR2(100);
407: l_task_number NUMBER;
408: l_meth_note_type VARCHAR2(100);
409: n NUMBER :=0;
410: CURSOR c_current_stage IS SELECT a.task_id FROM jtf_tasks_b a,as_sales_meth_task_map b,
411: jtf_task_statuses_b c
412: WHERE a.task_id = b.task_id
413: AND a.source_object_type_code = l_source_object_type_code
414: AND a.source_object_id = l_source_object_id

Line 587: FROM JTF_TASKS_B where task_id = l_taask_id;

583: SELECT sales_methodology_id from as_leads_all a
584: WHERE a.lead_id = l_source_object_id;
585: CURSOR c_task IS
586: SELECT template_id,template_group_id
587: FROM JTF_TASKS_B where task_id = l_taask_id;
588:
589: -- Added for bug 2596419 start
590:
591: CURSOR c_customer_info (c_lead_id NUMBER) IS