DBA Data[Home] [Help]

APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB dependencies on MSC_SYSTEM_ITEMS

Line 322: planner_code in msc_system_items */

318: end if; -- if p_impl_as in (2,5) or p_order_type = 2 then
319:
320: if p_impl_as in (2,5) then
321: /* update employee_id to be the employee_id for the corresponding
322: planner_code in msc_system_items */
323: OPEN empl_C;
324: FETCH empl_C INTO p_empl_id;
325: CLOSE empl_C;
326:

Line 340: FROM msc_system_items msi

336:
337: PROCEDURE update_success_supplies IS
338: CURSOR sr_item IS
339: SELECT msi.sr_inventory_item_id
340: FROM msc_system_items msi
341: WHERE msi.plan_id=p_plan_id
342: AND msi.organization_id = p_org_id
343: AND msi.sr_instance_id = p_inst_id
344: and msi.inventory_item_id = p_item_id;