APPS.IEM_EMAIL_PROC_PVT dependencies on DUAL

Line 3784: FROM dual;

3780: NULL;
3781: END;
3782: SELECT TO_CHAR(iem.IEM_MAILPREPROCWF_S1.nextval)
3783: INTO l_itemkey
3784: FROM dual;
3785:
3786:
3787: IEM_MAILPREPROCWF_PUB.IEM_STARTPROCESS(
3788: WorkflowProcess=>'MAILPREPROC',

Line 4809: from dual)a where score>0 and rownum<8 order by score desc)

4805: g_topclass:=null;
4806: g_topscore:=null;
4807: l_wtot:=0;
4808: FOR x in (select * from the(select cast(l_data as iem_class_tbl_typ)
4809: from dual)a where score>0 and rownum<8 order by score desc)
4810: LOOP
4811: l_wtot:=l_wtot+x.score;
4812: END LOOP;
4813: FOR x in (select * from the(select cast(l_data as iem_class_tbl_typ)

Line 4814: from dual)a where score>0 and rownum<8 order by score desc)

4810: LOOP
4811: l_wtot:=l_wtot+x.score;
4812: END LOOP;
4813: FOR x in (select * from the(select cast(l_data as iem_class_tbl_typ)
4814: from dual)a where score>0 and rownum<8 order by score desc)
4815: LOOP
4816: x.score:=x.score*100/l_wtot;
4817: IF x.score > 0 THEN -- -ve Classification score not allowed Start
4818: IF x.score>100 THEN