APPS.IEM_SUGG_DOC_RANK_PVT dependencies on IEM_SUGG_DOC_DTLS_S1

Line 56: select IEM_SUGG_DOC_DTLS_S1.nextval into l_sugg_id

52: where rownum=1;
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 ,

Line 86: select IEM_SUGG_DOC_DTLS_S1.nextval into l_sugg_id

82: END LOOP;
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 ,