APPS.CSL_JTF_TASKS_ACC_PKG dependencies on JTF_TASK_STATUSES_B

Line 30: FROM JTF_TASK_STATUSES_B

26: r_task c_task%ROWTYPE;
27:
28: CURSOR c_task_status (b_task_status_id NUMBER) IS
29: SELECT null
30: FROM JTF_TASK_STATUSES_B
31: WHERE TASK_STATUS_ID = b_task_status_id
32: AND (
33: NVL(ASSIGNED_FLAG, 'N') = 'Y'
34: OR NVL(CANCELLED_FLAG, 'N') = 'Y'

Line 951: jtf_task_statuses_b jts

947: CURSOR lcur_purge_tasks IS
948: SELECT acc.task_id, acc.resource_id
949: FROM csl_jtf_tasks_acc acc,
950: jtf_tasks_b jt,
951: jtf_task_statuses_b jts
952: WHERE acc.task_id = jt.task_id
953: AND jts.task_status_id = jt.task_status_id
954: AND (NVL(jt.scheduled_start_date, SYSDATE) < (SYSDATE - TO_NUMBER(FND_PROFILE.Value('CSL_APPL_HISTORY_IN_DAYS'))))
955: AND (NVL(jts.cancelled_flag,'N') = 'Y'