APPS.IEX_PROMISES_BATCH_PUB dependencies on JTF_TASK_TYPES_VL

Line 2944: FROM jtf_task_types_vl jvl , jtf_task_types_tl jtl

2940: AND trunc(NVL (jvl.start_date_active, SYSDATE)) <= trunc(SYSDATE);
2941: LogMessage('Status name - '||l_statusname);
2942:
2943: SELECT jvl.name into l_taskname
2944: FROM jtf_task_types_vl jvl , jtf_task_types_tl jtl
2945: WHERE jvl.task_type_id= jtl.task_type_id
2946: AND jtl.language='US'
2947: AND jtl.name = 'Callback'
2948: AND trunc(NVL (jvl.end_date_active, SYSDATE)) >= trunc(SYSDATE)