APPS.JTF_TASKS_PUB dependencies on JTF_TASK_STATUSES_B

Line 701: FROM jtf_task_statuses_b

697: current_record INTEGER;
698:
699: CURSOR c_owner_status_id(b_owner_status_id jtf_task_all_assignments.assignment_status_id%TYPE) IS
700: SELECT task_status_id
701: FROM jtf_task_statuses_b
702: WHERE task_status_id = b_owner_status_id
703: --AND assigned_flag = 'Y'
704: AND assignment_status_flag = 'Y' -- Fix bug 2500664
705: AND NVL(end_date_active, SYSDATE) >= SYSDATE

Line 2927: l_task_status_id jtf_task_statuses_b.task_status_id%TYPE := p_task_status_id;

2923: /* Modified by TSINGHAL dt 8/10/2003 for bug fix 3182170 End */
2924: l_task_type_name jtf_task_types_tl.NAME%TYPE := p_task_type_name;
2925: l_task_type_id jtf_task_types_b.task_type_id%TYPE := p_task_type_id;
2926: l_task_status_name jtf_task_statuses_tl.NAME%TYPE := p_task_status_name;
2927: l_task_status_id jtf_task_statuses_b.task_status_id%TYPE := p_task_status_id;
2928: l_task_priority_name jtf_task_priorities_tl.NAME%TYPE := p_task_priority_name;
2929: l_task_priority_id jtf_task_priorities_b.task_priority_id%TYPE := p_task_priority_id;
2930: l_assigned_by_name fnd_user.user_name%TYPE := p_assigned_by_name;
2931: l_assigned_by_id NUMBER := p_assigned_by_id;