[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 'Y'
from ben_ler_f
where name = l_ler_name
and business_group_id = p_target_business_group_id;
select ler_id,effective_start_date from ben_ler_f
where name = l_le_name
and business_group_id = p_target_business_group_id;
select formula_id
from ff_formulas_f
where formula_name = l_formula_name
and l_effective_date between
effective_start_date and effective_end_date;
select name,per_info_chg_cs_ler_id from BEN_PER_INFO_CHG_CS_LER_F
where source_table = l_source_table
and source_column = l_source_column
and business_group_id = p_target_business_group_id;
SELECT 'X'
FROM ben_ler_per_info_cs_ler_f
WHERE per_info_chg_cs_ler_id = p_per_info_chg_cs_ler_id
AND ler_id = p_ler_id
AND business_group_id = p_target_business_group_id;
select clpse_lf_evt_id
from ben_clpse_lf_evt_f clp
where clp.business_group_id = p_target_business_group_id
and eval_ler_id = l_ler_id
and ler1_id = l_ler_id1
and ler2_id = l_ler_id2
and ler3_id = l_ler_id3;
select nvl(max(seq),0) seqnum
from ben_clpse_lf_evt_f clp
where clp.business_group_id = p_target_business_group_id;
select ler_id,effective_start_date from ben_ler_f
where name = l_le_name
and business_group_id = p_target_business_group_id;
select transaction_category_id
from pqh_transaction_categories
where short_name = 'BEN_PDCPWZ';
select copy_entity_txn_id
from pqh_copy_entity_txns
where transaction_category_id = p_transaction_category_id
and context_business_group_id = 0
and display_name = 'GHR_FEHB_SEED_PROGRAM_DESIGN';
Cursor update_program_status is
select * from ben_pgm_f
where name = 'Federal Employees Health Benefits'
and business_group_id = p_target_business_group_id;
/* This update is introduced to open the lookup type delivererd by Benefits team */
/* which is being used only by GHr customers for now. It would be open for all */
/* customers at a later date, at which point this update can be removed form here */
update FND_LOOKUP_VALUES
set end_date_active = null,
description = null,
last_updated_by = 1
where lookup_code = 'FDPPELD'
and lookup_type = 'BEN_ENRT_CVG_STRT'
and language = 'US' ;
For i in update_program_status Loop
ben_Program_api.update_program(
p_pgm_id => i.pgm_id
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_pgm_stat_cd => 'A'
,p_object_version_number => i.object_version_number
,p_effective_date => i.effective_start_date
,p_datetrack_mode => 'CORRECTION'
);
select 'Y' from ben_pgm_f
where name = 'Federal Employees Health Benefits'
and business_group_id = p_target_business_group_id;
select business_group_id from per_business_groups;
SELECT eef.effective_start_date start_date,
eef.assignment_id,
elt.element_name,
eef.element_entry_id,
eef.object_version_number,
ghr_ss_views_pkg.get_ele_entry_value_ason_date (eef.element_entry_id,
'Enrollment',
eef.effective_start_date) enrollment,
ghr_ss_views_pkg.get_ele_entry_value_ason_date (eef.element_entry_id,
'Health Plan',
eef.effective_start_date) health_plan,
ghr_ss_views_pkg.get_ele_entry_value_ason_date (eef.element_entry_id,
'Pre tax Waiver',
eef.effective_start_date) pt_flag,
ghr_ss_views_pkg.get_ele_entry_value_ason_date (eef.element_entry_id,
'Temps Total Cost',
eef.effective_start_date) Temps_cost,
asg.person_id
FROM pay_element_entries_f eef,
pay_element_types_f elt,
per_all_assignments_f asg
WHERE eef.assignment_id = asg.assignment_id
and elt.element_type_id = eef.element_type_id
AND eef.effective_start_date BETWEEN elt.effective_start_date AND elt.effective_end_date
AND eef.effective_start_date BETWEEN asg.effective_start_date AND asg.effective_end_date
and eef.effective_end_date = hr_api.g_eot
and asg.business_group_id = p_business_group_id
AND upper(pqp_fedhr_uspay_int_utils.return_old_element_name(elt.element_name,
p_business_group_id,
eef.effective_start_date))
IN ('HEALTH BENEFITS'
-- ,'HEALTH BENEFITS PRE TAX'
)
order by eef.assignment_id,element_name;