43: SELECT
44: NAME
45: INTO V_NAME
46: FROM
47: HR_ORGANIZATION_UNITS
48: WHERE NVL(ORGANIZATION_ID
49: ,0) = NVL(ORG_ID
50: ,0);
51: RETURN (V_NAME);
437: CURSOR FOR_LOCATION IS
438: SELECT
439: LOCATION_ID
440: FROM
441: HR_ORGANIZATION_UNITS
442: WHERE ORGANIZATION_ID = NVL(ORG_ID
443: ,0);
444: CURSOR FOR_ADDRESS IS
445: SELECT