DBA Data[Home] [Help]

APPS.IEX_DUNNING_PVT dependencies on JTF_TASK_TYPES_VL

Line 16991: FROM jtf_task_types_vl jvl , jtf_task_types_tl jtl

16987: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - dunning_id='||l_dunning_id);
16988:
16989: --fix start for bug 14036760 by sunagesh on 08-05-12
16990: SELECT jvl.name into l_taskname
16991: FROM jtf_task_types_vl jvl , jtf_task_types_tl jtl
16992: WHERE jvl.task_type_id= jtl.task_type_id
16993: AND jtl.language='US'
16994: AND jtl.name = 'Callback'
16995: AND trunc(NVL (jvl.end_date_active, SYSDATE)) >= trunc(SYSDATE)