APPS.IEM_SUGG_DOC_RANK_PVT dependencies on DUAL

Line 57: from dual;

53: l_rank:=0;
54: FOR v1 in c_top5 LOOP
55: l_rank:=l_rank+1;
56: select IEM_SUGG_DOC_DTLS_S1.nextval into l_sugg_id
57: from dual;
58: INSERT INTO IEM_SUGG_DOC_DTLS
59: (DOC_SUGG_ID ,
60: OUTBOUND_MSG_STATS_ID ,
61: KB_DOC_ID ,

Line 87: from dual;

83: --Next Create the Rest records with rank 5+
84: l_rank:=6;
85: FOR v2 in c_rest_doc LOOP
86: select IEM_SUGG_DOC_DTLS_S1.nextval into l_sugg_id
87: from dual;
88: INSERT INTO IEM_SUGG_DOC_DTLS
89: (DOC_SUGG_ID ,
90: OUTBOUND_MSG_STATS_ID ,
91: KB_DOC_ID ,