APPS.IEX_UWQ_VIEW_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 16: FROM jtf_rs_resource_extns res

12: AND u.user_id = nvl(x_userid, -1);
13:
14: CURSOR c_get_resource_id(x_person_id Number, x_userid NUMBER, p_category varchar2) IS
15: SELECT res.resource_id
16: FROM jtf_rs_resource_extns res
17: WHERE res.source_id = nvl(x_person_id, -1)
18: AND res.user_id = nvl(x_userid, -1)
19: AND trunc(res.START_DATE_ACTIVE) <= trunc(SYSDATE)
20: AND trunc(SYSDATE) <= trunc(NVL(RES.END_DATE_ACTIVE,SYSDATE))