APPS.JTF_TERR_JSP_REPORTS dependencies on JTF_TERR_USGS

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

353: TRUNC(j.start_date_active) <= NVL(p_param4, lp_sysdate)
354: )
355: AND EXISTS
356: ( select jtr.terr_id
357: from jtf_terr_rsc jtr, jtf_terr_qual jtq, jtf_terr_usgs jtu
358: where jtr.terr_id = jtq.terr_id
359: and jtr.terr_id = jtu.terr_id
360: and jtr.resource_id = decode(l_resource_id ,null, jtr.resource_id, l_resource_id)
361: /* ARPATEL: 10/16, bug#2832442 */

Line 389: from jtf_terr j, jtf_terr_usgs jtu

385: --dbms_output.put_line('creating changes cursor ');
386: open terr_name_cur for
387: select j.terr_id, WF_NOTIFICATION.SubstituteSpecialChars(j.name) name, j.rank, j.start_date_active, j.end_date_active,
388: j.last_update_date, WF_NOTIFICATION.SubstituteSpecialChars(j.description) description
389: from jtf_terr j, jtf_terr_usgs jtu
390: where 1=1
391: --and j.terr_id = '19027'
392: AND j.terr_id = jtu.terr_id
393: AND j.start_date_active <= sysdate

Line 1049: from jtf_terr_usgs_all jtua

1045: COUNT(*) INACTIVE_TERR_COUNT
1046: FROM jtf_terr_all jt
1047: WHERE
1048: exists ( select jtua.terr_id
1049: from jtf_terr_usgs_all jtua
1050: where jtua.source_id = p_param2 and jtua.terr_id = jt.terr_id)
1051: and NOT EXISTS ( SELECT jtdr.terr_id
1052: FROM jtf_terr_denorm_rules_all jtdr
1053: WHERE jtdr.terr_id = jt.terr_id );

Line 1063: from jtf_terr_usgs_all jtua

1059: hou.organization_id org_id
1060: FROM jtf_terr_all jt, hr_organization_units hou
1061: WHERE jt.org_id = hou.organization_id
1062: and exists ( select jtua.terr_id
1063: from jtf_terr_usgs_all jtua
1064: where jtua.source_id = p_param2 and jtua.terr_id = jt.terr_id)
1065: AND NOT EXISTS ( SELECT jtdr.terr_id
1066: FROM jtf_terr_denorm_rules_all jtdr
1067: WHERE jtdr.terr_id = jt.terr_id )