[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
pa_request_id,
pa_notification_id,
noa_family_code,
routing_group_id,
proposed_effective_asap_flag,
academic_discipline,
additional_info_person_id,
additional_info_tel_number,
agency_code,
altered_pa_request_id,
annuitant_indicator,
annuitant_indicator_desc,
appropriation_code1,
appropriation_code2,
approval_date,
approving_official_full_name,
approving_official_work_title,
sf50_approval_date,
sf50_approving_ofcl_full_name,
sf50_approving_ofcl_work_title,
authorized_by_person_id,
authorized_by_title,
award_amount,
award_uom,
bargaining_unit_status,
citizenship,
concurrence_date,
custom_pay_calc_flag,
duty_station_code,
duty_station_desc,
duty_station_id,
duty_station_location_id,
education_level,
effective_date,
employee_assignment_id,
employee_date_of_birth,
employee_dept_or_agency,
employee_first_name,
employee_last_name,
employee_middle_names,
employee_national_identifier,
fegli,
fegli_desc,
first_action_la_code1,
first_action_la_code2,
first_action_la_desc1,
first_action_la_desc2,
first_noa_cancel_or_correct,
first_noa_code,
first_noa_desc,
first_noa_id,
first_noa_pa_request_id,
flsa_category,
forwarding_address_line1,
forwarding_address_line2,
forwarding_address_line3,
forwarding_country,
forwarding_country_short_name,
forwarding_postal_code,
forwarding_region_2,
forwarding_town_or_city,
from_adj_basic_pay,
from_agency_code,
from_agency_desc,
from_basic_pay,
from_grade_or_level,
from_locality_adj,
from_occ_code,
from_office_symbol,
from_other_pay_amount,
from_pay_basis,
from_pay_plan,
-- FWFA Changes Bug#4444609
input_pay_rate_determinant,
from_pay_table_identifier,
-- FWFA Changes
from_position_id,
from_position_org_line1,
from_position_org_line2,
from_position_org_line3,
from_position_org_line4,
from_position_org_line5,
from_position_org_line6,
from_position_number,
from_position_seq_no,
from_position_title,
from_step_or_rate,
from_total_salary,
functional_class,
notepad,
part_time_hours,
pay_rate_determinant,
personnel_office_id,
person_id,
position_occupied,
proposed_effective_date,
requested_by_person_id,
requested_by_title,
requested_date,
requesting_office_remarks_desc,
requesting_office_remarks_flag,
request_number,
resign_and_retire_reason_desc,
retirement_plan,
retirement_plan_desc,
second_action_la_code1,
second_action_la_code2,
second_action_la_desc1,
second_action_la_desc2,
second_noa_cancel_or_correct,
second_noa_code,
second_noa_desc,
second_noa_id,
second_noa_pa_request_id,
service_comp_date,
status,
supervisory_status,
tenure,
to_adj_basic_pay,
to_basic_pay,
to_grade_id,
to_grade_or_level,
to_job_id,
to_locality_adj,
to_occ_code,
to_office_symbol,
to_organization_id,
to_other_pay_amount,
to_au_overtime,
to_auo_premium_pay_indicator,
to_availability_pay,
to_ap_premium_pay_indicator,
to_retention_allowance,
to_supervisory_differential,
to_staffing_differential,
to_pay_basis,
to_pay_plan,
-- FWFA Changes Bug#4444609
to_pay_table_identifier,
-- FWFA Changes
to_position_id,
to_position_org_line1,
to_position_org_line2,
to_position_org_line3,
to_position_org_line4,
to_position_org_line5,
to_position_org_line6,
to_position_number,
to_position_seq_no,
to_position_title,
to_step_or_rate,
to_total_salary,
veterans_preference,
veterans_pref_for_rif,
veterans_status,
work_schedule,
work_schedule_desc,
year_degree_attained,
first_noa_information1,
first_noa_information2,
first_noa_information3,
first_noa_information4,
first_noa_information5,
second_lac1_information1,
second_lac1_information2,
second_lac1_information3,
second_lac1_information4,
second_lac1_information5,
second_lac2_information1,
second_lac2_information2,
second_lac2_information3,
second_lac2_information4,
second_lac2_information5,
second_noa_information1,
second_noa_information2,
second_noa_information3,
second_noa_information4,
second_noa_information5,
first_lac1_information1,
first_lac1_information2,
first_lac1_information3,
first_lac1_information4,
first_lac1_information5,
first_lac2_information1,
first_lac2_information2,
first_lac2_information3,
first_lac2_information4,
first_lac2_information5,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
first_noa_canc_pa_request_id ,
second_noa_canc_pa_request_id ,
to_retention_allow_percentage ,
to_supervisory_diff_percentage,
to_staffing_diff_percentage ,
award_percentage ,
rpa_type,
mass_action_id,
mass_action_eligible_flag,
mass_action_select_flag,
mass_action_comments,
-- Bug# RRR Changes
pa_incentive_payment_option,
award_salary,
-- Bug# RRR Changes
object_version_number
from ghr_pa_requests
where pa_request_id = p_pa_request_id;
select
pa_request_id,
pa_notification_id,
noa_family_code,
routing_group_id,
proposed_effective_asap_flag,
academic_discipline,
additional_info_person_id,
additional_info_tel_number,
agency_code,
altered_pa_request_id,
annuitant_indicator,
annuitant_indicator_desc,
appropriation_code1,
appropriation_code2,
approval_date,
approving_official_full_name,
approving_official_work_title,
sf50_approval_date,
sf50_approving_ofcl_full_name,
sf50_approving_ofcl_work_title,
authorized_by_person_id,
authorized_by_title,
award_amount,
award_uom,
bargaining_unit_status,
citizenship,
concurrence_date,
custom_pay_calc_flag,
duty_station_code,
duty_station_desc,
duty_station_id,
duty_station_location_id,
education_level,
effective_date,
employee_assignment_id,
employee_date_of_birth,
employee_dept_or_agency,
employee_first_name,
employee_last_name,
employee_middle_names,
employee_national_identifier,
fegli,
fegli_desc,
first_action_la_code1,
first_action_la_code2,
first_action_la_desc1,
first_action_la_desc2,
first_noa_cancel_or_correct,
first_noa_code,
first_noa_desc,
first_noa_id,
first_noa_pa_request_id,
flsa_category,
forwarding_address_line1,
forwarding_address_line2,
forwarding_address_line3,
forwarding_country,
forwarding_country_short_name,
forwarding_postal_code,
forwarding_region_2,
forwarding_town_or_city,
from_adj_basic_pay,
from_agency_code,
from_agency_desc,
from_basic_pay,
from_grade_or_level,
from_locality_adj,
from_occ_code,
from_office_symbol,
from_other_pay_amount,
from_pay_basis,
from_pay_plan,
-- FWFA Changes Bug#4444609
input_pay_rate_determinant,
from_pay_table_identifier,
-- FWFA Changes
from_position_id,
from_position_org_line1,
from_position_org_line2,
from_position_org_line3,
from_position_org_line4,
from_position_org_line5,
from_position_org_line6,
from_position_number,
from_position_seq_no,
from_position_title,
from_step_or_rate,
from_total_salary,
functional_class,
notepad,
part_time_hours,
pay_rate_determinant,
personnel_office_id,
person_id,
position_occupied,
proposed_effective_date,
requested_by_person_id,
requested_by_title,
requested_date,
requesting_office_remarks_desc,
requesting_office_remarks_flag,
request_number,
resign_and_retire_reason_desc,
retirement_plan,
retirement_plan_desc,
second_action_la_code1,
second_action_la_code2,
second_action_la_desc1,
second_action_la_desc2,
second_noa_cancel_or_correct,
second_noa_code,
second_noa_desc,
second_noa_id,
second_noa_pa_request_id,
service_comp_date,
status,
supervisory_status,
tenure,
to_adj_basic_pay,
to_basic_pay,
to_grade_id,
to_grade_or_level,
to_job_id,
to_locality_adj,
to_occ_code,
to_office_symbol,
to_organization_id,
to_other_pay_amount,
to_au_overtime,
to_auo_premium_pay_indicator,
to_availability_pay,
to_ap_premium_pay_indicator,
to_retention_allowance,
to_supervisory_differential,
to_staffing_differential,
to_pay_basis,
to_pay_plan,
-- FWFA Changes Bug#4444609
to_pay_table_identifier,
-- FWFA Changes
to_position_id,
to_position_org_line1,
to_position_org_line2,
to_position_org_line3,
to_position_org_line4,
to_position_org_line5,
to_position_org_line6,
to_position_number,
to_position_seq_no,
to_position_title,
to_step_or_rate,
to_total_salary,
veterans_preference,
veterans_pref_for_rif,
veterans_status,
work_schedule,
work_schedule_desc,
year_degree_attained,
first_noa_information1,
first_noa_information2,
first_noa_information3,
first_noa_information4,
first_noa_information5,
second_lac1_information1,
second_lac1_information2,
second_lac1_information3,
second_lac1_information4,
second_lac1_information5,
second_lac2_information1,
second_lac2_information2,
second_lac2_information3,
second_lac2_information4,
second_lac2_information5,
second_noa_information1,
second_noa_information2,
second_noa_information3,
second_noa_information4,
second_noa_information5,
first_lac1_information1,
first_lac1_information2,
first_lac1_information3,
first_lac1_information4,
first_lac1_information5,
first_lac2_information1,
first_lac2_information2,
first_lac2_information3,
first_lac2_information4,
first_lac2_information5,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
first_noa_canc_pa_request_id ,
second_noa_canc_pa_request_id ,
to_retention_allow_percentage ,
to_supervisory_diff_percentage,
to_staffing_diff_percentage ,
award_percentage ,
rpa_type,
mass_action_id,
mass_action_eligible_flag,
mass_action_select_flag,
mass_action_comments,
-- Bug# RRR Changes
pa_incentive_payment_option,
award_salary,
-- Bug# RRR Changes
object_version_number
from ghr_pa_requests
where pa_request_id = p_pa_request_id
for update nowait;
p_mass_action_select_flag in varchar2,
p_mass_action_comments in varchar2,
-- Bug#4486823 RRR Changes
p_payment_option in varchar2,
p_award_salary in number,
-- Bug#4486823 RRR Changes
p_object_version_number in number
)
Return g_rec_type is
--
l_rec g_rec_type;
l_rec.mass_action_select_flag := p_mass_action_select_flag;