APPS.IEX_PROMISES_BATCH_PUB dependencies on JTF_TASK_TYPES_TL

Line 2850: jtf_task_types_tl typ,

2846: select tsk.task_id,
2847: tsk.object_version_number
2848: --,tsk.task_type_id,typ.name task_type, tsk.task_status_id,st.name,tsk.source_object_id
2849: from jtf_tasks_vl tsk,
2850: jtf_task_types_tl typ,
2851: jtf_task_statuses_vl st
2852: where tsk.source_object_type_code='IEX_PROMISE'
2853: and tsk.task_type_id=typ.task_type_id
2854: and typ.name='Callback'

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)