APPS.JTF_IH_BULK dependencies on JTF_RS_RESOURCE_EXTNS

Line 845: FROM jtf_rs_resource_extns

841: l_resource_id := dbms_xmldom.getAttribute(int_elem, 'resource_id');
842:
843: BEGIN
844: SELECT user_id INTO l_user_id
845: FROM jtf_rs_resource_extns
846: WHERE resource_id = l_resource_id AND
847: ( end_date_active IS NULL OR
848: TRUNC(end_date_active) >= TRUNC(SYSDATE) );
849: