APPS.ENG_DEFAULT_REVISED_ITEM dependencies on MTL_PARAMETERS

Line 1187: FROM MTL_PARAMETERS mp

1183: -- Added by MK on 11/27/00
1184: IF NO_ECO_ROUTING_REV%NOTFOUND THEN
1185: SELECT mp.starting_revision
1186: INTO l_current_revision
1187: FROM MTL_PARAMETERS mp
1188: WHERE mp.organization_id = p_organization_id
1189: AND NOT EXISTS( SELECT NULL
1190: FROM MTL_RTG_ITEM_REVISIONS
1191: WHERE implementation_date IS NOT NULL

Line 1443: FROM mtl_parameters

1439:
1440: CURSOR c_Get_Org_Details
1441: IS
1442: SELECT process_enabled_flag
1443: FROM mtl_parameters
1444: WHERE organization_id = p_rev_item_unexp_rec.organization_id;
1445:
1446: l_Item_Details_Rec c_Get_Item_Details%ROWTYPE;
1447: l_Org_Details_Rec c_Get_Org_Details%ROWTYPE;