APPS.MTL_CROSS_REFERENCES_PVT dependencies on MTL_PARAMETERS

Line 1435: FROM mtl_parameters p, mtl_system_items_b i

1431: --
1432: IF l_GTIN_XRef_Rec.ORG_INDEPENDENT_FLAG = 'Y' THEN
1433: BEGIN
1434: SELECT i.organization_id INTO l_master_org
1435: FROM mtl_parameters p, mtl_system_items_b i
1436: WHERE p.organization_id = p.master_organization_id
1437: AND i.organization_id = p.organization_id
1438: AND i.inventory_item_id = l_GTIN_XRef_Rec.INVENTORY_ITEM_ID;
1439: EXCEPTION

Line 1765: FROM mtl_parameters mtp

1761: IF l_mtl_xref_rec.ORGANIZATION_CODE IS NOT NULL THEN
1762: BEGIN
1763:
1764: SELECT mtp.organization_id into p_organization_id
1765: FROM mtl_parameters mtp
1766: WHERE mtp.organization_code = l_mtl_xref_rec.ORGANIZATION_CODE;
1767:
1768:
1769: IF l_mtl_xref_rec.ORGANIZATION_ID IS NOT NULL THEN