[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select asg.position_id
from per_all_assignments_f asg
where asg.person_id = per_id
and asg.assignment_type <> 'B'
and trunc(eff_date) between asg.effective_start_date
and asg.effective_end_date
and asg.primary_flag = 'Y';
select asg.position_id
from per_all_assignments_f asg
where asg.assignment_id = asg_id
and asg.assignment_type <> 'B'
and trunc(eff_date) between asg.effective_start_date
and asg.effective_end_date;
select asg.job_id
from per_all_assignments_f asg
where asg.person_id = per_id
and asg.assignment_type <> 'B'
and trunc(eff_date) between asg.effective_start_date
and asg.effective_end_date
and asg.primary_flag = 'Y';
select asg.job_id
from per_all_assignments_f asg
where asg.assignment_id = asg_id
and asg.assignment_type <> 'B'
and trunc(eff_date) between asg.effective_start_date
and asg.effective_end_date;
Select ppt.system_person_type
from per_all_people_f per,per_person_types ppt
where per.person_id = per_id
and trunc(eff_date) between per.effective_start_date
and per.effective_end_date
and per.person_type_id = ppt.person_type_id;
select per.business_group_id
from per_all_people_f per
where per.person_id = per_id
and trunc(eff_date) between per.effective_start_date
and per.effective_end_date;
select asg.business_group_id
from per_all_assignments_f asg
where asg.assignment_id = asg_id
and asg.assignment_type <> 'B'
and trunc(eff_date) between asg.effective_start_date
and asg.effective_end_date;
select oi.org_information1,
oi.org_information2,
oi.org_information3,
oi.org_information4,
oi.org_information5
from hr_organization_information oi
where oi.organization_id = org_id
and oi.org_information_context = 'GHR_US_ORG_INFORMATION';
select pdf.segment1
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment2
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment3
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment4
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment5
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment6
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment7
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment8
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment9
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment10
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment11
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment12
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment13
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment14
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment15
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment16
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment17
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment18
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment19
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment20
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment21
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment22
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment23
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment24
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment25
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment26
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment27
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment28
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment29
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select pdf.segment30
from hr_all_positions_f pos, per_position_definitions pdf
where pos.position_definition_id = pdf.position_definition_id
and pos.position_id = pos_id
and p_effective_date between pos.effective_start_date and pos.effective_end_date;
select jdf.segment1
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment2
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment3
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment4
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment5
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment6
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment7
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment8
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment9
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment10
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment11
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment12
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment13
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment14
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment15
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment16
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment17
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment18
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment19
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment20
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment21
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment22
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment23
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment24
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment25
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment26
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment27
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment28
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment29
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
select jdf.segment30
from per_jobs job, per_job_definitions jdf
where job.job_definition_id = jdf.job_definition_id
and job.job_id = p_job_id;
l_select_string
:= 'select pdf.' || p_information
|| ' from per_positions pos, per_position_definitions pdf'
|| ' where pos.position_definition_id = pdf.position_definition_id'
|| ' and pos.position_id = ' || p_id;
l_select_string
:= 'select jdf.' || p_information
|| ' from per_jobs job, per_job_definitions jdf'
|| ' where job.job_definition_id = jdf.job_definition_id'
|| ' and job.job_id = ' || p_id;
DBMS_SQL.PARSE(l_cursor_id, l_select_string, DBMS_SQL.V7);
select elt.processing_type
from pay_element_types_f elt
where trunc(eff_date) between elt.effective_start_date
and elt.effective_end_date
and upper(elt.element_name) = upper(ele_name)
--Ashley
and (elt.business_group_id is null or elt.business_group_id = bg_id);
select eev.screen_entry_value screen_entry_value
from pay_element_types_f elt,
pay_input_values_f ipv,
pay_element_entries_f ele,
pay_element_entry_values_f eev
where trunc(eff_date) between elt.effective_start_date
and elt.effective_end_date
and trunc(eff_date) between ipv.effective_start_date
and ipv.effective_end_date
and trunc(eff_date) between ele.effective_start_date
and ele.effective_end_date
and trunc(eff_date) between eev.effective_start_date
and eev.effective_end_date
and elt.element_type_id = ipv.element_type_id
and upper(elt.element_name) = upper(ele_name)
and ipv.input_value_id = eev.input_value_id
and ele.assignment_id = asg_id
and ele.element_entry_id + 0 = eev.element_entry_id
and upper(ipv.name) = upper(input_name)
-- and NVL(elt.business_group_id,0) = NVL(ipv.business_group_id,0) --Ashley
and (elt.business_group_id is null or elt.business_group_id = bg_id);
select eev.screen_entry_value screen_entry_value
from pay_element_types_f elt,
pay_input_values_f ipv,
pay_element_entries_f ele,
pay_element_entry_values_f eev
where trunc(eff_date) between elt.effective_start_date
and elt.effective_end_date
and trunc(eff_date) between ipv.effective_start_date
and ipv.effective_end_date
and ele.effective_end_date =
(select max(ele2.effective_end_date)
from pay_element_entries_f ele2
where ele2.element_entry_id = ele.element_entry_id)
and eev.effective_end_date =
(select max(eev2.effective_end_date)
from pay_element_entries_f eev2
where eev2.element_entry_id = eev.element_entry_id)
and elt.element_type_id = ipv.element_type_id
and upper(elt.element_name) = upper(ele_name)
and ipv.input_value_id = eev.input_value_id
and ele.assignment_id = asg_id
and ele.element_entry_id + 0 = eev.element_entry_id
and upper(ipv.name) = upper(input_name)
-- and NVL(elt.business_group_id,0) = NVL(ipv.business_group_id,0) --Ashley
and (elt.business_group_id is null or elt.business_group_id = bg_id);
Select distinct business_group_id bg
from per_assignments_f
where assignment_id = p_assignment_id
and p_eff_date between effective_start_date
and effective_end_date;
l_update34_date date;
select system_person_type
from per_all_people_f ppf,
per_person_types ppt
where ppf.person_id = p_person_id
and ppt.person_type_id = ppf.person_type_id;
select asg.assignment_id,
asg.organization_id,
asg.job_id,
asg.position_id,
asg.grade_id,
asg.location_id
from per_all_assignments_f asg
where asg.person_id = per_id
and asg.assignment_type <> 'B'
and trunc(eff_date) between asg.effective_start_date
and asg.effective_end_date
and asg.primary_flag = 'Y';
select asg.effective_end_date,asg.assignment_id,asg.organization_id,
asg.job_id,
asg.position_id,
asg.grade_id,
asg.location_id
from per_all_assignments_f asg
where asg.person_id = p_person_id
and asg.assignment_type <> 'B'
and asg.effective_start_date < p_effective_date
and asg.primary_flag = 'Y'
order by asg.effective_start_date desc;
SELECT asg.assignment_id,
asg.organization_id,
asg.job_id,
asg.position_id,
asg.grade_id,
asg.location_id
FROM per_all_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;
select asg.organization_id,
asg.job_id,
asg.position_id,
asg.grade_id,
asg.location_id
from per_all_assignments_f asg
where asg.assignment_id = asg_id
and asg.assignment_type <> 'B'
and trunc(eff_date) between asg.effective_start_date
and asg.effective_end_date;
select gdf.segment1,
gdf.segment2
from per_grades grd,
per_grade_definitions gdf
where grd.grade_id = grd_id
and grd.grade_definition_id = gdf.grade_definition_id;
select aei.aei_information3,
aei.aei_information6
from per_assignment_extra_info aei
where aei.assignment_id = asg_id
and aei.information_type = 'GHR_US_ASG_SF52';
select poi.poei_information6
from per_position_extra_info poi
where poi.position_id = pos_id
and poi.information_type = 'GHR_US_POS_VALID_GRADE';
select oi.org_information5,
oi.org_information6,
oi.org_information7,
oi.org_information8,
oi.org_information9,
oi.org_information10
from hr_organization_information oi
where oi.organization_id = org_id
and oi.org_information_context = 'GHR_US_ORG_REPORTING_INFO';
select job_id, business_group_id
from ghr_assignments_h_v
where pa_request_id =
(select min(pa_request_id)
from ghr_pa_requests
connect by pa_request_id = prior altered_pa_request_id
start with pa_request_id = p_altered_pa_request_id
and nature_of_action_id = p_noa_id_corrected
);
select job_id, business_group_id
from ghr_assignments_h_v
where pa_request_id =
(select min(pa_request_id)
from ghr_pa_requests
connect by pa_request_id = prior altered_pa_request_id
start with pa_request_id = p_altered_pa_request_id
);
select min(pa_request_id) pa_request_id
from ghr_pa_requests
connect by pa_request_id = prior altered_pa_request_id
start with pa_request_id = p_altered_pa_request_id;
Select par.employee_assignment_id,
par.from_adj_basic_pay,
par.from_basic_pay,
par.from_grade_or_level,
par.from_locality_adj,
par.from_occ_code,
par.from_office_symbol,
par.from_other_pay_amount,
par.from_pay_basis,
par.from_pay_plan,
par.from_position_id,
par.from_position_org_line1,
par.from_position_org_line2,
par.from_position_org_line3,
par.from_position_org_line4,
par.from_position_org_line5,
par.from_position_org_line6,
par.from_position_seq_no,
par.from_position_title,
par.from_position_number,
-- FWFA Changes Bug#4444609
par.from_pay_table_identifier,
-- FWFA Changes
par.from_step_or_rate,
par.from_total_salary
from ghr_pa_requests par
where pa_request_id = l_pa_request_id;
l_update34_date := ghr_pay_caps.update34_implemented_date(p_person_id);
hr_utility.set_location('Update 34 date is ' ||l_update34_date,10);
if l_update34_date is not null AND l_effective_date >= l_update34_date then
p_pay_basis := l_retained_grade.pay_basis;
select flx.id_flex_num
from fnd_id_flex_structures_tl flx
where flx.id_flex_code = 'PEA' --
and flx.application_id = 800 --
and flx.id_flex_structure_name = p_structure_name
and flx.language = 'US';
select pea.analysis_criteria_id,
pan.date_from, -- added for bug fix : 609285
pan.person_analysis_id,
pan.object_version_number,
pea.start_date_active,
pea.segment1,
pea.segment2,
pea.segment3,
pea.segment4,
pea.segment5,
pea.segment6,
pea.segment7,
pea.segment8,
pea.segment9,
pea.segment10,
pea.segment11,
pea.segment12,
pea.segment13,
pea.segment14,
pea.segment15,
pea.segment16,
pea.segment17,
pea.segment18,
pea.segment19,
pea.segment20,
pea.segment21,
pea.segment22,
pea.segment23,
pea.segment24,
pea.segment25,
pea.segment26,
pea.segment27,
pea.segment28,
pea.segment29,
pea.segment30
from per_analysis_Criteria pea,
per_person_analyses pan
where pan.person_id = p_person_id
and pan.id_flex_num = l_id_flex_num
and pea.analysis_Criteria_id = pan.analysis_criteria_id
and p_effective_date
between nvl(pan.date_from,p_effective_date)
and nvl(pan.date_to,p_effective_date)
and p_effective_date
between nvl(pea.start_date_active,p_effective_date)
and nvl(pea.end_date_active,p_effective_date)
order by 2 desc, 3 desc;
select flx.id_flex_num
from fnd_id_flex_structures_tl flx
where flx.id_flex_code = 'PEA' --
and flx.application_id = 800 --
and flx.id_flex_structure_name = 'US Fed Education'
and flx.language = 'US';
select pea.segment1,
pea.segment2,
pea.segment3,
pea.segment4,
pea.segment5,
pea.segment6,
pea.segment7,
pea.segment8,
pea.segment9,
pea.segment10,
pea.segment11,
pea.segment12,
pea.segment13,
pea.segment14,
pea.segment15,
pea.segment16,
pea.segment17,
pea.segment18,
pea.segment19,
pea.segment20
from per_analysis_criteria pea,
per_person_analyses pan
where pan.person_id = p_person_id
and pan.id_flex_num = l_id_flex_num
and pea.id_flex_num = pan.id_flex_num
and p_effective_date
between nvl(pan.date_from,p_effective_date)
and nvl(pan.date_to,p_effective_date)
and p_effective_date
between nvl(pea.start_date_active,p_effective_date)
and nvl(pea.end_date_active,p_effective_date)
and pan.analysis_criteria_id = pea.analysis_criteria_id
order by 1 desc;
select par.object_version_number
from ghr_pa_requests par
where par.pa_request_id = p_pa_request_id;
select count(*) cnt
from ghr_pa_routing_history
where pa_request_id = p_pa_request_id;
select count(1) act_cnt
from ghr_pa_routing_history
where pa_request_id = p_pa_request_id
and action_taken = 'INITIATED';
select pa_routing_history_id,
pa_request_id,
initiator_flag,
requester_flag,
authorizer_flag,
personnelist_flag,
approver_flag,
reviewer_flag,
approved_flag,
user_name,
user_name_employee_id,
user_name_emp_first_name,
user_name_emp_last_name,
user_name_emp_middle_names,
groupbox_id,
notepad ,
routing_list_id,
routing_seq_number,
nature_of_action_id,
noa_family_code,
second_nature_of_action_id,
object_version_number
from ghr_pa_routing_history
where pa_request_id = p_pa_request_id
order by pa_routing_history_id desc;
select name
from ghr_groupboxes
where groupbox_id = l_pa_routing_history_rec.groupbox_id;
If p_action_taken not in ('NOT_ROUTED','UPDATE_HR','CONTINUE') then
hr_utility.set_location(l_proc || p_action_taken,10);
If (p_action_taken = 'UPDATE_HR_COMPLETE'or p_action_taken = 'ENDED') and
p_old_action_taken = 'FUTURE_ACTION' then
hr_utility.set_location('nothing',1);
Else --(p_action_taken = 'UPDATE_HR_COMPLETE'or p_action_taken = 'ENDED')
hr_utility.set_location('else not Update Coplete',1);
End if; --(p_action_taken = 'UPDATE_HR_COMPLETE'or p_action_taken = 'ENDED')
p_action_taken ='UPDATE_HR_COMPLETE' then
ghr_wf_pkg.completeblockingoffutureaction
(p_pa_request_id => p_pa_request_id,
p_action_taken => p_action_taken,
p_error_msg => p_error);
End if; -- p_action_taken not in ('NOT_ROUTED','UPDATE_HR','CONTINUE')
SELECT rpm.restricted_proc_method
FROM FND_USER USR
, PER_PEOPLE_EXTRA_INFO PEI
, GHR_RESTRICTED_PROC_METHODS RPM
, GHR_PA_DATA_FIELDS PDF
WHERE usr.user_name = p_user_name
AND pdf.name = p_attribute
AND pei.person_id = usr.employee_id
AND pei.information_type = 'GHR_US_PER_USER_INFO'
AND rpm.restricted_form = pei.pei_information3
AND rpm.pa_data_field_id = pdf.pa_data_field_id;