APPS.AS_LEAD_ROUTING_WF dependencies on JTF_RS_RESOURCE_EXTNS

Line 255: FROM jtf_rs_resource_extns res

251: l_rs_id NUMBER := NULL;
252:
253: CURSOR C_get_current_resource IS
254: SELECT res.resource_id
255: FROM jtf_rs_resource_extns res
256: WHERE res.category = 'EMPLOYEE'
257: AND res.user_id = fnd_global.user_id;
258:
259: CURSOR c_get_group_id(c_resource_id NUMBER) IS

Line 287: FROM jtf_rs_resource_extns res

283: -- may not have person_id for all resources. Therefore, get person_id
284: -- in this cursor, instead of in the above cursor.
285: CURSOR c_get_person_id(c_resource_id NUMBER) IS
286: SELECT res.source_id
287: FROM jtf_rs_resource_extns res
288: WHERE res.resource_id = c_resource_id;
289:
290: BEGIN
291: l_rs_id := fnd_profile.value('AS_DEFAULT_RESOURCE_ID');