[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
iv.name,
iv.uom,
iv.display_sequence,
iv.input_value_id,
iv.element_type_id,
eev.screen_entry_value,
eev.element_entry_value_id,
eev.effective_start_date eev_effective_start_date,
eev.effective_end_date eev_effective_end_date,
ee.cost_allocation_keyflex_id,
ee.reason,
ee.effective_start_date,
ee.effective_end_date,
ee.element_entry_id
from
pay_element_entry_values_f eev,
pay_element_entries_f ee,
per_all_assignments_f asg,
pay_input_values_f iv
where
asg.person_id = p_person_id
and asg.assignment_id = ee.assignment_id
and ee.element_entry_id = eev.element_entry_id
and iv.input_value_id = eev.input_value_id
and (ben_ext_person.g_chg_input_value_id is null
or ben_ext_person.g_chg_input_value_id = iv.input_value_id
)
and p_effective_date between asg.effective_start_date and asg.effective_end_date
and p_effective_date between ee.effective_start_date and ee.effective_end_date
and p_effective_date between eev.effective_start_date and eev.effective_end_date
and p_effective_date between iv.effective_start_date and iv.effective_end_date
;
SELECT val_1
FROM BEN_EXT_CRIT_VAL val,
BEN_EXT_CRIT_TYP typ,
BEN_EXT_CRIT_PRFL prfl
WHERE val.ext_crit_typ_id = typ.ext_crit_typ_id
AND typ.ext_crit_prfl_id = prfl.ext_crit_prfl_id
AND prfl.name = 'PQP GB PenServer Periodic Changes Criteria - Allowance History'
AND prfl.legislation_code = 'GB'
AND typ.crit_typ_cd = 'CPE'
AND typ.legislation_code = 'GB'
AND val.legislation_code = 'GB';
select
et.element_name,
et.reporting_name,
et.description,
et.classification_id,
et.processing_type,
et.input_currency_code,
et.output_currency_code,
et.formula_id -- skip rule
from pay_element_types_f et
where et.element_type_id = p_element_type_id
and p_effective_date between et.effective_start_date and et.effective_end_date
;
select ec.classification_name
from pay_element_classifications ec
where ec.classification_id = p_classification_id
;
select ff.formula_name
from ff_formulas_f ff
where ff.formula_id = p_formula_id
and p_effective_date between ff.effective_start_date and ff.effective_end_date
;
select ca.concatenated_segments
from pay_cost_allocation_keyflex ca
where ca.cost_allocation_keyflex_id = p_cost_allocation_keyflex_id
;
select
et.element_name,
et.element_type_id,
et.reporting_name,
et.description,
et.classification_id,
ec.classification_name,
et.processing_type,
et.input_currency_code,
et.output_currency_code,
et.formula_id, -- skip rule
ff.formula_name,
iv.name,
iv.uom,
iv.display_sequence,
iv.input_value_id,
eev.screen_entry_value,
eev.element_entry_value_id,
eev.effective_start_date eev_effective_start_date,
eev.effective_end_date eev_effective_end_date,
ee.cost_allocation_keyflex_id,
ca.concatenated_segments,
ee.reason,
ee.effective_start_date,
ee.effective_end_date,
ee.element_entry_id
from
pay_element_entry_values_f eev,
pay_element_entries_f ee,
per_all_assignments_f asg,
per_all_people_f per,
pay_input_values_f iv,
pay_element_types_f et,
pay_element_classifications ec,
ff_formulas_f ff,
pay_cost_allocation_keyflex ca
where
per.person_id = p_person_id
and iv.input_value_id = nvl(ben_ext_person.g_chg_input_value_id,iv.input_value_id)
and ee.element_entry_id = eev.element_entry_id
and asg.assignment_id = ee.assignment_id
and per.person_id = asg.person_id
and iv.input_value_id = eev.input_value_id
and iv.element_type_id = et.element_type_id
and et.classification_id = ec.classification_id (+)
and ee.cost_allocation_keyflex_id = ca.cost_allocation_keyflex_id (+)
and et.formula_id = ff.formula_id (+)
and p_effective_date between nvl(asg.effective_start_date,p_effective_date)
and nvl(asg.effective_end_date ,p_effective_date)
and p_effective_date between nvl(per.effective_start_date,p_effective_date)
and nvl(per.effective_end_date ,p_effective_date)
and p_effective_date between nvl(ee.effective_start_date,p_effective_date)
and nvl(ee.effective_end_date ,p_effective_date)
and p_effective_date between nvl(eev.effective_start_date,p_effective_date)
and nvl(eev.effective_end_date ,p_effective_date)
and p_effective_date between nvl(iv.effective_start_date,p_effective_date)
and nvl(iv.effective_end_date ,p_effective_date)
and p_effective_date between nvl(et.effective_start_date,p_effective_date)
and nvl(et.effective_end_date ,p_effective_date)
and p_effective_date between nvl(ff.effective_start_date,p_effective_date)
and nvl(ff.effective_end_date,p_effective_date);
select
iv.name,
iv.uom,
iv.display_sequence,
iv.input_value_id,
iv.element_type_id,
eev.screen_entry_value,
eev.element_entry_value_id,
eev.effective_start_date eev_effective_start_date,
eev.effective_end_date eev_effective_end_date,
ee.cost_allocation_keyflex_id,
ee.reason,
ee.effective_start_date,
ee.effective_end_date,
ee.element_entry_id
from
pay_element_entry_values_f eev,
pay_element_entries_f ee,
per_all_assignments_f asg,
pay_input_values_f iv
where
asg.person_id = p_person_id
and asg.assignment_id = ee.assignment_id
and ee.element_entry_id = eev.element_entry_id
and iv.input_value_id = eev.input_value_id
and ee.element_type_id in (Select element_type_id
From PAY_ELEMENT_TYPE_RULES rule,
PAY_EVENT_GROUP_USAGES usg,
pay_event_groups grp
Where rule.element_set_id = usg.element_set_id
AND usg.event_group_id = grp.event_group_id
AND grp.event_group_name = 'PQP_GB_PSI_ALL_ELEMENT_ENTRIES'
AND grp.legislation_code = 'GB')
and (ben_ext_person.g_chg_input_value_id is null
or ben_ext_person.g_chg_input_value_id = iv.input_value_id
)
and p_effective_date between asg.effective_start_date and asg.effective_end_date
and p_effective_date between ee.effective_start_date and ee.effective_end_date
and p_effective_date between eev.effective_start_date and eev.effective_end_date
and p_effective_date between iv.effective_start_date and iv.effective_end_date;
select
iv.name,
iv.uom,
iv.display_sequence,
iv.input_value_id,
iv.element_type_id,
eev.screen_entry_value,
eev.element_entry_value_id,
eev.effective_start_date eev_effective_start_date,
eev.effective_end_date eev_effective_end_date,
ee.cost_allocation_keyflex_id,
ee.reason,
ee.effective_start_date,
ee.effective_end_date,
ee.element_entry_id
from
pay_element_entry_values_f eev,
pay_element_entries_f ee,
per_all_assignments_f asg,
pay_input_values_f iv
where
asg.person_id = p_person_id
and asg.assignment_id = ee.assignment_id
and ee.element_entry_id = eev.element_entry_id
and iv.input_value_id = eev.input_value_id
and (ben_ext_person.g_chg_input_value_id is null
or ben_ext_person.g_chg_input_value_id = iv.input_value_id
)
and p_effective_date between asg.effective_start_date and asg.effective_end_date
and p_effective_date between ee.effective_start_date and ee.effective_end_date
and p_effective_date between eev.effective_start_date and eev.effective_end_date
and p_effective_date between iv.effective_start_date and iv.effective_end_date;