APPS.IEM_MIGRATION_PVT dependencies on IEM_INTENT_DTLS

Line 1733: -- Insert into IEM_INTENT_DTLS

1729: l_last_updated_by,
1730: sysdate,
1731: l_last_update_login);
1732:
1733: -- Insert into IEM_INTENT_DTLS
1734: for v3 in c1 LOOP
1735: select iem_intent_dtls_s1.nextval into l_intent_dtl_id from dual;
1736: l_mod:=mod(v3.score*100,10);
1737: if (l_mod=0 or l_mod>=5) then

Line 1735: select iem_intent_dtls_s1.nextval into l_intent_dtl_id from dual;

1731: l_last_update_login);
1732:
1733: -- Insert into IEM_INTENT_DTLS
1734: for v3 in c1 LOOP
1735: select iem_intent_dtls_s1.nextval into l_intent_dtl_id from dual;
1736: l_mod:=mod(v3.score*100,10);
1737: if (l_mod=0 or l_mod>=5) then
1738: l_weight:=ceil(v3.score*10);
1739: else

Line 1742: insert into iem_intent_dtls

1738: l_weight:=ceil(v3.score*10);
1739: else
1740: l_weight:=floor(v3.score*10);
1741: end if;
1742: insert into iem_intent_dtls
1743: (INTENT_DTL_ID,
1744: INTENT_ID,
1745: KEYWORD,
1746: WEIGHT,