[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select ppf.first_name FIRST_NAME,
ppf.last_name LAST_NAME,
ppf.middle_names MIDDLE_NAMES,
ppf.full_name FULL_NAME,
ppf.date_of_birth DATE_OF_BIRTH,
ppf.national_identifier NATIONAL_IDENTIFIER,
--Bug# 9329643
ppf.employee_number EMPLOYEE_NUMBER
from per_people_f ppf
where ppf.person_id = l_person_id
and l_effective_date between ppf.effective_start_date
and nvl(ppf.effective_end_date,l_effective_date+1);
SELECT RETIREMENT_PLAN,
RETENTION_ALLOWANCE,
TENURE,
ANNUITANT_INDICATOR,
FEGLI,
TO_POSITION_ID,
FROM_POSITION_TITLE,
FROM_POSITION_SEQ_NUM,
pay_rate_determinant,
from_step_or_rate,
APPOINTMENT_TYPE,
date_arrived_personnel_office,
wgi_date_due,
frozen_service,
-- Bug#2412656 Added FERS_Coverage
fers_coverage,
non_disclosure_agmt_status,
part_time_indicator,
position_working_title,
previous_retirement_coverage,
MT_STATUS,
FLSA_CATEGORY,
BARGAINING_UNIT_STATUS,
functional_class,
supervisory_status,
position_occupied,
appropriation_code1,
appropriation_code2,
TYPE_OF_EMPLOYMENT,
RACE_OR_NATIONAL_ORIGIN,
AGENCY_CODE_TRANSFER_FROM,
ORIG_APPOINTMENT_AUTH_CODE_1,
ORIG_APPT_AUTH_CODE_1_DESC,--Bug# 8724192
ORIG_APPOINTMENT_AUTH_CODE_2,
ORIG_APPT_AUTH_CODE_2_DESC,--Bug# 8724192
HANDICAP_CODE,
CITIZENSHIP,
VETERANS_PREFERENCE,
VETERANS_PREFERENCE_FOR_RIF,
VETERANS_STATUS,
WORK_SCHEDULE,
CREDITABLE_MILITARY_SERVICE,
-- # BUG # 711533
SERVICE_COMP_DATE,
EDUCATIONAL_LEVEL,
ACADEMIC_DISCIPLINE,
YEAR_DEGREE_ATTAINED,
-- Bug # 712305
PART_TIME_HOURS,
-- Bug 4093771
to_basic_salary_rate,
TO_ADJUSTED_BASIC_PAY,
TO_TOTAL_SALARY,
ASSIGNMENT_NTE_START_DATE,--Bug# 8724192
ASSIGNMENT_NTE--Bug# 8724192
FROM ghr_mt_interface_v
WHERE national_identifier = p_national_identifier
AND mt_name = p_mt_name;
select count(*) COUNT
from ghr_mt_interface_v
where mt_name = p_mt_name
and mt_status = 'E';
SELECT PERSON_ID
, PERSON_EXTRA_INFO_ID
, OBJECT_VERSION_NUMBER
FROM PER_PEOPLE_EXTRA_INFO
WHERE PEI_INFORMATION6 = 'Y'
AND PEI_INFORMATION8 = to_char(p_mt_id)
AND INFORMATION_TYPE = 'GHR_US_PER_MASS_ACTIONS';
SELECT PA_REQUEST_EXTRA_INFO_ID,
OBJECT_VERSION_NUMBER
FROM GHR_PA_REQUEST_EXTRA_INFO
WHERE INFORMATION_TYPE = 'GHR_US_PAR_APPT_TRANSFER'
and pa_request_id = p_pa_request_id;
SELECT PA_REQUEST_EXTRA_INFO_ID,
OBJECT_VERSION_NUMBER
FROM GHR_PA_REQUEST_EXTRA_INFO
WHERE INFORMATION_TYPE = 'GHR_US_MASS_TRNSFR_NTE_DATES'
and pa_request_id = p_pa_request_id;
SELECT PA_REQUEST_EXTRA_INFO_ID,
OBJECT_VERSION_NUMBER
FROM GHR_PA_REQUEST_EXTRA_INFO
WHERE INFORMATION_TYPE = 'GHR_US_TRANS_CURN_APP_AUTH'
and pa_request_id = p_pa_request_id;
SELECT PA_REQUEST_ID
FROM GHR_MASS_TRANSFERS
WHERE MASS_TRANSFER_ID = p_mt_id
and TRANSFER_TYPE = 'IN';
SELECT asg.assignment_id
FROM per_assignments_f asg
WHERE asg.person_id = p_per_id
AND asg.assignment_type <> 'B'
AND trunc(p_eff_date) BETWEEN asg.effective_start_date AND asg.effective_end_date
ORDER BY asg.assignment_id;
hr_utility.set_message(8301, 'GHR_99999_SELECT_LAC_REMARKS');
ghr_par_extra_info_api.update_pa_request_extra_info
(p_validate => false,
p_rei_information3 => l_agency_code_transfer_from,
p_rei_information4 => l_appointment_type,
p_rei_information6 => l_creditable_military_service,
p_rei_information7 => l_date_arr_pers_office,
p_rei_information8 => l_date_wgi_due,
p_rei_information9 => l_frozen_service,
p_rei_information10 => l_handicap_code,
p_rei_information11 => l_non_disc_agmt_status,
------ p_rei_information12 => l_orig_appointment_auth_code1,
------ p_rei_information13 => l_orig_appointment_auth_code2,
p_rei_information14 => l_part_time_indicator,
p_rei_information15 => l_position_working_title,
p_rei_information16 => l_previous_retirement_coverage,
p_rei_information18 => l_race_or_national_origin,
p_rei_information19 => l_type_of_employment,
-- Bug#2412656 Added fers_coverage
p_rei_information21 => l_fers_coverage,
p_pa_request_extra_info_id => l_PA_REQUEST_EXTRA_INFO_ID,
p_object_version_number => l_pa_OBJECT_VERSION_NUMBER);
ghr_par_extra_info_api.update_pa_request_extra_info
(p_validate => false,
p_rei_information1 => l_orig_appointment_auth_code1,
p_rei_information2 => l_orig_appt_auth_code_1_desc,
p_rei_information3 => l_orig_appointment_auth_code2,
p_rei_information4 => l_orig_appt_auth_code_2_desc,
p_pa_request_extra_info_id => l_APP_AUTH_PA_REQUEST_EI_ID,
p_object_version_number => l_APP_AUTH_PA_OBJECT_VER_NUM);
ghr_par_extra_info_api.update_pa_request_extra_info
(p_validate => false,
p_rei_information10 => l_assignment_nte_start_date,
p_rei_information11 => l_assignment_nte,
p_pa_request_extra_info_id => l_NTE_PA_REQUEST_EI_ID,
p_object_version_number => l_NTE_PA_OBJECT_VER_NUM);
update ghr_mass_transfers
set status = 'E'
where mass_transfer_id = p_mtin_id;
update ghr_mass_transfers
set status = 'E'
where mass_transfer_id = p_mtin_id;
update ghr_mass_transfers
set status = decode(l_mt_status_err_cnt,0,'P','E')
where mass_transfer_id = p_mtin_id;
hr_utility.set_location('Err in Update mass_transfers Sql err '||sqlerrm(sqlcode),30);
update ghr_mass_transfers
set status = 'E'
where mass_transfer_id = p_mtin_id;
update ghr_mass_transfers
set status = 'E'
where mass_transfer_id = p_mtin_id;
update ghr_mass_transfers
set status = 'E'
where mass_transfer_id = p_mtin_id;
p_sf52_rec.last_updated_by := null;
p_sf52_rec.last_update_date := null;
p_sf52_rec.last_update_login := null;