APPS.MSC_ATP_PEG dependencies on DUAL

Line 3727: -- Individual Item's lead times are used.

3723: atp_peg_det.plan_id(k) := atp_peg_det.plan_id(i);
3724: atp_peg_det.sr_instance_id(k) := atp_peg_det.sr_instance_id(i);
3725: atp_peg_det.organization_id(k) := atp_peg_det.organization_id(i);
3726: atp_peg_det.bom_item_type(k) := fcst_data_tab.bom_item_type(j);
3727: -- Individual Item's lead times are used.
3728: atp_peg_det.fixed_lt(k) := fcst_data_tab.fixed_lt(j);
3729: atp_peg_det.variable_lt(k) := fcst_data_tab.variable_lt(j);
3730: atp_peg_det.sales_order_qty(k) := fcst_data_tab.sales_order_qty(j);
3731: -- Note that the sales_order_qty gets factored in during forecast consumption

Line 4631: FROM dual;

4627: ELSE
4628: BEGIN
4629: SELECT mrp_atp_schedule_temp_s.currval
4630: INTO l_session_id
4631: FROM dual;
4632: EXCEPTION
4633: WHEN OTHERS THEN
4634: SELECT mrp_atp_schedule_temp_s.nextval
4635: INTO l_session_id

Line 4636: FROM dual;

4632: EXCEPTION
4633: WHEN OTHERS THEN
4634: SELECT mrp_atp_schedule_temp_s.nextval
4635: INTO l_session_id
4636: FROM dual;
4637: order_sch_wb.debug_session_id := l_session_id;
4638: END;
4639:
4640: msc_util.msc_log('Setting ATP Session ID : ' || l_session_id);