APPS.IEM_EMAILPROC_HDL_PVT dependencies on DUAL

Line 88: FROM dual;

84:
85: --actual API begins here
86: SELECT IEM_ACCOUNT_EMAILPROCS_s1.nextval
87: INTO l_seq_id
88: FROM dual;
89:
90: INSERT INTO IEM_ACCOUNT_EMAILPROCS
91: (
92: EMAILPROC_ID,

Line 803: FROM dual;

799: */
800: --get next sequential number for route_id
801: SELECT IEM_EMAILPROCS_s1.nextval
802: INTO l_seq_id
803: FROM dual;
804:
805: INSERT INTO IEM_EMAILPROCS
806: (
807: EMAILPROC_ID,

Line 999: FROM dual;

995:
996:
997: SELECT IEM_EMAILPROC_RULES_s1.nextval
998: INTO l_seq_id
999: FROM dual;
1000:
1001: INSERT INTO IEM_EMAILPROC_RULES
1002: (
1003: EMAILPROC_RULE_ID,

Line 1150: FROM dual;

1146:
1147: --actual API begins here
1148: SELECT IEM_ACTIONS_s1.nextval
1149: INTO l_seq_id
1150: FROM dual;
1151:
1152: INSERT INTO IEM_ACTIONS
1153: (
1154: ACTION_ID,

Line 1306: FROM dual;

1302:
1303: --actual API begins here
1304: SELECT IEM_ACTION_DTLS_s1.nextval
1305: INTO l_seq_id
1306: FROM dual;
1307:
1308: INSERT INTO IEM_ACTION_DTLS
1309: (
1310: ACTION_DTL_ID,