The following lines contain the word 'select', 'insert', 'update' or 'delete':
select ivf.element_type_id
from per_all_assignments_f paf,
per_pay_bases pb, pay_input_values_f ivf
where paf.assignment_id = p_aid
--and paf.assignment_type = 'E'
and pb.pay_basis_id = paf.pay_basis_id
and pb.input_value_id = ivf.input_value_id
and p_date between paf.effective_start_date and paf.effective_end_date
and p_date between ivf.effective_start_date and ivf.effective_end_date;
select start_date, end_date
from per_time_periods
where p_eff_date_csr > start_date
and p_eff_date_csr <= end_date
and payroll_id = p_payroll_id_csr;
select trs.transaction_step_id
,trs.api_name
,trs.item_type
,trs.item_key
,trs.activity_id
,trs.creator_person_id
from hr_api_transaction_steps trs
where trs.item_type = p_item_type
and trs.item_key = p_item_key
order by trs.processing_order
,trs.transaction_step_id ; --#2313279
SELECT pay_basis_id
FROM per_all_assignments_f
WHERE assignment_id = l_assignment_id
AND l_effective_date between effective_start_date
and effective_end_date
AND assignment_type = 'E';
Select pp.proposed_salary_n*pay_annualization_factor
From per_pay_proposals pp, per_assignments_f paf,
per_pay_bases ppb
Where pp.assignment_id = p_assignment_id
And pp.business_group_id = p_bus_group_id
And pp.approved = 'Y'
And pp.assignment_id = paf.assignment_id
And trunc(pp.change_date) between paf.effective_start_date and paf.effective_end_date
And paf.pay_basis_id = ppb.pay_basis_id
Order By change_date desc;
SELECT job_information3
FROM per_jobs jobs , per_assignments_f asg
WHERE jobs.job_id = asg.job_id
-- AND jobs.business_group_id = asg.business_group_id
-- Fix 2094081
AND p_date between asg.effective_start_date and asg.effective_end_date
-- End Fix 2094081
AND asg.assignment_id = p_assignment_id
AND asg.business_group_id = p_bus_group_id ;
SELECT job_information3
FROM per_jobs jobs
WHERE jobs.job_id = p_job_id
AND jobs.business_group_id = p_bus_group_id ;
SELECT CUR.PRECISION
FROM FND_CURRENCIES_VL CUR
WHERE CUR.CURRENCY_CODE=p_currency_code
AND p_date BETWEEN
NVL(CUR.START_DATE_ACTIVE,p_date) AND
NVL(CUR.END_DATE_ACTIVE,p_date+1);
SELECT paf.grade_ladder_pgm_id,paf.assignment_type
FROM per_all_assignments_f paf
WHERE assignment_id = p_assignment_id
and p_effective_date between effective_start_date
and effective_end_date;
CURSOR lc_sal_updateable_grade_ladder
(p_grade_ladder_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE,
p_effective_date in date
) IS
select pgm_id from ben_pgm_f
where
-- grade ladder does not allow update of salary
(update_salary_cd <> 'NO_UPDATE' and update_salary_cd is not null)
-- salary updated by the progression system should not be manually overidden
--and (gsp_allow_override_flag is null or gsp_allow_override_flag = 'N')
and
pgm_id = p_grade_ladder_id
and p_effective_date between effective_start_date
and effective_end_date;
open lc_sal_updateable_grade_ladder(p_grade_ladder_id => p_new_grade_ladder_id,
p_effective_date => p_effective_date);
fetch lc_sal_updateable_grade_ladder into lc_temp_grade_ladder_id;
if (lc_sal_updateable_grade_ladder%FOUND) THEN
-- set exception message
-- it's an error, we cannot proceed further
p_excep_message := lv_msg_text;
open lc_sal_updateable_grade_ladder( p_grade_ladder_id => p_new_grade_ladder_id,
p_effective_date => p_effective_date);
fetch lc_sal_updateable_grade_ladder into lc_temp_grade_ladder_id;
if (lc_sal_updateable_grade_ladder%FOUND) THEN
hr_utility.set_location(l_proc,45);
open lc_sal_updateable_grade_ladder(p_grade_ladder_id => p_old_grade_ladder_id,
p_effective_date => p_effective_date);
fetch lc_sal_updateable_grade_ladder into lc_temp_grade_ladder_id;
if (lc_sal_updateable_grade_ladder%FOUND) THEN
-- set exception message
-- it's an error, we cannot proceed further
p_excep_message := lv_msg_text;
SELECT paf.payroll_id
,paf.pay_basis_id
,paf.business_group_id
,paf.assignment_type
,ppb.name old_salary_basis_name
,ppb.pay_annualization_factor old_pay_annual_factor
FROM per_all_assignments_f paf
,per_pay_bases ppb
WHERE assignment_id = p_assignment_id
and p_effective_date between effective_start_date
and effective_end_date
and paf.pay_basis_id = ppb.pay_basis_id(+);
SELECT pro.proposed_salary_n
,pro.change_date
FROM per_pay_proposals pro
WHERE pro.assignment_id = p_assignment_id
AND pro.change_date =(select max(pro2.change_date)
from per_pay_proposals pro2
where pro2.assignment_id = p_assignment_id
and pro2.change_date < p_effective_date);
select paf.pay_basis_id,
paf.assignment_type,
ppp.proposed_salary_n
from
per_all_assignments_f paf,
per_pay_proposals ppp
where paf.assignment_id = p_assignment_id
and p_effective_date between paf.effective_start_date and paf.effective_end_date
and ppp.assignment_id = paf.assignment_id
and p_effective_date between ppp.change_date and ppp.date_to;
hr_new_user_reg_ss.process_selected_transaction
(p_item_type => p_item_type,
p_item_key => p_item_key);
SELECT pay_basis INTO p_old_pay_basis
FROM per_pay_bases
WHERE pay_basis_id = p_old_pay_basis_id;
SELECT ppb.rate_basis
FROM PER_ALL_ASSIGNMENTS_F PAF, per_pay_bases ppb
WHERE PAF.ASSIGNMENT_ID=p_assignment_id
AND p_date BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE
and paf.pay_basis_id = ppb.pay_basis_id;
SELECT fnd_number.canonical_to_number(PGR.MINIMUM)
, fnd_number.canonical_to_number(PGR.MAXIMUM)
, fnd_number.canonical_to_number(PGR.MID_VALUE)
FROM PER_PAY_BASES PPB
, PAY_GRADE_RULES_F PGR
, PER_ALL_ASSIGNMENTS_F ASG
WHERE ASG.ASSIGNMENT_ID=p_assignment_id
AND PPB.PAY_BASIS_ID=ASG.PAY_BASIS_ID
AND PPB.RATE_ID=PGR.RATE_ID
AND ASG.GRADE_ID=PGR.GRADE_OR_SPINAL_POINT_ID
AND p_date BETWEEN asg.effective_start_date
AND asg.effective_end_date
AND p_date BETWEEN pgr.effective_start_date
AND pgr.effective_end_date;
select conversion_type
into l_conversion_type
from gl_daily_conversion_types
where user_conversion_type = l_value;
select
transaction_step_id
from
hr_api_transaction_steps
where
transaction_id = l_transaction_id;
hr_transaction_ss.delete_transaction_step(l_transaction_step_id,null,p_creator_person_id);
SELECT
paf.BUSINESS_GROUP_ID,
paf.payroll_id
FROM per_all_assignments_f paf
WHERE paf.assignment_id = p_assignment_id
AND NVL(p_effective_date, TRUNC(SYSDATE)) BETWEEN
paf.effective_start_date
AND paf.effective_end_date
AND assignment_type = 'E';
Select pay_proposal_id ,
change_date ,
next_sal_review_date,
next_perf_review_date ,
proposal_reason,
proposed_salary_n,
approved,
review_date,
multiple_components,
object_version_number
from PER_PAY_PROPOSALS
Where assignment_id = p_assignment_id
AND business_group_id = p_bg_id
order by change_date desc ;
aname => 'HR_SELECTED_PERSON_TYPE_ATTR');
p_api_mode := 'INSERT';
Select pay_proposal_id ,
change_date ,
next_sal_review_date,
next_perf_review_date ,
proposal_reason,
proposed_salary_n,
approved,
review_date,
multiple_components,
object_version_number
from PER_PAY_PROPOSALS
Where assignment_id = p_assignment_id
AND business_group_id = p_bg_id
order by change_date desc ;
SELECT ast.per_system_status,
ptp.status
FROM per_all_assignments_f asg,
per_time_periods ptp,
per_assignment_status_types ast
WHERE asg.assignment_id = p_assignment_id
AND asg.assignment_status_type_id = ast.assignment_status_type_id
AND to_date(p_effective_date,'RRRR-MM-DD')
between asg.effective_start_date
and asg.effective_end_date
AND asg.payroll_id=ptp.payroll_id;
Select 'Y'
FROM per_all_assignments_f
WHERE effective_start_date > to_date(p_effective_date,'RRRR-MM-DD')
AND assignment_id = p_assignment_id
AND business_group_id = p_bg_id ;
SELECT 'Y'
FROM per_spinal_point_placements_f pspp
WHERE pspp.assignment_id=p_assignment_id
AND to_date(p_effective_date,'RRRR-MM-DD') between
pspp.effective_start_date and pspp.effective_end_date ;
SELECT start_date
FROM per_time_periods
WHERE trunc(sysdate) between start_date and end_date
AND payroll_id = p_payroll_id;
p_api_mode := 'INSERT';
hr_maintain_proposal_api.insert_proposal_component(
p_component_id=>ln_component_id ,
p_pay_proposal_id=>p_ltt_salary_data(1).pay_proposal_id,
p_business_group_id=>p_ltt_salary_data(1).business_group_id,
p_approved => p_ltt_component(i).approved,
p_component_reason =>p_ltt_component(i).component_reason,
p_change_amount_n => to_number(p_ltt_component(i).change_amount),
p_change_percentage =>p_ltt_component(i).change_percent,
p_comments =>NULL,
p_attribute_category =>p_ltt_component(i).attribute_category,
p_attribute1 => p_ltt_component(i).attribute1,
p_attribute2 => p_ltt_component(i).attribute2,
p_attribute3 => p_ltt_component(i).attribute3,
p_attribute4 => p_ltt_component(i).attribute4,
p_attribute5 => p_ltt_component(i).attribute5,
p_attribute6 => p_ltt_component(i).attribute6,
p_attribute7 => p_ltt_component(i).attribute7,
p_attribute8 => p_ltt_component(i).attribute8,
p_attribute9 => p_ltt_component(i).attribute9,
p_attribute10 => p_ltt_component(i).attribute10,
p_attribute11 => p_ltt_component(i).attribute11,
p_attribute12 => p_ltt_component(i).attribute12,
p_attribute13 => p_ltt_component(i).attribute13,
p_attribute14 => p_ltt_component(i).attribute14,
p_attribute15 => p_ltt_component(i).attribute15,
p_attribute16 => p_ltt_component(i).attribute16,
p_attribute17 => p_ltt_component(i).attribute17,
p_attribute18 => p_ltt_component(i).attribute18,
p_attribute19 => p_ltt_component(i).attribute19,
p_attribute20 => p_ltt_component(i).attribute20,
p_object_version_number =>ln_object_version_number,
p_validate=>FALSE,
p_validation_strength=>'WEAK');
select pay_proposal_id, object_version_number
from per_pay_proposals
where assignment_id = p_ltt_salary_data(1).assignment_id
and change_date = ld_effec_date;
SAVEPOINT insert_salary ;
For multiple components to validated we need to insert the proposal record
that is the reason this API is called in FALSE mode and later it is rollbacked
*/
open csr_payproposal;
hr_maintain_proposal_api.update_salary_proposal(
p_pay_proposal_id=>l_pay_proposal_id ,
p_change_date=> ld_effec_date, -- 2355929
p_comments=>p_ltt_salary_data(1).comments,
p_next_sal_review_date=>p_ltt_salary_data(1).next_sal_review_date,
p_proposal_reason =>lv_proposal_reason,
p_proposed_salary_n =>p_ltt_salary_data(1).proposed_salary ,
p_forced_ranking =>to_number(p_ltt_salary_data(1).ranking) ,
p_performance_review_id=>
p_ltt_salary_data(1).Performance_review_id,
p_attribute_category =>p_ltt_salary_data(1).attribute_category,
p_attribute1 => p_ltt_salary_data(1).attribute1,
p_attribute2 => p_ltt_salary_data(1).attribute2,
p_attribute3 => p_ltt_salary_data(1).attribute3,
p_attribute4 => p_ltt_salary_data(1).attribute4,
p_attribute5 => p_ltt_salary_data(1).attribute5,
p_attribute6 => p_ltt_salary_data(1).attribute6,
p_attribute7 => p_ltt_salary_data(1).attribute7,
p_attribute8 => p_ltt_salary_data(1).attribute8,
p_attribute9 => p_ltt_salary_data(1).attribute9,
p_attribute10 => p_ltt_salary_data(1).attribute10,
p_attribute11 => p_ltt_salary_data(1).attribute11,
p_attribute12 => p_ltt_salary_data(1).attribute12,
p_attribute13 => p_ltt_salary_data(1).attribute13,
p_attribute14 => p_ltt_salary_data(1).attribute14,
p_attribute15 => p_ltt_salary_data(1).attribute15,
p_attribute16 => p_ltt_salary_data(1).attribute16,
p_attribute17 => p_ltt_salary_data(1).attribute17,
p_attribute18 => p_ltt_salary_data(1).attribute18,
p_attribute19 => p_ltt_salary_data(1).attribute19,
p_attribute20 => p_ltt_salary_data(1).attribute20,
p_object_version_number=>l_object_version_number ,
p_multiple_components=>p_ltt_salary_data(1).multiple_components,
p_approved=>'Y',
p_validate=>FALSE ,
p_inv_next_sal_date_warning=>l_next_sal_date_warning,
p_proposed_salary_warning=>l_proposed_sal_warning,
p_approved_warning=>l_approved_warning,
p_payroll_warning =>l_payroll_warning) ;
hr_maintain_proposal_api.insert_salary_proposal(
p_pay_proposal_id=>l_pay_proposal_id ,
p_assignment_id=>p_ltt_salary_data(1).assignment_id ,
p_business_group_id=>p_ltt_salary_data(1).business_group_id ,
--p_change_date=>p_ltt_salary_data(1).effective_date,
p_change_date=> ld_effec_date, -- 2355929
p_comments=>p_ltt_salary_data(1).comments,
p_next_sal_review_date=>p_ltt_salary_data(1).next_sal_review_date,
p_proposal_reason =>lv_proposal_reason,
p_proposed_salary_n =>p_ltt_salary_data(1).proposed_salary ,
p_forced_ranking =>to_number(p_ltt_salary_data(1).ranking) ,
p_performance_review_id=>
p_ltt_salary_data(1).Performance_review_id,
p_attribute_category =>p_ltt_salary_data(1).attribute_category,
p_attribute1 => p_ltt_salary_data(1).attribute1,
p_attribute2 => p_ltt_salary_data(1).attribute2,
p_attribute3 => p_ltt_salary_data(1).attribute3,
p_attribute4 => p_ltt_salary_data(1).attribute4,
p_attribute5 => p_ltt_salary_data(1).attribute5,
p_attribute6 => p_ltt_salary_data(1).attribute6,
p_attribute7 => p_ltt_salary_data(1).attribute7,
p_attribute8 => p_ltt_salary_data(1).attribute8,
p_attribute9 => p_ltt_salary_data(1).attribute9,
p_attribute10 => p_ltt_salary_data(1).attribute10,
p_attribute11 => p_ltt_salary_data(1).attribute11,
p_attribute12 => p_ltt_salary_data(1).attribute12,
p_attribute13 => p_ltt_salary_data(1).attribute13,
p_attribute14 => p_ltt_salary_data(1).attribute14,
p_attribute15 => p_ltt_salary_data(1).attribute15,
p_attribute16 => p_ltt_salary_data(1).attribute16,
p_attribute17 => p_ltt_salary_data(1).attribute17,
p_attribute18 => p_ltt_salary_data(1).attribute18,
p_attribute19 => p_ltt_salary_data(1).attribute19,
p_attribute20 => p_ltt_salary_data(1).attribute20,
p_object_version_number=>l_object_version_number ,
p_multiple_components=>p_ltt_salary_data(1).multiple_components,
p_approved=>'Y',
p_validate=>FALSE ,
p_element_entry_id=>l_element_entry_id,
p_inv_next_sal_date_warning=>l_next_sal_date_warning,
p_proposed_salary_warning=>l_proposed_sal_warning,
p_approved_warning=>l_approved_warning,
p_payroll_warning =>l_payroll_warning) ;
ROLLBACK to insert_salary ;
ROLLBACK to insert_salary;
ROLLBACK to insert_salary;
SELECT transaction_step_id
FROM hr_api_transaction_steps
WHERE item_type = c_item_type
AND item_key = c_item_key
--AND api_name = 'HR_PAY_RATE_SS.process_api_java';
gtt_trans_steps(li_count).param_name := 'p_selection_mode' ;
p_ltt_salary_data(1).selection_mode;
' selection_mode' || ltt_salary_data(1).selection_mode ||
' ovn' || ltt_salary_data(1).ovn ||
' currency' || ltt_salary_data(1).currency ||
' pay_basis_name' || ltt_salary_data(1).pay_basis_name ||
' annual_equivalent' || ltt_salary_data(1).annual_equivalent ||
' total_percent' || ltt_salary_data(1).total_percent ||
' quartile' || ltt_salary_data(1).quartile ||
' comparatio' || ltt_salary_data(1).comparatio ||
' lv_selection_mode' || ltt_salary_data(1).lv_selection_mode ||
' attribute_category' || ltt_salary_data(1).attribute_category ||
' attribute1' || ltt_salary_data(1).attribute1 ||
' attribute2' || ltt_salary_data(1).attribute2 ||
' attribute3' || ltt_salary_data(1).attribute3 ||
' attribute4' || ltt_salary_data(1).attribute4 ||
' attribute5' || ltt_salary_data(1).attribute5 ||
' attribute6' || ltt_salary_data(1).attribute6 ||
' attribute7' || ltt_salary_data(1).attribute7 ||
' attribute8' || ltt_salary_data(1).attribute8 ||
' attribute9' || ltt_salary_data(1).attribute9 ||
' attribute10' || ltt_salary_data(1).attribute10 ||
' attribute11' || ltt_salary_data(1).attribute11 ||
' attribute12' || ltt_salary_data(1).attribute12 ||
' attribute13' || ltt_salary_data(1).attribute13 ||
' attribute14' || ltt_salary_data(1).attribute14 ||
' attribute15' || ltt_salary_data(1).attribute15 ||
' attribute16' || ltt_salary_data(1).attribute16 ||
' attribute17' || ltt_salary_data(1).attribute17 ||
' attribute18' || ltt_salary_data(1).attribute18 ||
' attribute19' || ltt_salary_data(1).attribute19 ||
' attribute20' || ltt_salary_data(1).attribute20 ||
' no_of_components' || ltt_salary_data(1).no_of_components ;
hr_new_user_reg_ss.process_selected_transaction
(p_item_type => p_item_type,
p_item_key => p_item_key);
if (p_api_mode = 'INSERT') then
hr_utility.set_location(l_proc,20);
p_ltt_salary_data(1).selection_mode:=
hr_transaction_api.get_varchar2_value
(p_transaction_step_id => ln_transaction_step_id,
p_name => 'p_selection_mode');
p_ltt_salary_data(1).selection_mode:=
hr_transaction_api.get_varchar2_value
(p_transaction_step_id => ln_transaction_step_id,
p_name => 'p_selection_mode');
savepoint insert_salary_details;
null,--selection_mode VARCHAR2(1),
null,--ovn NUMBER,
null,--currency VARCHAR2(15),
null,--pay_basis_name VARCHAR2(80),
null,--annual_equivalent NUMBER ,
null,--total_percent NUMBER ,
null,--quartile NUMBER ,
null,--comparatio NUMBER ,
null,--lv_selection_mode VARCHAR2(1),
null,--attribute_category VARCHAR2(150),
null,--attribute1 VARCHAR2(150),
null,--attribute2 VARCHAR2(150),
null,--attribute3 VARCHAR2(150),
null,--attribute4 VARCHAR2(150),
null,--attribute5 VARCHAR2(150),
null,--attribute6 VARCHAR2(150),
null,--attribute7 VARCHAR2(150),
null,--attribute8 VARCHAR2(150),
null,--attribute9 VARCHAR2(150),
null,--attribute10 VARCHAR2(150),
null,--attribute11 VARCHAR2(150),
null,--attribute12 VARCHAR2(150),
null,--attribute13 VARCHAR2(150),
null,--attribute14 VARCHAR2(150),
null,--attribute15 VARCHAR2(150),
null,--attribute16 VARCHAR2(150),
null,--attribute17 VARCHAR2(150),
null,--attribute18 VARCHAR2(150),
null,--attribute19 VARCHAR2(150),
null,--attribute20 VARCHAR2(150),
null, --no_of_components NUMBER,
-- 04/12/02 Salary Basis Enhancement Begins
null, -- salary_basis_change_type varchar2(30)
null, -- default_date date
null, -- default_bg_id number
null, -- default_currency VARCHAR2(15)
null, -- default_format_string VARCHAR2(40)
null, -- default_salary_basis_name varchar2(30)
null, -- default_pay_basis_name varchar2(80)
null, -- default_pay_basis varchar2(30)
null, -- default_pay_annual_factor number
null, -- default_grade VARCHAR2(240)
null, -- default_grade_annual_factor number
null, -- default_minimum_salary number
null, -- default_maximum_salary number
null, -- default_midpoint_salary number
null, -- default_prev_salary number
null, -- default_last_change_date date
null, -- default_element_entry_id number
null, -- default_basis_changed number
null, -- default_uom VARCHAR2(30)
null, -- default_grade_uom VARCHAR2(30)
null, -- default_change_amount number
null, -- default_change_percent number
null, -- default_quartile number
null, -- default_comparatio number
null, -- default_last_pay_change varchar2(200)
null, -- default_flsa_status varchar2(80)
null, -- default_currency_symbol varchar2(4)
null, -- default_precision number
-- 04/12/02 Salary Basis Enhancement Ends
-- GSP
null, -- salary_effective_date date
null, -- gsp_dummy_txn flag
--End of GSP
null,
null,
null,
null,
null
));
select VARCHAR2_VALUE into l_flow_mode from hr_api_transaction_values where TRANSACTION_STEP_ID = p_transaction_step_id and NAME = 'P_FLOW_MODE';
' selection_mode' || ltt_salary_data(1).selection_mode ||
' ovn' || ltt_salary_data(1).ovn ||
' currency' || ltt_salary_data(1).currency ||
' pay_basis_name' || ltt_salary_data(1).pay_basis_name ||
' annual_equivalent' || ltt_salary_data(1).annual_equivalent ||
' total_percent' || ltt_salary_data(1).total_percent ||
' quartile' || ltt_salary_data(1).quartile ||
' comparatio' || ltt_salary_data(1).comparatio ||
' lv_selection_mode' || ltt_salary_data(1).lv_selection_mode ||
' attribute_category' || ltt_salary_data(1).attribute_category ||
' attribute1' || ltt_salary_data(1).attribute1 ||
' attribute2' || ltt_salary_data(1).attribute2 ||
' attribute3' || ltt_salary_data(1).attribute3 ||
' attribute4' || ltt_salary_data(1).attribute4 ||
' attribute5' || ltt_salary_data(1).attribute5 ||
' attribute6' || ltt_salary_data(1).attribute6 ||
' attribute7' || ltt_salary_data(1).attribute7 ||
' attribute8' || ltt_salary_data(1).attribute8 ||
' attribute9' || ltt_salary_data(1).attribute9 ||
' attribute10' || ltt_salary_data(1).attribute10 ||
' attribute11' || ltt_salary_data(1).attribute11 ||
' attribute12' || ltt_salary_data(1).attribute12 ||
' attribute13' || ltt_salary_data(1).attribute13 ||
' attribute14' || ltt_salary_data(1).attribute14 ||
' attribute15' || ltt_salary_data(1).attribute15 ||
' attribute16' || ltt_salary_data(1).attribute16 ||
' attribute17' || ltt_salary_data(1).attribute17 ||
' attribute18' || ltt_salary_data(1).attribute18 ||
' attribute19' || ltt_salary_data(1).attribute19 ||
' attribute20' || ltt_salary_data(1).attribute20 ;
rollback to insert_salary_details;
ROLLBACK to insert_salary_details;
select pay.pay_proposal_id,
asf.assignment_id,
asf.pay_basis_id,
pay.proposed_salary_n,
pb.name
from
per_all_assignments_f asf,
per_pay_proposals pay,
per_pay_bases pb,
pay_input_values_f pv
where asf.person_id = p_person_id
and asf.assignment_type = 'O'
and asf.business_group_id = p_bg_id
and asf.organization_id = p_org_id
and p_effective_date between asf.effective_start_date and asf.effective_end_date
and pay.assignment_id =asf.assignment_id
and pb.business_group_id = p_bg_id
and pb.pay_basis_id = nvl(asf.pay_basis_id,-1)
and pb.input_value_id = pv.input_value_id
and p_effective_date between pv.effective_start_date and pv.effective_end_date;
procedure delete_transaction_step
(p_transaction_id in number,
p_login_person_id in number ) is
l_proc varchar2(200) := g_package || 'delete_transaction_step';
select transaction_step_id
from hr_api_transaction_steps
where transaction_id = p_transaction_id
and api_name = 'HR_PAY_RATE_SS.PROCESS_API';
HR_TRANSACTION_SS.delete_transaction_step(
p_transaction_step_id =>l_transaction_step_id,
p_login_person_id => p_login_person_id);