DBA Data[Home] [Help]

APPS.MSC_ALLOCATION_PLAN dependencies on DUAL

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

761: p_dock_date,
762: p_due_date, p_source_inst);
763:
764: --dbms_output.put_line('dock date='||p_dock_date);
765: select msc_supplies_s.nextval into l_transaction_id from dual;
766: --dbms_output.put_line('id ='||l_transaction_id);
767: insert into msc_supplies(
768: transaction_id,
769: last_update_date,

Line 922: FROM dual;

918: BEGIN
919:
920: SELECT msc_form_query_s.nextval
921: INTO p_query_id
922: FROM dual;
923:
924: if p_sub_type in (1,9) then -- total, reqular org
925: insert into msc_form_query(
926: query_id,