APPS.JTF_TASK_UTL dependencies on JTF_TERR

Line 2031: FROM jtf_terr_all

2027: IS
2028: CURSOR c_terr_id
2029: IS
2030: SELECT terr_id
2031: FROM jtf_terr_all
2032: WHERE terr_id = p_terr_id
2033: AND trunc(NVL (end_date_active, SYSDATE)) >= trunc(SYSDATE)
2034: AND trunc(NVL (start_date_active, SYSDATE)) <= trunc(SYSDATE);
2035:

Line 2039: FROM jtf_terr_all

2035:
2036: CURSOR c_terr_name
2037: IS
2038: SELECT terr_id
2039: FROM jtf_terr_all
2040: WHERE name = p_terr_name
2041: AND trunc(NVL (end_date_active, SYSDATE)) >= trunc(SYSDATE)
2042: AND trunc(NVL (start_date_active, SYSDATE)) <= trunc(SYSDATE);
2043: BEGIN

Line 3090: FROM jtf_terr

3086: IF p_terr_id IS NOT NULL
3087: THEN
3088: SELECT name
3089: INTO l_terr_name
3090: FROM jtf_terr
3091: WHERE terr_id = p_terr_id;
3092: END IF;
3093:
3094: RETURN l_terr_name;