APPS.JTF_TTY_NACCT_SALES_PUB dependencies on DUAL

Line 407: from dual;

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 ||
411: --' //l_terr_group_account_id=' || l_terr_group_account_id ||' //lp_resource_id=' ||

Line 415: -- assigned flag Y because user is assigning this individual, may be himself.

411: --' //l_terr_group_account_id=' || l_terr_group_account_id ||' //lp_resource_id=' ||
412: -- lp_resource_id ||' //lp_group_id=' || lp_group_id
413: --|| l_assign_flag ||' //lp_resource_type=' || lp_resource_type );
414:
415: -- assigned flag Y because user is assigning this individual, may be himself.
416: insert into jtf_tty_named_acct_rsc (
417: account_resource_id,
418: object_version_number,
419: terr_group_account_id,

Line 458: from sys.dual;

454: to do an incremental and Total Mode */
455:
456: select jtf_tty_named_acct_changes_s.nextval
457: into l_change_id
458: from sys.dual;
459:
460: insert into jtf_tty_named_acct_changes
461: ( NAMED_ACCT_CHANGE_ID
462: , OBJECT_VERSION_NUMBER

Line 525: from sys.dual;

521: to do an incremental and Total Mode */
522:
523: select jtf_tty_named_acct_changes_s.nextval
524: into l_change_id
525: from sys.dual;
526:
527: insert into jtf_tty_named_acct_changes
528: ( NAMED_ACCT_CHANGE_ID
529: , OBJECT_VERSION_NUMBER

Line 613: from dual;

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;
617: