1597: -- get the relevant resource id
1598: BEGIN
1599: SELECT resource_id
1600: INTO l_resource_id
1601: FROM BOM_RESOURCES
1602: WHERE cost_element_id = 1
1603: AND organization_id = l_master_organization_id
1604: AND rownum < 2;
1605: