APPS.JTF_TERR_JSP_REPORTS dependencies on JTF_TERR_USGS

Line 333: from jtf_terr_rsc jtr, jtf_terr_qual jtq, jtf_terr_usgs jtu

329: TRUNC(j.start_date_active) <= NVL(p_param4, lp_sysdate)
330: )
331: AND EXISTS
332: ( select jtr.terr_id
333: from jtf_terr_rsc jtr, jtf_terr_qual jtq, jtf_terr_usgs jtu
334: where jtr.terr_id = jtq.terr_id
335: and jtr.terr_id = jtu.terr_id
336: and jtr.resource_id = decode(l_resource_id ,null, jtr.resource_id, l_resource_id)
337: /* ARPATEL: 10/16, bug#2832442 */

Line 365: from jtf_terr j, jtf_terr_usgs jtu

361: --dbms_output.put_line('creating changes cursor ');
362: open terr_name_cur for
363: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,
364: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description
365: from jtf_terr j, jtf_terr_usgs jtu
366: where 1=1
367: --and j.terr_id = '19027'
368: AND j.terr_id = jtu.terr_id
369: AND j.start_date_active <= sysdate

Line 1025: from jtf_terr_usgs_all jtua

1021: COUNT(*) INACTIVE_TERR_COUNT
1022: FROM jtf_terr_all jt
1023: WHERE
1024: exists ( select jtua.terr_id
1025: from jtf_terr_usgs_all jtua
1026: where jtua.source_id = p_param2 and jtua.terr_id = jt.terr_id)
1027: and NOT EXISTS ( SELECT jtdr.terr_id
1028: FROM jtf_terr_denorm_rules_all jtdr
1029: WHERE jtdr.terr_id = jt.terr_id );

Line 1039: from jtf_terr_usgs_all jtua

1035: hou.organization_id org_id
1036: FROM jtf_terr_all jt, hr_organization_units hou
1037: WHERE jt.org_id = hou.organization_id
1038: and exists ( select jtua.terr_id
1039: from jtf_terr_usgs_all jtua
1040: where jtua.source_id = p_param2 and jtua.terr_id = jt.terr_id)
1041: AND NOT EXISTS ( SELECT jtdr.terr_id
1042: FROM jtf_terr_denorm_rules_all jtdr
1043: WHERE jtdr.terr_id = jt.terr_id )