APPS.CSP_EXCESS_PARTS_PVT dependencies on MTL_PARAMETERS

Line 170: mtl_parameters p

166: c.planner_code planner,
167: build_in_wip_flag build_in_wip,
168: pick_components_flag pick_components
169: FROM mtl_system_items_kfv c,
170: mtl_parameters p
171: WHERE c.concatenated_segments = p_item_Segments
172: AND c.organization_id = p.organization_id
173: AND p.organization_id = p_organization_id;
174:

Line 350: from mtl_parameters p

346:
347: /* get calendar */
348: select p.calendar_code, p.calendar_exception_set_id
349: into l_cal_code, l_exception_set_id
350: from mtl_parameters p
351: where p.organization_id = p_organization_id;
352:
353: /* Validate cat set and MCAT struct */
354: IF (p_cat_set_id is not null and p_catg_struct_id is not null) then