DBA Data[Home] [Help]

APPS.IEX_DUNNING_PVT dependencies on JTF_TASK_STATUSES_TL

Line 16999: FROM jtf_task_statuses_vl jvl , jtf_task_statuses_tl jtl

16995: AND trunc(NVL (jvl.end_date_active, SYSDATE)) >= trunc(SYSDATE)
16996: AND trunc(NVL (jvl.start_date_active, SYSDATE)) <= trunc(SYSDATE);
16997:
16998: SELECT jvl.name into l_statusname
16999: FROM jtf_task_statuses_vl jvl , jtf_task_statuses_tl jtl
17000: WHERE jvl.task_status_id= jtl.task_status_id
17001: AND jtl.language='US'
17002: AND jtl.name = 'Open'
17003: AND trunc(NVL (jvl.end_date_active, SYSDATE)) >= trunc(SYSDATE)