APPS.JTF_TTY_GEO_TERRGP dependencies on JTF_TTY_TERR_GRP_ROLES

Line 111: from jtf_tty_terr_grp_roles

107: coninue with the create statements */
108:
109: delete from jtf_tty_role_access
110: where TERR_GROUP_ROLE_ID in (select TERR_GROUP_ROLE_ID
111: from jtf_tty_terr_grp_roles
112: where terr_group_id = l_terr_grp_id);
113:
114: delete from jtf_tty_terr_grp_roles where terr_group_id = l_terr_grp_id;
115:

Line 114: delete from jtf_tty_terr_grp_roles where terr_group_id = l_terr_grp_id;

110: where TERR_GROUP_ROLE_ID in (select TERR_GROUP_ROLE_ID
111: from jtf_tty_terr_grp_roles
112: where terr_group_id = l_terr_grp_id);
113:
114: delete from jtf_tty_terr_grp_roles where terr_group_id = l_terr_grp_id;
115:
116: delete from jtf_tty_geo_grp_values where terr_group_id = l_terr_grp_id;
117:
118: delete from jtf_tty_terr_groups where terr_group_id = l_terr_grp_id;

Line 424: select jtf_tty_terr_grp_roles_s.nextval

420: for get_terr_grp_roles in csr_get_terr_grp_roles (p_terr_id)
421: --
422: loop
423: --
424: select jtf_tty_terr_grp_roles_s.nextval
425: into lp_terr_grp_role_id
426: from dual;
427: --
428: BEGIN

Line 430: insert into jtf_tty_terr_grp_roles (

426: from dual;
427: --
428: BEGIN
429:
430: insert into jtf_tty_terr_grp_roles (
431: TERR_GROUP_ROLE_ID
432: ,TERR_GROUP_ID
433: ,ROLE_CODE
434: ,OBJECT_VERSION_NUMBER

Line 603: (select terr_group_role_id from jtf_tty_terr_grp_roles

599: where terr_group_id = p_terr_gp_id;
600:
601: delete from jtf_tty_role_prod_int
602: where terr_group_role_id in
603: (select terr_group_role_id from jtf_tty_terr_grp_roles
604: where terr_group_id = p_terr_gp_id);
605:
606:
607: delete from jtf_tty_role_access

Line 609: (select terr_group_role_id from jtf_tty_terr_grp_roles

605:
606:
607: delete from jtf_tty_role_access
608: where terr_group_role_id in
609: (select terr_group_role_id from jtf_tty_terr_grp_roles
610: where terr_group_id = p_terr_gp_id);
611:
612: delete from jtf_tty_terr_grp_roles
613: where terr_group_id = p_terr_gp_id;

Line 612: delete from jtf_tty_terr_grp_roles

608: where terr_group_role_id in
609: (select terr_group_role_id from jtf_tty_terr_grp_roles
610: where terr_group_id = p_terr_gp_id);
611:
612: delete from jtf_tty_terr_grp_roles
613: where terr_group_id = p_terr_gp_id;
614:
615: /* finally delete the terr gp itself */
616: