APPS.JTF_TTY_ALIGN_ACTIVATE_PKG dependencies on JTF_TTY_NAMED_ACCT_RSC

Line 58: jtf_tty_named_acct_rsc narsc,

54: AND aa.terr_group_account_id NOT IN
55: ( SELECT ga.terr_group_account_id
56: FROM jtf_tty_terr_grp_accts ga,
57: jtf_tty_terr_groups ttygrp,
58: jtf_tty_named_acct_rsc narsc,
59: jtf_tty_srch_my_resources_v repdn
60: WHERE ttygrp.terr_group_id = ga.terr_group_id
61: AND ttygrp.active_from_date <= sysdate
62: AND ( ttygrp.active_to_date is null

Line 166: --dbms_output.put_line('delete from JTF_TTY_NAMED_ACCT_RSC');

162: CLOSE c_all_accounts;
163:
164: IF account_rsc_table.COUNT > 0
165: THEN
166: --dbms_output.put_line('delete from JTF_TTY_NAMED_ACCT_RSC');
167: FORALL i IN account_rsc_table.FIRST .. account_rsc_table.LAST
168: -- delete old resource assignments owned by the RM for this named account.
169: delete from JTF_TTY_NAMED_ACCT_RSC NARS
170: WHERE NARS.TERR_GROUP_ACCOUNT_ID = account_rsc_table(i)

Line 169: delete from JTF_TTY_NAMED_ACCT_RSC NARS

165: THEN
166: --dbms_output.put_line('delete from JTF_TTY_NAMED_ACCT_RSC');
167: FORALL i IN account_rsc_table.FIRST .. account_rsc_table.LAST
168: -- delete old resource assignments owned by the RM for this named account.
169: delete from JTF_TTY_NAMED_ACCT_RSC NARS
170: WHERE NARS.TERR_GROUP_ACCOUNT_ID = account_rsc_table(i)
171: AND (NARS.resource_id, NARS.rsc_group_id, NARS.rsc_role_code) IN (
172: /* Salesperson directly/indirectly reports to user */
173: SELECT dir.resource_id

Line 207: --dbms_output.put_line('insert into jtf_tty_named_acct_rsc');

203: AND mrsc.resource_id = sgh.resource_id
204: AND mrsc.user_id = p_user_id )
205: ) ;
206:
207: --dbms_output.put_line('insert into jtf_tty_named_acct_rsc');
208: FORALL j IN account_rsc_table.FIRST .. account_rsc_table.LAST
209: insert into jtf_tty_named_acct_rsc
210: (ACCOUNT_RESOURCE_ID,
211: OBJECT_VERSION_NUMBER ,

Line 209: insert into jtf_tty_named_acct_rsc

205: ) ;
206:
207: --dbms_output.put_line('insert into jtf_tty_named_acct_rsc');
208: FORALL j IN account_rsc_table.FIRST .. account_rsc_table.LAST
209: insert into jtf_tty_named_acct_rsc
210: (ACCOUNT_RESOURCE_ID,
211: OBJECT_VERSION_NUMBER ,
212: TERR_GROUP_ACCOUNT_ID,
213: RESOURCE_ID ,

Line 225: jtf_tty_named_acct_rsc_s.nextval

221: LAST_UPDATE_DATE ,
222: LAST_UPDATE_LOGIN
223: )
224: select
225: jtf_tty_named_acct_rsc_s.nextval
226: , 2
227: , ALAC.terr_group_account_id
228: , ALPT.RESOURCE_ID
229: , ALPT.RSC_GROUP_ID