APPS.IEX_DUNNING_PVT dependencies on JTF_TASK_TYPES_TL

Line 16565: ||' jtf_task_types_tl typ,'

16561: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Cancelling the Dunning callback tasks correpsonding to current objects...');
16562: l_task_query := 'select tsk.task_id,'
16563: ||'tsk.object_version_number'
16564: ||' from jtf_tasks_b tsk,'
16565: ||' jtf_task_types_tl typ,'
16566: ||' jtf_task_statuses_b st,'
16567: ||' jtf_task_references_b ref,'
16568: ||' iex_dunnings dun'
16569: ||' where tsk.task_type_id=typ.task_type_id'

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)