APPS.IEX_DUNNING_PVT dependencies on JTF_TASK_STATUSES_VL

Line 16999: FROM jtf_task_statuses_vl jvl , jtf_task_statuses_tl jtl

16995: AND trunc(NVL (jvl.end_date_active, SYSDATE)) >= trunc(SYSDATE)
16996: AND trunc(NVL (jvl.start_date_active, SYSDATE)) <= trunc(SYSDATE);
16997:
16998: SELECT jvl.name into l_statusname
16999: FROM jtf_task_statuses_vl jvl , jtf_task_statuses_tl jtl
17000: WHERE jvl.task_status_id= jtl.task_status_id
17001: AND jtl.language='US'
17002: AND jtl.name = 'Open'
17003: AND trunc(NVL (jvl.end_date_active, SYSDATE)) >= trunc(SYSDATE)

Line 17254: FROM jtf_tasks_vl t, jtf_task_statuses_vl s

17250: AND nvl(rs.end_date_active,sysdate) >= trunc(sysdate);
17251:
17252: CURSOR c_resource_task_count_OLD(p_party_id NUMBER) IS
17253: SELECT t.owner_id, count(t.owner_id)
17254: FROM jtf_tasks_vl t, jtf_task_statuses_vl s
17255: WHERE t.customer_id = p_party_id
17256: AND upper(t.owner_type_code) = 'RS_EMPLOYEE'
17257: AND t.task_name = 'Dunning Callback'
17258: AND t.task_status_id = s.task_status_id

Line 17278: jtf_task_statuses_vl s2

17274: AND acc.customer_id = p_party_id
17275: AND nvl(rs.end_date_active,sysdate) >= trunc(sysdate)
17276: AND rs.resource_id not in ( select distinct t2.owner_id
17277: from jtf_tasks_vl t2,
17278: jtf_task_statuses_vl s2
17279: where t2.customer_id = p_party_id
17280: and upper(t2.owner_type_code) = 'RS_EMPLOYEE'
17281: AND t2.task_status_id = s2.task_status_id
17282: AND upper(s2.name) = 'OPEN'

Line 17287: FROM jtf_tasks_vl t, jtf_task_statuses_vl s

17283: and t2.task_name = 'Dunning Callback');
17284:
17285: CURSOR c_resource_mintask(p_party_id NUMBER) IS
17286: SELECT t.owner_id --, count(t.owner_id)
17287: FROM jtf_tasks_vl t, jtf_task_statuses_vl s
17288: WHERE t.customer_id = p_party_id
17289: AND upper(t.owner_type_code) = 'RS_EMPLOYEE'
17290: AND t.task_name = 'Dunning Callback'
17291: AND t.task_status_id = s.task_status_id

Line 17295: from jtf_tasks_vl t2, jtf_task_statuses_vl s2

17291: AND t.task_status_id = s.task_status_id
17292: AND upper(s.name) = 'OPEN'
17293: GROUP BY t.owner_id
17294: HAVING COUNT(t.owner_id) = (select min(count(t2.owner_id))
17295: from jtf_tasks_vl t2, jtf_task_statuses_vl s2
17296: WHERE t2.customer_id = p_party_id
17297: AND upper(t2.owner_type_code) = 'RS_EMPLOYEE'
17298: AND t2.task_name = 'Dunning Callback'
17299: AND t2.task_status_id = s2.task_status_id

Line 17306: FROM jtf_tasks_vl t, jtf_task_statuses_vl s

17302: *=================================================== */
17303:
17304: /*CURSOR c_resource_mintask(p_party_id NUMBER) IS
17305: SELECT t.owner_id --, count(t.owner_id)
17306: FROM jtf_tasks_vl t, jtf_task_statuses_vl s
17307: WHERE t.customer_id = p_party_id
17308: AND upper(t.owner_type_code) = 'RS_EMPLOYEE'
17309: AND t.task_name = 'Dunning Callback'
17310: AND t.task_status_id = s.task_status_id

Line 17322: from jtf_tasks_vl t2, jtf_task_statuses_vl s2

17318: and rs.user_id is not null
17319: AND nvl(rs.end_date_active,sysdate) >= trunc(sysdate) )
17320: GROUP BY t.owner_id
17321: HAVING COUNT(t.owner_id) = (select min(count(t2.owner_id))
17322: from jtf_tasks_vl t2, jtf_task_statuses_vl s2
17323: WHERE t2.customer_id = p_party_id
17324: AND upper(t2.owner_type_code) = 'RS_EMPLOYEE'
17325: AND t2.task_name = 'Dunning Callback'
17326: AND t2.task_status_id = s2.task_status_id

Line 17341: FROM jtf_tasks_vl t, jtf_task_statuses_vl s

17337: --
17338: --
17339: CURSOR c_resource_task_count(p_party_id NUMBER) IS
17340: SELECT t.owner_id, count(t.owner_id)
17341: FROM jtf_tasks_vl t, jtf_task_statuses_vl s
17342: WHERE t.customer_id = p_party_id
17343: AND upper(t.owner_type_code) = 'RS_EMPLOYEE'
17344: AND t.task_name = 'Dunning Callback'
17345: AND t.task_status_id = s.task_status_id

Line 17367: jtf_task_statuses_vl s2

17363: and rs.category = 'EMPLOYEE'
17364: AND rs.user_id is not null
17365: AND rs.resource_id not in ( select distinct t2.owner_id
17366: from jtf_tasks_vl t2,
17367: jtf_task_statuses_vl s2
17368: where t2.customer_id = p_party_id
17369: and upper(t2.owner_type_code) = 'RS_EMPLOYEE'
17370: AND t2.task_status_id = s2.task_status_id
17371: AND upper(s2.name) = 'OPEN'