APPS.JTF_TTY_MAINTAIN_NA_PVT dependencies on JTF_RS_RESOURCE_EXTNS_VL

Line 1033: FROM jtf_rs_resource_extns_vl

1029: l_res_tbl NUMBER_TABLE_TYPE := NUMBER_TABLE_TYPE();
1030:
1031: CURSOR c_get_resource_id ( c_resource_name VARCHAR2 ) IS
1032: SELECT RESOURCE_id
1033: FROM jtf_rs_resource_extns_vl
1034: WHERE upper(resource_name) = upper(c_resource_name)
1035: AND category = 'EMPLOYEE'
1036: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE+1);
1037: