[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select
fed_information1,
fed_information2,
fed_information3,
fed_information4,
fed_information5,
fed_information6,
fed_information7,
fed_information8,
fed_information9
from
pay_us_federal_tax_info_f
where
fed_information_category = '403B LIMITS'
and p_date between effective_start_date and nvl(effective_end_date, p_date);
select
db.defined_balance_id
from
pay_balance_types pbt,
pay_defined_balances db,
pay_balance_dimensions bd
where
pbt.balance_name = 'Qualified EE ER Contribution'
and pbt.balance_type_id = db.balance_type_id
and bd.dimension_name = 'Person Lifetime to Date'
and bd.balance_dimension_id = db.balance_dimension_id;
SELECT max(service.date_start) start_date
FROM per_periods_of_service service,
per_all_assignments_f ass
WHERE ass.assignment_id = p_assignment_id
AND ass.person_id = service.person_id
AND service.date_start <= l_effective_date;
SELECT max(service.date_start) start_date
FROM per_periods_of_service service,
per_all_assignments_f ass
WHERE ass.assignment_id = p_assignment_id
AND ass.person_id = service.person_id
AND service.date_start <= l_effective_date;
select person_id
from per_assignments_f
where assignment_id = p_assignment_id;
select c.person_id
from ben_prtt_enrt_rslt_f c,
ben_pl_regn_f b,
ben_regn_f a
where c.person_id = l_person_id
and a.sttry_citn_name = 'IRC S457'
and b.regn_id = a.regn_id
and c.pl_id = b.pl_id
and l_effective_date between a.effective_start_date and
nvl(a.effective_end_date,l_effective_date)
and l_effective_date between b.effective_start_date and
nvl(b.effective_end_date,l_effective_date)
and l_effective_date between c.enrt_cvg_strt_dt and c.enrt_cvg_thru_dt
and c.enrt_cvg_thru_dt <= c.effective_end_date
and c.prtt_enrt_rslt_stat_cd is null;
SELECT pro.proposed_salary_n Last_Apprv_Sal, pro.change_date,
pro.proposed_salary_n *
nvl(ppb.pay_annualization_factor,tpt.number_per_fiscal_year) last_anul_sal
FROM per_people_f per,
per_time_period_types tpt,
per_assignments_f ass,
per_pay_bases ppb,
per_pay_proposals pro,
pay_all_payrolls_f prl
WHERE per.person_id = ass.person_id
AND ass.pay_basis_id = ppb.pay_basis_id
AND ass.assignment_type = 'E'
AND ass.payroll_id = prl.payroll_id
AND ass.effective_start_date BETWEEN prl.effective_start_date AND
nvl(prl.effective_end_date, ass.effective_start_date)
AND prl.period_type = tpt.period_type
AND ass.assignment_id = pro.assignment_id(+)
AND pro.change_date = (SELECT MAX(change_date)
FROM per_pay_proposals pro1
WHERE pro.assignment_id = pro1.assignment_id
AND pro1.approved = 'Y'
AND pro1.change_date <= l_effective_date)
AND ass.business_group_ID + 0 = NVL(hr_general.get_business_group_id,
ass.business_group_id)
AND l_effective_date BETWEEN per.effective_start_date
AND nvl(per.effective_end_date, l_effective_date)
AND l_effective_date BETWEEN ass.effective_start_date
AND nvl(ass.effective_end_date, l_effective_date)
AND ass.assignment_id = p_assignment_id;
Select
fed_information1,
fed_information2,
fed_information3
from
pay_us_federal_tax_info_f
where
fed_information_category = '457 LIMITS'
and p_date between effective_start_date and
nvl(effective_end_date, p_date);
select
sum(max(contr.max_contr_allowed) - sum(contr.amt_contr)) amt
from
pay_us_contribution_history contr,
per_assignments_f paf
where
paf.assignment_id = p_assignment_id
and l_effective_date between paf.effective_start_date and
nvl(paf.effective_end_date, l_effective_date)
and contr.person_id = paf.person_id
and contr.contr_type = 'G'
and contr.date_to < l_effective_date
and contr.legislation_code = 'US'
group by contr.date_to;
select min(effective_start_date),
max(effective_end_date)
from pay_element_entries_f
where element_entry_id = p_ctx_original_entry_id
group by element_entry_id;
select min(effective_start_date),
max(effective_end_date)
from pay_element_entries_f
where element_entry_id = p_ctx_original_entry_id
group by element_entry_id;
select pet.element_type_id, pet.element_name, pee.assignment_id,
nvl(pet.element_information13,'N'),
nvl(pet.element_information1, 'NONREG'),
pec.classification_name
from pay_element_entries_f pee,
pay_element_links_f pel,
pay_element_types_f pet,
pay_element_classifications pec
where pee.element_entry_id = cp_original_entry_id
and pel.element_link_id = pee.element_link_id
and pel.element_type_id = pet.element_type_id
and pec.classification_id = pet.classification_id
and pec.legislation_code = 'US'
and pee.effective_end_date between pel.effective_start_date
and pel.effective_end_date
and pee.effective_end_date between pet.effective_start_date
and pet.effective_end_date;
select ETYPE.element_type_id, ETYPE.element_name
from per_all_assignments_f ASSIGN
,per_pay_bases BASES
,pay_input_values_f INPUTV
,pay_element_types_f ETYPE
,pay_rates RATE
where cp_date BETWEEN ASSIGN.effective_start_date
AND ASSIGN.effective_end_date
and ASSIGN.assignment_id = cp_assignment_id
and BASES.pay_basis_id (+)= ASSIGN.pay_basis_id
and INPUTV.input_value_id (+)= BASES.input_value_id
and cp_date between nvl (INPUTV.effective_start_date,cp_date)
and nvl (INPUTV.effective_end_date,cp_date)
and ETYPE.element_type_id (+)= INPUTV.element_type_id
and cp_date between nvl (ETYPE.effective_start_date,cp_date)
and nvl (ETYPE.effective_end_date,cp_date)
and RATE.rate_id (+)= BASES.rate_id ;
select definition_name
from pay_time_definitions
where time_definition_id = cp_time_definition_id;