APPS.IEM_EMAIL_PROC_PVT dependencies on DUAL

Line 2689: FROM dual;

2685: NULL;
2686: END;
2687: SELECT TO_CHAR(iem.IEM_MAILPREPROCWF_S1.nextval)
2688: INTO l_itemkey
2689: FROM dual;
2690:
2691:
2692: IEM_MAILPREPROCWF_PUB.IEM_STARTPROCESS(
2693: WorkflowProcess=>'MAILPREPROC',

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

3710: g_topclass:=null;
3711: g_topscore:=null;
3712: l_wtot:=0;
3713: FOR x in (select * from the(select cast(l_data as iem_class_tbl_typ)
3714: from dual)a where score>0 and rownum<8 order by score desc)
3715: LOOP
3716: l_wtot:=l_wtot+x.score;
3717: END LOOP;
3718: FOR x in (select * from the(select cast(l_data as iem_class_tbl_typ)

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

3715: LOOP
3716: l_wtot:=l_wtot+x.score;
3717: END LOOP;
3718: FOR x in (select * from the(select cast(l_data as iem_class_tbl_typ)
3719: from dual)a where score>0 and rownum<8 order by score desc)
3720: LOOP
3721: x.score:=x.score*100/l_wtot;
3722: IF x.score > 0 THEN -- -ve Classification score not allowed Start
3723: IF x.score>100 THEN