APPS.JTF_TERR_ENGINE_GEN_PVT dependencies on JTF_TERR_RSC_ALL

Line 292: FROM jtf_terr_rsc_all jtr, jtf_terr_all jt

288: --Delete Territory Resource Access
289: DELETE from JTF_TERR_RSC_ACCESS_ALL jtra
290: WHERE jtra.terr_rsc_id IN
291: ( SELECT jtr.terr_rsc_id
292: FROM jtf_terr_rsc_all jtr, jtf_terr_all jt
293: WHERE jtr.terr_id = jt.terr_id
294: AND jt.terr_group_flag = 'Y' );
295:
296:

Line 298: DELETE from JTF_TERR_RSC_ALL jtr

294: AND jt.terr_group_flag = 'Y' );
295:
296:
297: -- Delete the Territory Resource records
298: DELETE from JTF_TERR_RSC_ALL jtr
299: WHERE jtr.terr_id IN
300: ( SELECT jt.terr_id
301: FROM jtf_terr_all jt
302: WHERE jt.terr_group_flag = 'Y' );

Line 3711: FROM jtf_terr_rsc_all jtrs

3707: AND NVL(jt1.end_date_active, lp_sysdate) >= lp_sysdate
3708: AND jt1.start_date_active <= lp_sysdate
3709: AND EXISTS (
3710: SELECT jtrs.terr_rsc_id
3711: FROM jtf_terr_rsc_all jtrs
3712: WHERE NVL(jtrs.end_date_active, lp_sysdate) >= lp_sysdate
3713: AND NVL(jtrs.start_date_active, lp_sysdate) <= lp_sysdate
3714: AND jtrs.terr_id = jt1.terr_id )
3715: AND NOT EXISTS (

Line 3882: FROM jtf_terr_rsc_all jtr

3878: UPDATE jtf_terr_denorm_rules_all j
3879: SET j.resource_exists_flag = 'Y'
3880: WHERE EXISTS
3881: ( SELECT jtr.terr_id
3882: FROM jtf_terr_rsc_all jtr
3883: WHERE (jtr.end_date_active IS NULL OR jtr.end_date_active >= SYSDATE)
3884: AND (jtr.start_date_active IS NULL OR jtr.start_date_active <= SYSDATE)
3885: AND jtr.terr_id = j.terr_id
3886: )

Line 3984: FROM jtf_terr_rsc_all jtr

3980: UPDATE jtf_terr_denorm_rules_all j
3981: SET j.resource_exists_flag = 'Y'
3982: WHERE EXISTS
3983: ( SELECT jtr.terr_id
3984: FROM jtf_terr_rsc_all jtr
3985: WHERE (jtr.end_date_active IS NULL OR jtr.end_date_active >= SYSDATE)
3986: AND (jtr.start_date_active IS NULL OR jtr.start_date_active <= SYSDATE)
3987: AND jtr.terr_id = j.terr_id
3988: )

Line 4191: FROM jtf_terr_rsc_all jtr

4187: UPDATE jtf_terr_denorm_rules_all j
4188: SET j.resource_exists_flag = 'Y'
4189: WHERE EXISTS
4190: ( SELECT jtr.terr_id
4191: FROM jtf_terr_rsc_all jtr
4192: WHERE (jtr.end_date_active IS NULL OR jtr.end_date_active >= SYSDATE)
4193: AND (jtr.start_date_active IS NULL OR jtr.start_date_active <= SYSDATE)
4194: AND jtr.terr_id = j.terr_id
4195: )

Line 4249: FROM jtf_terr_rsc_all jtr

4245: UPDATE jtf_terr_denorm_rules_all j
4246: SET j.resource_exists_flag = 'Y'
4247: WHERE EXISTS
4248: ( SELECT jtr.terr_id
4249: FROM jtf_terr_rsc_all jtr
4250: WHERE (jtr.end_date_active IS NULL OR jtr.end_date_active >= SYSDATE)
4251: AND (jtr.start_date_active IS NULL OR jtr.start_date_active <= SYSDATE)
4252: AND jtr.terr_id = j.terr_id
4253: )

Line 4409: UPDATE jtf_terr_rsc_all jtr

4405: END;
4406:
4407:
4408: /* PERSON_ID required for OSO TAP */
4409: UPDATE jtf_terr_rsc_all jtr
4410: SET jtr.person_id =
4411: ( SELECT jrrev.source_id
4412: FROM jtf_rs_resource_extns_vl jrrev
4413: WHERE jrrev.category = 'EMPLOYEE'

Line 4436: --dbms_output.put_line('UPDATING JTF_TERR_RSC_ALL.PERSON_ID: ERROR = ' || sqlerrm);

4432: END;
4433:
4434: EXCEPTION
4435: WHEN OTHERS THEN
4436: --dbms_output.put_line('UPDATING JTF_TERR_RSC_ALL.PERSON_ID: ERROR = ' || sqlerrm);
4437: NULL;
4438: END;
4439:
4440: /* JDOCHERT: 12/09/03: bug#3307414