APPS.MSC_ALLOCATION_PLAN dependencies on DUAL

Line 750: select msc_supplies_s.nextval into l_transaction_id from dual;

746: p_dock_date,
747: p_due_date);
748:
749: --dbms_output.put_line('dock date='||p_dock_date);
750: select msc_supplies_s.nextval into l_transaction_id from dual;
751: --dbms_output.put_line('id ='||l_transaction_id);
752: insert into msc_supplies(
753: transaction_id,
754: last_update_date,

Line 907: FROM dual;

903: BEGIN
904:
905: SELECT msc_form_query_s.nextval
906: INTO p_query_id
907: FROM dual;
908:
909: if p_sub_type in (1,9) then -- total, reqular org
910: insert into msc_form_query(
911: query_id,