APPS.JTF_TTY_MAINTAIN_NA_PVT dependencies on JTF_TTY_NAMED_ACCT_RSC_S

Line 967: (SELECT jtf_tty_named_acct_rsc_s.nextval,

963: CREATED_BY,
964: CREATION_DATE,
965: LAST_UPDATED_BY,
966: LAST_UPDATE_DATE)
967: (SELECT jtf_tty_named_acct_rsc_s.nextval,
968: 1,
969: p_terr_grp_acct_id,
970: l_resource_id,
971: l_rsc_group_id,

Line 1607: VALUES(jtf_tty_named_acct_rsc_s.nextval,

1603: CREATION_DATE ,
1604: LAST_UPDATED_BY ,
1605: LAST_UPDATE_DATE ,
1606: LAST_UPDATE_LOGIN )
1607: VALUES(jtf_tty_named_acct_rsc_s.nextval,
1608: 1,
1609: p_terr_gp_acct_id,
1610: p_owner_user_rsc_id,
1611: p_owner_group_id,

Line 1920: select jtf_tty_named_acct_rsc_s.nextval into new_seq_acct_rsc_id

1916:
1917: -- dbms_output.put_line('l_directs_on_account = ' || l_directs_on_account);
1918:
1919: IF l_directs_on_account = 0 THEN
1920: select jtf_tty_named_acct_rsc_s.nextval into new_seq_acct_rsc_id
1921: from dual;
1922:
1923: lp_mgr_group_id := p_removed_rscs_tbl(i).mgr_group_id;
1924: lp_mgr_role_code := p_removed_rscs_tbl(i).mgr_role_code;

Line 2076: select jtf_tty_named_acct_rsc_s.nextval into new_seq_acct_rsc_id

2072: -- test if record already exists for this rsc/grp/role with assign Y
2073:
2074:
2075: -- insert into jtf_tty_named_acct_rsc
2076: select jtf_tty_named_acct_rsc_s.nextval into new_seq_acct_rsc_id
2077: from dual;
2078:
2079: -- dbms_output.put_line('inserting to jtf_tty_named_acct_rsc ');
2080: -- dbms_output.put_line(' ' || ' //new_seq_acct_rsc_id=' || new_seq_acct_rsc_id ||