APPS.JTF_TTY_MAINTAIN_NA_PVT dependencies on JTF_RS_RESOURCE_EXTNS

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:

Line 1294: jtf_rs_resource_extns res

1290: SELECT 'VALID'
1291: INTO l_select
1292: FROM jtf_tty_srch_my_resources_v /*jtf_tty_my_resources_v*/ grv,
1293: jtf_tty_terr_grp_owners jto,
1294: jtf_rs_resource_extns res
1295: WHERE EXISTS
1296: ( SELECT NULL
1297: FROM jtf_rs_groups_denorm grpd
1298: WHERE /* part of Salesgroup hierarchy of Territory Group owner */