APPS.JTF_TTY_CREATE_TERR_FROM_GEO dependencies on JTF_TTY_ROLE_ACCESS

Line 52: , jtf_tty_role_access ra

48: FROM
49: JTF_TTY_GEO_TERR_RSC grsc
50: , jtf_tty_geo_terr gtr
51: , jtf_tty_terr_grp_roles tgr
52: , jtf_tty_role_access ra
53: WHERE grsc.GEO_TERRITORY_ID = l_geo_terr_id
54: AND gtr.geo_territory_id = grsc.geo_territory_id
55: AND grsc.rsc_role_code = tgr.role_code
56: AND tgr.terr_group_id = gtr.terr_group_id

Line 85: FROM jtf_tty_role_access a

81: /* Access Types for a particular Role within a Territory Group */
82: CURSOR c_role_access( lp_terr_group_id NUMBER
83: , lp_role VARCHAR2) IS
84: SELECT DISTINCT a.access_type
85: FROM jtf_tty_role_access a
86: , jtf_tty_terr_grp_roles b
87: WHERE a.terr_group_role_id = b.terr_group_role_id
88: AND b.terr_group_id = lp_terr_group_id
89: AND b.role_code = lp_role;