APPS.IEM_THEMES_PVT dependencies on IEM_THEMES_S1

Line 58: SELECT iem_themes_s1.nextval

54: SELECT COUNT(*) INTO l_cnt from IEM_THEMES WHERE classification_id=p_classification_id
55: and theme=p_theme and query_response=p_query_response;
56:
57: IF l_cnt=0 THEN
58: SELECT iem_themes_s1.nextval
59: INTO l_seq_id
60: FROM dual;
61: INSERT INTO iem_themes (theme_id,
62: classification_id,

Line 972: SELECT iem_themes_s1.nextval

968: select email_account_id into l_email_account_id
969: from iem_classifications
970: where classification_id=p_classification_id;
971: IF l_cnt=1 THEN
972: SELECT iem_themes_s1.nextval
973: INTO l_seq_id
974: FROM dual;
975: INSERT INTO iem_themes (theme_id,
976: classification_id,