DBA Data[Home] [Help]

APPS.JTF_AGENDA_CALCULATIONS dependencies on JTF_TASKS_B

Line 668: FROM jtf_tasks_b t,

664: l_object_id NUMBER := p_task_id;
665:
666: CURSOR c_esc IS
667: SELECT NULL
668: FROM jtf_tasks_b t,
669: jtf_task_references_vl r,
670: jtf_ec_statuses_vl s
671: WHERE t.task_id = r.task_id
672: AND t.task_type_id = 22

Line 687: FROM jtf_tasks_b t,

683:
684: CURSOR c_tsk IS
685: SELECT t.source_object_type_code,
686: t.source_object_id
687: FROM jtf_tasks_b t,
688: jtf_task_statuses_vl s
689: WHERE t.task_id = p_task_id
690: AND t.task_status_id = s.task_status_id
691: AND (s.closed_flag = 'N'