APPS.CS_WF_ACTIVITIES_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 446: FROM jtf_rs_resource_extns emp

442: l_source_id NUMBER;
443:
444: CURSOR l_get_source_id IS
445: SELECT emp.source_id
446: FROM jtf_rs_resource_extns emp
447: WHERE emp.resource_id = l_incident_owner_id;
448:
449: /*** end New 03/17/03. rmanabat ***/
450:

Line 809: select resource_id from jtf_rs_resource_extns

805: -- Fix for bug 1361599, if end_date_active is null, record is not selected
806: -- modify the cursor below added nvl(end_date_active,sysdate +1)
807: --
808: CURSOR sel_resource_csr IS
809: select resource_id from jtf_rs_resource_extns
810: where source_id = l_new_owner_id
811: and category = 'EMPLOYEE'
812: and sysdate between start_date_active and nvl(end_date_active,sysdate + 1);
813: