[Home] [Help]
50: IF (VAR_TYPE_ID IS NOT NULL) THEN
51: DECLARE
52: CURSOR C IS
53: SELECT LOCATION_CODE
54: FROM HR_LOCATIONS_ALL_TL
55: WHERE LOCATION_ID = VAR_TYPE_ID
56: AND LANGUAGE = USERENV('LANG');
57: BEGIN
58: OPEN C;