DBA Data[Home] [Help]

APPS.GHR_MASS_AWARDS_PKG dependencies on GHR_DUTY_STATIONS_V

Line 1659: l_duty_station_id ghr_duty_stations_v.duty_station_id%TYPE;

1655: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
1656: l_prh_object_version_number ghr_pa_routing_history.object_version_number%type;
1657:
1658: l_duty_station_location_id hr_locations.location_id%TYPE;
1659: l_duty_station_id ghr_duty_stations_v.duty_station_id%TYPE;
1660: l_duty_station_code ghr_duty_stations_v.duty_station_code%TYPE;
1661: l_duty_station_desc ghr_duty_stations_v.duty_station_desc%TYPE;
1662: l_appropriation_code1 varchar2(30);
1663: l_appropriation_code2 varchar2(30);

Line 1660: l_duty_station_code ghr_duty_stations_v.duty_station_code%TYPE;

1656: l_prh_object_version_number ghr_pa_routing_history.object_version_number%type;
1657:
1658: l_duty_station_location_id hr_locations.location_id%TYPE;
1659: l_duty_station_id ghr_duty_stations_v.duty_station_id%TYPE;
1660: l_duty_station_code ghr_duty_stations_v.duty_station_code%TYPE;
1661: l_duty_station_desc ghr_duty_stations_v.duty_station_desc%TYPE;
1662: l_appropriation_code1 varchar2(30);
1663: l_appropriation_code2 varchar2(30);
1664:

Line 1661: l_duty_station_desc ghr_duty_stations_v.duty_station_desc%TYPE;

1657:
1658: l_duty_station_location_id hr_locations.location_id%TYPE;
1659: l_duty_station_id ghr_duty_stations_v.duty_station_id%TYPE;
1660: l_duty_station_code ghr_duty_stations_v.duty_station_code%TYPE;
1661: l_duty_station_desc ghr_duty_stations_v.duty_station_desc%TYPE;
1662: l_appropriation_code1 varchar2(30);
1663: l_appropriation_code2 varchar2(30);
1664:
1665: l_bt_award_amount ghr_pa_requests.award_amount%type;