APPS.MSD_SCE_RECEIVE_FORECAST_PKG dependencies on DUAL

Line 56: from dual;

52: if p_horizon_start is null then
53:
54: select decode(p_order_type, 4, sysdate-365, sysdate)
55: into l_horizon_start
56: from dual;
57:
58: else
59:
60: l_horizon_start := fnd_date.canonical_to_date(p_horizon_start);

Line 70: SELECT msd.msd_last_refresh_number_s.nextval into l_new_refresh_Num from dual;

66: -- dbms_output.put_line('l_horizon_start := ' || l_horizon_start);
67: -- dbms_output.put_line('l_horizon_end := ' || l_horizon_end);
68:
69: /* Receive the net chanage sequence number */
70: SELECT msd.msd_last_refresh_number_s.nextval into l_new_refresh_Num from dual;
71:
72: if p_org_code is not null then
73:
74: select sr_tp_id, sr_instance_id