APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB dependencies on MSC_SYSTEM_ITEMS

Line 395: planner_code in msc_system_items */

391: end if; -- if p_impl_as in (2,5) or p_order_type = 2 then
392:
393: if p_impl_as in (2,5) then
394: /* update employee_id to be the employee_id for the corresponding
395: planner_code in msc_system_items */
396: OPEN empl_C;
397: FETCH empl_C INTO p_empl_id;
398: CLOSE empl_C;
399:

Line 413: FROM msc_system_items msi

409:
410: PROCEDURE update_success_supplies IS
411: CURSOR sr_item IS
412: SELECT msi.sr_inventory_item_id
413: FROM msc_system_items msi
414: WHERE msi.plan_id=p_plan_id
415: AND msi.organization_id = p_org_id
416: AND msi.sr_instance_id = p_inst_id
417: and msi.inventory_item_id = p_item_id;

Line 801: from msc_system_items

797: p_dest_org_id;
798: begin
799: select effectivity_control
800: into p_effectivity_control
801: from msc_system_items
802: where plan_id = p_plan_id
803: and sr_instance_id = p_inst_id
804: and organization_id = p_org_id
805: and inventory_item_id = p_item_id;