APPS.CSP_SCH_INT_PVT dependencies on JTF_TASK_STATUSES_VL

Line 1230: from jtf_task_statuses_vl jtsv,

1226: WHERE crh.TASK_ID = p_task_id;
1227:
1228: cursor c_accepted_flag is
1229: select nvl(jtsv.accepted_flag,'N')
1230: from jtf_task_statuses_vl jtsv,
1231: jtf_task_assignments jta
1232: where jta.task_assignment_id = p_task_assignment_id
1233: and jtsv.task_status_id = jta.assignment_status_id;
1234:

Line 8081: from jtf_task_statuses_vl

8077: where header_id = c_header_id;
8078:
8079: cursor cleanup_needed IS
8080: select 'Y'
8081: from jtf_task_statuses_vl
8082: where task_status_id = l_task_status_id
8083: and ( CANCELLED_FLAG = 'Y' or rejected_flag = 'Y');
8084:
8085: cursor get_line_details(c_order_header_id Number) is