The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 1
FROM ghr_pay_plans ppl
WHERE ppl.pay_plan = p_pay_plan
AND ppl.equivalent_pay_plan = 'FW';
SELECT 1
FROM ghr_pay_plans ppl
WHERE ppl.pay_plan = p_pay_plan
AND ppl.equivalent_pay_plan = 'GS';
FUNCTION update34_implemented_date (p_person_id IN NUMBER)
RETURN DATE IS
CURSOR cur_update34_date is
SELECT fnd_date.canonical_to_date(pei_information3) update34_date
FROM per_people_extra_info
WHERE information_type = 'GHR_US_PER_UPDATE34'
AND person_id = p_person_id;
FOR cur_update34_date_rec IN cur_update34_date LOOP
l_date := cur_update34_date_rec.update34_date;
END update34_implemented_date;
SELECT job_id
FROM hr_all_positions_f pos
WHERE pos.position_id = p_position_id
AND p_effective_date BETWEEN pos.effective_start_date and pos.effective_end_date;
SELECT name
FROM per_jobs
WHERE job_id = l_job_id;
PROCEDURE update34_implement (p_person_id IN NUMBER
,P_date IN DATE)
IS
l_date date;
l_date := update34_implemented_date (p_person_id);
,p_information_type => 'GHR_US_PER_UPDATE34'
,P_EFFECTIVE_DATE => p_date
,P_PEI_information_category => 'GHR_US_PER_UPDATE34'
,P_PEI_INFORMATION3 => fnd_date.date_to_canonical(p_date)
,p_PERSON_EXTRA_INFO_ID => l_PERSON_EXTRA_INFO_ID
,P_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER);
END update34_implement;
SELECT asg.organization_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;
SELECT distinct cert_group
FROM ghr_perf_cert
WHERE cert_agency = substr(p_agency_code,1,2)
AND cert_agency_sub_code IS NULL
AND cert_organization IS NULL
AND p_eff_date BETWEEN cert_start_date AND nvl(cert_end_date,to_date('31/12/4712','DD/MM/YYYY') )
AND ( INSTR(cert_group,p_pay_plan) > 0 )
--Bug # 10272986 Added Business Group Id
AND NVL(business_group_id,p_business_group_id) = p_business_group_id;
SELECT cert_group
FROM ghr_perf_cert
WHERE cert_agency IS NULL
AND cert_agency_sub_code = p_agency_sub_code
AND cert_organization IS NULL
AND p_eff_date BETWEEN cert_start_date AND nvl(cert_end_date,to_date('31/12/4712','DD/MM/YYYY') )
AND ( INSTR(cert_group,p_pay_plan) > 0 )
--Bug # 10272986 Added Business Group Id
AND NVL(business_group_id,p_business_group_id) = p_business_group_id;
SELECT cert_group
FROM ghr_perf_cert
WHERE cert_agency IS NULL
AND cert_agency_sub_code IS NULL
AND cert_organization = p_org_id
AND p_eff_date BETWEEN cert_start_date AND nvl(cert_end_date,to_date('31/12/4712','DD/MM/YYYY') )
AND ( INSTR(cert_group,p_pay_plan) > 0 )
--Bug # 10272986 Added Business Group Id
AND NVL(business_group_id,p_business_group_id) = p_business_group_id;
SELECT equivalent_pay_plan
FROM ghr_pay_plans ppl
WHERE ppl.pay_plan = p_pay_plan;
SELECT udr.row_low_range_or_name,udr.row_high_range
FROM pay_user_columns udc,
pay_user_rows_f udr,
pay_user_tables udt,
pay_user_column_instances_f uci
WHERE udt.user_table_id = l_user_table_id
AND udr.user_table_id = udt.user_table_id
AND NVL(p_effective_date,TRUNC(SYSDATE)) BETWEEN udr.effective_start_date AND udr.effective_end_date
AND udc.user_table_id = udt.user_table_id
AND uci.user_column_id = udc.user_column_id
AND udr.user_row_id = uci.user_row_id
AND upper(udc.user_column_name) = upper(l_user_clomun_name)
AND NVL(p_effective_date,TRUNC(SYSDATE)) BETWEEN uci.effective_start_date AND uci.effective_end_date;
l_update34_date DATE;
SELECT gdf.segment1 pay_plan
,gdf.segment2 grade_or_level
FROM per_grade_definitions gdf
,per_grades grd
WHERE grd.grade_id = l_grade_id
AND grd.grade_definition_id = gdf.grade_definition_id;
select asg.assignment_id
from per_assignments_f asg
where asg.person_id = per_id
and trunc(eff_date) between asg.effective_start_date
and asg.effective_end_date
and asg.primary_flag = 'Y';
SELECT ORGANIZATION_ID FROM HR_POSITIONS_F
WHERE position_id=p_pos_id
AND p_eff_date between effective_start_Date and effective_end_date;
SELECT lc.locality_pay_area_code
FROM ghr_duty_stations_f ds, ghr_locality_pay_areas_f lc
WHERE ds.duty_station_id = p_duty_station_id
AND ds.locality_pay_area_id = lc.locality_pay_area_id
AND p_effective_date between ds.effective_start_date and ds.effective_end_date
AND p_effective_date between lc.effective_start_date and lc.effective_end_date;
l_update34_date := update34_implemented_date(p_person_id);
if l_update34_date is not null AND p_effective_date >= l_update34_date then
-----if the pay basis is null then raise a error message
l_pay_basis := l_retained_grade.pay_basis;
if l_update34_date is not null AND p_effective_date >= l_update34_date then
p_locality_adj := ghr_pay_calc.convert_amount(l_converted_locality_adj
, 'PA'
,l_pay_basis);
IF l_update34_date is not null AND p_effective_date >= l_update34_date THEN
p_locality_adj := ghr_pay_calc.convert_amount(l_converted_locality_adj
, 'PA'
,l_pay_basis);