APPS.JTF_TTY_NACCT_SALES_PUB dependencies on JTF_TTY_NAMED_ACCT_RSC_S

Line 406: select jtf_tty_named_acct_rsc_s.nextval into new_seq_acct_rsc_id

402: -- test if record already exists for this rsc/grp/role with assign Y
403:
404:
405: -- insert into jtf_tty_named_acct_rsc
406: select jtf_tty_named_acct_rsc_s.nextval into new_seq_acct_rsc_id
407: from dual;
408:
409: --dbms_output.put_line('inserting to jtf_tty_named_acct_rsc ');
410: --dbms_output.put_line(' ' || ' //new_seq_acct_rsc_id=' || new_seq_acct_rsc_id ||

Line 612: select jtf_tty_named_acct_rsc_s.nextval into new_seq_acct_rsc_id

608:
609: --dbms_output.put_line('l_directs_on_account = ' || l_directs_on_account);
610:
611: IF l_directs_on_account = 0 THEN
612: select jtf_tty_named_acct_rsc_s.nextval into new_seq_acct_rsc_id
613: from dual;
614:
615: lp_mgr_group_id := G_REM_SALESREP_TBL(i).mgr_group_id;
616: lp_mgr_role_code := G_REM_SALESREP_TBL(i).mgr_role_code;