APPS.JTF_TTY_NA_GEO_TERR_PVT dependencies on JTF_TTY_GEO_TERR_RSC

Line 3803: JTF_TTY_GEO_TERR_RSC grsc

3799: */
3800: CURSOR get_NON_OVLY_geo_trans(l_geo_territory_id NUMBER) IS
3801: SELECT ra.access_type
3802: FROM
3803: JTF_TTY_GEO_TERR_RSC grsc
3804: , jtf_tty_terr_grp_roles tgr
3805: , jtf_tty_role_access ra
3806: WHERE grsc.GEO_TERRITORY_ID = l_geo_territory_id
3807: AND grsc.rsc_role_code = tgr.role_code

Line 3813: JTF_TTY_GEO_TERR_RSC grsc

3809: AND ra.access_type IN ('ACCOUNT')
3810: UNION
3811: SELECT ra.access_type
3812: FROM
3813: JTF_TTY_GEO_TERR_RSC grsc
3814: , jtf_tty_terr_grp_roles tgr
3815: , jtf_tty_role_access ra
3816: WHERE grsc.GEO_TERRITORY_ID = l_geo_territory_id
3817: AND grsc.rsc_role_code = tgr.role_code

Line 3971: from jtf_tty_geo_terr_rsc a

3967: CURSOR terr_resource (l_geo_territory_id number,l_role varchar2) IS
3968: SELECT distinct a.resource_id
3969: , a.rsc_group_id
3970: , nvl(a.rsc_resource_type,'RS_EMPLOYEE') rsc_resource_type
3971: from jtf_tty_geo_terr_rsc a
3972: , jtf_tty_geo_terr b
3973: where a.geo_territory_id = b.geo_territory_id
3974: and b.geo_territory_id = l_geo_territory_id
3975: and a.rsc_role_code = l_role;

Line 4026: FROM jtf_tty_geo_terr_rsc grsc

4022: AND EXISTS (
4023: /* Salesperson, with Role that has a Product
4024: ** Interest defined, exists for this Named Account */
4025: SELECT NULL
4026: FROM jtf_tty_geo_terr_rsc grsc
4027: , jtf_tty_role_prod_int rpi
4028: , jtf_tty_terr_grp_roles tgr
4029: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id
4030: AND tgr.terr_group_id = gterr.TERR_GROUP_ID

Line 4050: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr

4046: and b.terr_group_id = lp_terr_group_id
4047: AND EXISTS (
4048: /* Named Account exists with Salesperson with this role */
4049: SELECT NULL
4050: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr
4051: WHERE gterr.geo_territory_id = grsc.geo_territory_id
4052: AND grsc.geo_territory_id = lp_geo_territory_id
4053: AND gterr.terr_group_id = b.terr_group_id
4054: AND grsc.rsc_role_code = b.role_code );

Line 4453: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr

4449: and b.terr_group_id = p_terr_group_rec.TERR_GROUP_ID
4450: AND EXISTS (
4451: /* Named Account exists with Salesperson with this role */
4452: SELECT NULL
4453: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr
4454: WHERE grsc.geo_territory_id = gterr.geo_territory_id
4455: AND gterr.terr_group_id = b.terr_group_id
4456: AND grsc.rsc_role_code = b.role_code )
4457: AND ROWNUM < 2;