[Home] [Help]
APPS.GHR_PA_REQUESTS_PKG2 dependencies on HR_LOCATIONS
Line 531: l_location_id hr_locations.location_id%TYPE;
527:
528: l_proc varchar2(30) := 'duty_station_warn';
529:
530: l_noa_family_code ghr_families.noa_family_code%TYPE;
531: l_location_id hr_locations.location_id%TYPE;
532: l_duty_station_id VARCHAR2(150);
533: l_duty_station_code ghr_duty_stations_f.duty_station_code%TYPE;
534: l_duty_station_desc VARCHAR2(200);
535: l_exists BOOLEAN := FALSE;