[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_update34_date date;
select dst.duty_station_code
, lpa.locality_pay_area_code
from ghr_duty_stations_f dst
, ghr_locality_pay_areas_f lpa
where dst.LOCALITY_PAY_AREA_ID = lpa.LOCALITY_PAY_AREA_ID
and dst.DUTY_STATION_ID = p_loc_info.duty_station_id
and nvl(p_pa_request_rec.effective_date,trunc(sysdate))
between dst.effective_start_date and dst.effective_end_date
and nvl(p_pa_request_rec.effective_date,trunc(sysdate))
between lpa.effective_start_date and lpa.effective_end_date;
select effective_date
from ghr_pa_requests
where pa_notification_id is not null
and person_id = p_pa_request_rec.person_id
and effective_date <= p_pa_request_rec.effective_date
order by effective_date desc;
select dst.duty_station_code
, lpa.locality_pay_area_code
from ghr_duty_stations_f dst
, ghr_locality_pay_areas_f lpa
, hr_locations loc
, hr_location_extra_info lei
where
loc.location_id = p_sf52_from_data.duty_station_location_id
and lei.location_id = loc.location_id
and lei.information_type = 'GHR_US_LOC_INFORMATION'
and dst.duty_station_id = lei.lei_information3
and lpa.LOCALITY_PAY_AREA_ID = dst.LOCALITY_PAY_AREA_ID
and nvl(l_prior_ds_effective_date,trunc(sysdate))
between dst.effective_start_date and dst.effective_end_date
and nvl(l_prior_ds_effective_date,trunc(sysdate))
between lpa.effective_start_date and lpa.effective_end_date;
SELECT eev.element_entry_value_id,
eev.effective_start_date
FROM pay_element_types_f elt,
pay_input_values_f ipv,
pay_element_links_f eli,
pay_element_entries_f ele,
pay_element_entry_values_f eev
WHERE trunc(p_pa_request_rec.effective_date) between elt.effective_start_date
and elt.effective_end_date
and trunc(p_pa_request_rec.effective_date) between ipv.effective_start_date
and ipv.effective_end_date
and trunc(p_pa_request_rec.effective_date) between eli.effective_start_date
and eli.effective_end_date
and trunc(p_pa_request_rec.effective_date) between ele.effective_start_date
and ele.effective_end_date
and trunc(p_pa_request_rec.effective_date) between eev.effective_start_date
and eev.effective_end_date
and elt.element_type_id = ipv.element_type_id
--and elt.element_type_id = eli.element_type_id + 0 --commented for bug 5208846
and elt.element_type_id = eli.element_type_id
-- and upper(elt.element_name) = upper('Basic Salary Rate')
and upper(elt.element_name) = upper(p_element_name)
and ipv.input_value_id = eev.input_value_id
and ele.assignment_id = p_pa_request_rec.employee_assignment_id
-- and ele.element_entry_id + 0 = eev.element_entry_id --Commented for bug 5208846
and ele.element_entry_id = eev.element_entry_id
-- and upper(ipv.name) = upper('Salary');
SELECT FND_DATE.CANONICAL_TO_DATE(INFORMATION2) effective_start_date
FROM ghr_pa_history -- ghr_element_entry_values_h_v
WHERE TABLE_NAME = 'PAY_ELEMENT_ENTRY_VALUES_F'
AND INFORMATION1 = p_element_entry_value_id -- information1 holds element_entry_value_id
AND effective_date <= l_effective_date
AND pa_request_id not in
(SELECT pa_request_id
FROM ghr_pa_requests par
WHERE ((par.first_noa_id = l_session.noa_id_correct)
OR
(par.first_noa_code = '002' and par.second_noa_id = l_session.noa_id_correct))
CONNECT BY par.pa_request_id = prior par.altered_pa_request_id
START WITH par.pa_request_id = p_pa_request_rec.altered_pa_request_id )
ORDER BY 1 desc;
SELECT FND_DATE.CANONICAL_TO_DATE(INFORMATION2) effective_start_date
FROM ghr_pa_history -- ghr_assignments_h_v
WHERE TABLE_NAME = 'PER_ASSIGNMENTS_F'
AND INFORMATION1 = to_Char(p_assignment_id) -- information1 holds assignment_id
AND pa_request_id not in
(SELECT pa_request_id
FROM ghr_pa_history his
CONNECT BY his.pa_request_id = prior his.altered_pa_request_id
START WITH his.pa_request_id = p_pa_request_rec.altered_pa_request_id )
ORDER BY 1 desc;
select effective_start_date
from per_all_assignments_f
where assignment_id = p_assignment_id
and p_pa_request_rec.effective_date between
effective_start_date and nvl(effective_end_date,trunc(sysdate))
order by effective_start_date desc;
SELECT user_table_id
FROM pay_user_tables
WHERE user_table_id = pay_table_id
AND upper(user_table_name) like upper('%SPECIAL%RATE%');
SELECT 'X'
FROM ghr_pay_plans
WHERE equivalent_pay_plan = 'FW'
AND pay_plan = p_pay_plan;
select count(rei_information3) rei_count
from ghr_pa_request_extra_info
where pa_request_id = p_pa_request_rec.pa_request_id
and information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG'
and rei_information5 = 'Y'
and nvl(rei_information30,hr_api.g_varchar2) <> 'Original RPA';
SELECT count(person_extra_info_id) pei_count
FROM per_people_extra_info pei
WHERE pei.person_id = p_pa_request_rec.person_id
AND pei.information_type = 'GHR_US_RETAINED_GRADE'
AND l_effective_date
BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1) ,l_effective_date)
AND NVL(fnd_date.canonical_to_date(pei.pei_information2) ,l_effective_date);
select poei_information5 l_org_structure_id
from per_position_extra_info
where information_type='GHR_US_POS_GRP1' and position_id=p_position_id;
select second_action_la_code1,second_action_la_code2,first_noa_code,second_noa_code
from ghr_pa_requests
where pa_request_id=p_pa_request_id and first_noa_code='002';
select noa_family_code from ghr_noa_families
where nature_of_action_id=p_second_noa_id and noa_family_code='APP'
AND
nature_of_action_id not in (select nature_of_action_id from ghr_noa_families
where noa_family_code='APPT_TRANS');
SELECT rei_information3 temp_step
FROM ghr_pa_request_extra_info
WHERE pa_request_id = p_pa_request_rec.pa_request_id
AND information_type = 'GHR_US_PAR_RG_TEMP_PROMO';
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;
SELECT rei_information5
FROM ghr_pa_request_extra_info
WHERE pa_request_id=p_par_id
AND information_type='GHR_US_PAR_REALIGNMENT';
l_update34_date := ghr_pay_caps.update34_implemented_date(p_pa_request_rec.person_id);
If (l_update34_date is null
OR
nvl(p_pa_request_rec.effective_date,sysdate ) < l_update34_date)
-- and (p_pa_request_rec.noa_family_code<>'GHR_STUDENT_LOAN')
THEN
for pay_plan_rec in c_fw_pay_plans(l_to_pay_plan) loop
l_to_Basic_Pay := ghr_pay_calc.convert_amount(l_to_basic_pay,
l_to_pay_basis,
'PA');
elsif nvl(p_pa_request_rec.effective_date,sysdate ) >= l_update34_date THEN
for pay_plan_rec in c_fw_pay_plans(l_to_pay_plan) loop
l_to_Basic_Pay := ghr_pay_calc.convert_amount(l_to_basic_pay,
l_to_pay_basis,
'PA');