APPS.OKC_MANAGE_DELIVERABLES_GRP dependencies on DUAL

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

333: delInstanceRecTab(j) := delRecord;
334:
335: --- set the deliverable id
336: select okc_deliverable_id_s.nextval
337: INTO delInstanceRecTab(j).deliverable_id from dual;
338:
339: --- set the actual due date to the new instance
340: delInstanceRecTab(j).actual_due_date :=
341: l_recurring_dates(m);

Line 1641: SELECT Add_Months(delRecTab(i).FIXED_START_DATE,Trunc( Months_Between(delRecTab(i).end_event_date,delRecTab(i).FIXED_START_DATE)/12)*12 ) INTO start_date_for_del FROM dual;

1637:
1638: ---Calculate the correct DATE here
1639:
1640:
1641: SELECT Add_Months(delRecTab(i).FIXED_START_DATE,Trunc( Months_Between(delRecTab(i).end_event_date,delRecTab(i).FIXED_START_DATE)/12)*12 ) INTO start_date_for_del FROM dual;
1642:
1643:
1644:
1645: generate_del_instances(

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

4090: delStsTab(k).last_update_login := fnd_global.login_Id;
4091:
4092: --if necessary, send notification
4093: if ('Y' = del_rec.notify_completed_yn) then
4094: select OKC_WF_NOTIFY_S1.nextval into l_key from dual;
4095:
4096:
4097: --Acq Plan Message Cleanup
4098: /*

Line 4741: INTO l_effective_beforedue_date from dual;

4737: ELSIF UPPER(del_cur.PAY_HOLD_PRIOR_DUE_DATE_UOM) = 'WK' THEN
4738: l_effective_beforedue_date :=trunc(del_cur.actual_due_date)-7*del_cur.PAY_HOLD_PRIOR_DUE_DATE_VALUE;
4739: ELSIF UPPER(del_cur.PAY_HOLD_PRIOR_DUE_DATE_UOM) = 'MTH' THEN
4740: select add_months(del_cur.actual_due_date,-del_cur.PAY_HOLD_PRIOR_DUE_DATE_VALUE)
4741: INTO l_effective_beforedue_date from dual;
4742: END IF;
4743:
4744: IF trunc(l_effective_beforedue_date) = trunc(sysdate) OR
4745: trunc(l_effective_beforedue_date) < trunc(sysdate) THEN