[Home] [Help]
1681: THEN
1682: BEGIN
1683: SELECT '1'
1684: INTO l_dummy
1685: FROM bom_alternate_designators
1686: WHERE
1687: alternate_designator_code = p_rtg_header_rec.alternate_routing_code
1688: AND organization_id = p_rtg_header_unexp_rec.organization_id
1689: AND disable_date is not null