APPS.OKC_MANAGE_DELIVERABLES_GRP dependencies on DUAL

Line 317: INTO delInstanceRecTab(j).deliverable_id from dual;

313: delInstanceRecTab(j) := delRecord;
314:
315: --- set the deliverable id
316: select okc_deliverable_id_s.nextval
317: INTO delInstanceRecTab(j).deliverable_id from dual;
318:
319: --- set the actual due date to the new instance
320: delInstanceRecTab(j).actual_due_date :=
321: l_recurring_dates(m);

Line 3970: select OKC_WF_NOTIFY_S1.nextval into l_key from dual;

3966: delStsTab(k).last_update_login := fnd_global.login_Id;
3967:
3968: --if necessary, send notification
3969: if ('Y' = del_rec.notify_completed_yn) then
3970: select OKC_WF_NOTIFY_S1.nextval into l_key from dual;
3971:
3972: if ('COMPLETED' = del_rec.deliverable_status) then
3973: l_msg_code := 'OKC_DEL_COMPLETE_NTF_SUBJECT';
3974: elsif ('CANCELLED' = del_rec.deliverable_status) then

Line 4596: INTO l_effective_beforedue_date from dual;

4592: ELSIF UPPER(del_cur.PAY_HOLD_PRIOR_DUE_DATE_UOM) = 'WK' THEN
4593: l_effective_beforedue_date :=trunc(del_cur.actual_due_date)-7*del_cur.PAY_HOLD_PRIOR_DUE_DATE_VALUE;
4594: ELSIF UPPER(del_cur.PAY_HOLD_PRIOR_DUE_DATE_UOM) = 'MTH' THEN
4595: select add_months(del_cur.actual_due_date,-del_cur.PAY_HOLD_PRIOR_DUE_DATE_VALUE)
4596: INTO l_effective_beforedue_date from dual;
4597: END IF;
4598:
4599: IF trunc(l_effective_beforedue_date) = trunc(sysdate) OR
4600: trunc(l_effective_beforedue_date) < trunc(sysdate) THEN