630: SELECT
631: NAME
632: INTO L_TRADER_NAME
633: FROM
634: HR_ORGANIZATION_UNITS
635: WHERE ORGANIZATION_ID = C_FROM_ORGANIZATION_ID
636: AND ROWNUM < 2;
637: EXCEPTION
638: WHEN NO_DATA_FOUND THEN
647: SELECT
648: NAME
649: INTO L_TRADER_NAME
650: FROM
651: HR_ORGANIZATION_UNITS
652: WHERE ORGANIZATION_ID = C_TO_ORGANIZATION_ID
653: AND ROWNUM < 2;
654: EXCEPTION
655: WHEN NO_DATA_FOUND THEN