DBA Data[Home] [Help]

APPS.IEX_PROMISES_BATCH_PUB dependencies on JTF_TASK_STATUSES_VL

Line 2851: jtf_task_statuses_vl st

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'
2855: and tsk.task_status_id=st.task_status_id

Line 2935: FROM jtf_task_statuses_vl jvl , jtf_task_statuses_tl jtl

2931: else
2932:
2933: --fix start for bug 14036760 by sunagesh on 08-05-12
2934: SELECT jvl.name into l_statusname
2935: FROM jtf_task_statuses_vl jvl , jtf_task_statuses_tl jtl
2936: WHERE jvl.task_status_id= jtl.task_status_id
2937: AND jtl.language='US'
2938: AND jtl.name = 'Open'
2939: AND trunc(NVL (jvl.end_date_active, SYSDATE)) >= trunc(SYSDATE)