APPS.JTF_TERR_ENGINE_GEN_PVT dependencies on JTF_TERR_USGS_ALL

Line 281: DELETE from JTF_TERR_USGS_ALL jtu

277: WHERE jt.terr_group_flag = 'Y' );
278:
279:
280: --Delete Territory usgs
281: DELETE from JTF_TERR_USGS_ALL jtu
282: WHERE jtu.terr_id IN
283: ( SELECT jt.terr_id
284: FROM jtf_terr_all jt
285: WHERE jt.terr_group_flag = 'Y' );

Line 3699: , jtf_terr_usgs_all jtu

3695: , lp_qual_type_id NUMBER
3696: , lp_sysdate DATE ) IS
3697: SELECT 'TRUE'
3698: FROM jtf_terr_qtype_usgs_all jtqu
3699: , jtf_terr_usgs_all jtu
3700: , jtf_terr_all jt1
3701: , jtf_qual_type_usgs jqtu
3702: WHERE jtqu.terr_id = jt1.terr_id
3703: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id

Line 4418: FROM jtf_terr_usgs_all jtu

4414: AND jrrev.resource_id = jtr.resource_id )
4415: WHERE jtr.resource_type= 'RS_EMPLOYEE'
4416: AND jtr.terr_id IN
4417: ( SELECT jtu.terr_id
4418: FROM jtf_terr_usgs_all jtu
4419: WHERE jtu.source_id = p_source_id )
4420: AND EXISTS
4421: ( SELECT jrrev.resource_id
4422: FROM jtf_rs_resource_extns_vl jrrev