APPS.JTF_TTY_ALIGN_WEBADI_INT_PKG dependencies on DUAL

Line 300: select jtf_tty_interface_s.nextval into SEQ from dual;

296: delete from JTF_TTY_WEBADI_INTERFACE
297: where user_id = to_number(p_userid);
298: -- and sysdate - creation_date >2;
299:
300: select jtf_tty_interface_s.nextval into SEQ from dual;
301:
302: begin
303: select resource_id into salesMgr from jtf_rs_resource_extns
304: where user_id = to_number(p_userid);

Line 1257: from dual;

1253: --
1254: --create a new alignment account record
1255: select JTF_TTY_ALIGN_ACCTS_S.nextval
1256: into l_align_acct_id
1257: from dual;
1258:
1259: --insert into tmp values('2. Create Align Account', l_align_acct_id); commit;
1260: insert into JTF_TTY_ALIGN_ACCTS
1261: ( align_acct_id

Line 1302: from dual;

1298: --insert into tmp2 values('1.77775. b4 c_align_pterr. p_added_rscs_tbl(i).resource_id =', p_added_rscs_tbl(i).resource_id || ' ' || p_added_rscs_tbl(i).group_id || p_added_rscs_tbl(i).role_code); commit;
1299: -- create a proposed territory for this resource
1300: select JTF_TTY_ALIGN_PTERR_S.nextval
1301: into l_align_pterr_id
1302: from dual;
1303:
1304: insert into JTF_TTY_ALIGN_PTERR
1305: ( align_proposed_terr_id
1306: ,object_version_number