APPS.JTF_TTY_GEO_TERRGP dependencies on JTF_TTY_ROLE_ACCESS

Line 109: delete from jtf_tty_role_access

105:
106: /* following code deletes the data first in case of an update and
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:

Line 461: insert into jtf_tty_role_access (

457: END;
458: --
459: BEGIN
460: --
461: insert into jtf_tty_role_access (
462: TERR_GROUP_ROLE_ACCESS_ID
463: ,TERR_GROUP_ROLE_ID
464: ,ACCESS_TYPE
465: ,OBJECT_VERSION_NUMBER

Line 472: jtf_tty_role_access_s.nextval

468: ,LAST_UPDATED_BY
469: ,LAST_UPDATE_DATE
470: ,TRANS_ACCESS_CODE)
471: select
472: jtf_tty_role_access_s.nextval
473: ,lp_terr_grp_role_id
474: ,ACCESS_TYPE
475: , 1
476: ,CREATED_BY

Line 609: delete from jtf_tty_role_access

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