APPS.JTF_EC_UTIL dependencies on JTF_TASKS_B

Line 312: from jtf_tasks_b t,

308:
309: cursor c_esc_doc_exists_id( P_OBJECT_TYPE_CODE VARCHAR2,
310: P_OBJECT_ID NUMBER) Is
311: Select r.task_reference_id
312: from jtf_tasks_b t,
313: jtf_task_references_b r,
314: jtf_ec_statuses_vl s
315: where r.reference_code = 'ESC'
316: and r.object_id = p_object_id

Line 328: from jtf_tasks_b t,

324:
325: cursor c_esc_doc_exists_name( P_OBJECT_TYPE_CODE VARCHAR2,
326: P_OBJECT_NAME VARCHAR2) Is
327: Select r.task_reference_id
328: from jtf_tasks_b t,
329: jtf_task_references_b r,
330: jtf_ec_statuses_vl s
331: where r.reference_code = 'ESC'
332: and r.object_name = p_object_name

Line 571: from jtf_tasks_b

567: l_api_name VARCHAR2(30) := 'Valdate_Esc_Document';
568:
569: cursor c_esc_id(p_escal_id NUMBER) Is
570: select task_id
571: from jtf_tasks_b
572: where task_id = p_escal_id
573: and task_type_id = 22;
574:
575: cursor c_esc_number(p_esc_number VARCHAR2) Is

Line 577: from jtf_tasks_b

573: and task_type_id = 22;
574:
575: cursor c_esc_number(p_esc_number VARCHAR2) Is
576: select task_id
577: from jtf_tasks_b
578: where task_number = p_esc_number
579: and task_type_id = 22;
580:
581: l_esc_id jtf_tasks_b.task_id%TYPE;

Line 581: l_esc_id jtf_tasks_b.task_id%TYPE;

577: from jtf_tasks_b
578: where task_number = p_esc_number
579: and task_type_id = 22;
580:
581: l_esc_id jtf_tasks_b.task_id%TYPE;
582:
583: BEGIN
584:
585: -- Initialize API return status to success

Line 649: from jtf_tasks_b t,

645: -- the escalation cannot be closed if there are open tasks for it with restrict_closure_flag = 'Y'
646:
647: cursor c_chk_open_tasks(p_task_id NUMBER) Is
648: select 'x'
649: from jtf_tasks_b t,
650: jtf_task_statuses_vl s
651: where t.source_object_id = p_task_id
652: and t.source_object_type_code = 'ESC'
653: and t.restrict_closure_flag = 'Y'

Line 661: from jtf_tasks_b

657: and nvl(s.closed_flag, 'N') = 'N';
658:
659: cursor c_get_esc_level(p_task_id NUMBER) Is
660: Select escalation_level
661: from jtf_tasks_b
662: where task_id = p_task_id;
663:
664:
665: l_dummy varchar2(1);