APPS.MSC_UPDATE_RESOURCE dependencies on MSC_SUPPLIES

Line 1657: update msc_supplies

1653: --dbms_output.put_line('new due date='||to_char(p_new_end,'MM/DD/RRRR HH24:MI'));
1654:
1655: a := nvl(p_trans_id.last,0);
1656: if a > 0 then
1657: update msc_supplies
1658: set status = 0,
1659: applied =2,
1660: firm_planned_type = 1,
1661: firm_date = p_end_time(a),

Line 1803: msc_supplies ms

1799: p_disable_date out nocopy date) IS
1800: CURSOR eff_c IS
1801: select mpe.effectivity_date, mpe.disable_date
1802: from msc_process_effectivity mpe,
1803: msc_supplies ms
1804: where ms.plan_id = p_plan_id
1805: and ms.transaction_id = p_supply_id
1806: and mpe.plan_id = ms.plan_id
1807: and mpe.process_sequence_id = ms.process_seq_id;