APPS.CSF_REQUIRED_SKILLS_PKG dependencies on JTF_TASK_STATUSES_B
Line 521: from jtf_tasks_b a, jtf_task_statuses_b b
517:
518: cursor c_parent_task_id(p_task_id number)
519: is
520: select a.parent_task_id 521: from jtf_tasks_b a, jtf_task_statuses_b b 522: where a.task_id = p_task_id
523: and a.task_status_id = b.task_status_id
524: and nvl(task_split_flag, 'N') = 'D'
525: and nvl(b.cancelled_flag, 'N') <> 'Y';