The following lines contain the word 'select', 'insert', 'update' or 'delete':
select target_id
into l_target_id
from ben_dm_resolve_mappings
where resolve_mapping_id = p_resolve_mapping_id;
select actl_prem_id
from ben_actl_prem_f apr
where business_group_id = c_business_group_id
and name = c_source_key;
select *
from ben_dm_resolve_mappings cm
where table_name = 'BEN_ACTL_PREM_F'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.actl_prem_id);
select actn_typ_id
from ben_actn_typ
where name = c_source_key
and business_group_id = c_business_group_id
;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_ACTN_TYP'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.actn_typ_id);
select acty_base_rt_id
from ben_acty_base_rt_f
where name = c_source_key
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_ACTY_BASE_RT_F'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.acty_base_rt_id);
select benfts_grp_id
from ben_benfts_grp
where name = c_source_key
;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_BENFTS_GRP'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.benfts_grp_id);
select element_Link_id
from pay_element_links_f
where element_type_id = c_source_id
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'PAY_ELEMENT_LINKS_F'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.element_link_id);
select bnfts_bal_id
from ben_bnfts_bal_f
where name = c_source_key
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_BNFTS_BAL_F'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.bnfts_bal_id);
select bnft_prvdr_pool_id
from ben_bnft_prvdr_pool_f
where name = c_source_key
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_BNFT_PRVDR_POOL_F'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.bnft_prvdr_pool_id);
select cmbn_plip_id
from ben_cmbn_plip_f
where name = c_source_key
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_CMBN_PLIP_F'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.cmbn_plip_id);
select cmbn_ptip_id
from ben_cmbn_ptip_f
where name = c_source_key
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_CMBN_PTIP_F'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.cmbn_ptip_id);
select cmbn_ptip_opt_id
from ben_cmbn_ptip_opt_f
where name = c_source_key
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_CMBN_PTIP_OPT_F'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.cmbn_ptip_opt_id);
select cm_trgr_id
from ben_cm_trgr
where cm_trgr_src_cd||cm_trgr_typ_cd||proc_cd = c_source_key
;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_CM_TRGR'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.cm_trgr_id);
select cm_typ_id
from ben_cm_typ_f
where name = c_source_key
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_CM_TYP_F'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.cm_typ_id);
select comp_lvl_fctr_id
from ben_comp_lvl_fctr
where name = c_source_key
and business_group_id = c_business_group_id
;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_COMP_LVL_FCTR'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.comp_lvl_fctr_id);
select cvg_amt_calc_mthd_id
from ben_cvg_amt_calc_mthd_f
where name = c_source_key
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_CVG_AMT_CALC_MTHD_F'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.cvg_amt_calc_mthd_id);
select enrt_perd_id
from ben_enrt_perd
where strt_dt = to_date(c_source_key,'dd-mm-rrrr')
and yr_perd_id = c_target_id1
and popl_enrt_typ_cycl_id = c_target_id2
and business_group_id = c_business_group_id
;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_ENRT_PERD'
and target_id is null;
select *
from ben_popl_enrt_typ_cycl_f
where nvl(pgm_id,-1) = nvl(c_pgm_id,-1)
and nvl(pl_id,-1) = nvl(c_pl_id,-1)
and business_group_id = c_business_group_id
order by decode(enrt_typ_cycl_cd,'O',1,2) asc;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.enrt_perd_id);
select lee_rsn_id
from ben_lee_rsn_f
where effective_start_date = to_date(c_source_key,'dd-mm-rrrr')
and ler_id = c_ler_id
and popl_enrt_typ_cycl_id = c_popl_enrt_typ_cycl_id
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_LEE_RSN_F'
and target_id is null;
select *
from ben_popl_enrt_typ_cycl_f
where nvl(pgm_id,-1) = nvl(c_pgm_id,-1)
and nvl(pl_id,-1) = nvl(c_pl_id,-1)
and business_group_id = c_business_group_id
and enrt_typ_cycl_cd = 'L';
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.lee_rsn_id);
select ler_id
from ben_ler_f
where name = c_source_key
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_LER_F'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.ler_id);
select oiplip_id
from ben_oiplip_f
where oipl_id = c_target_id1
and plip_id = c_target_id2;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_OIPLIP_F'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.oiplip_id);
select oipl_id
from ben_oipl_f
where pl_id = c_target_id1
and opt_id = c_target_id2
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_OIPL_F'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.oipl_id);
select opt_id
from ben_opt_f
where name = c_source_key
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_OPT_F'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.opt_id);
select pgm_id
from ben_pgm_f
where name = c_source_key
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_PGM_F'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.pgm_id);
select plip_id
from ben_plip_f
where pgm_id = c_target_id1
and pl_id = c_target_id2
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_PLIP_F'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.plip_id);
select pl_id
from ben_pl_f
where name = c_source_key
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_PL_F'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.pl_id);
select pl_typ_id
from ben_pl_typ_f
where name = c_source_key
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_PL_TYP_F'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.pl_typ_id);
select ptip_id
from ben_ptip_f
where pgm_id = c_target_id1
and pl_typ_id = c_target_id2
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_PTIP_F'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.ptip_id);
select yr_perd_id
from ben_yr_perd
where to_char(END_DATE,'YYYYMMDD:HH24:mi:ss')||'-'||to_char(START_DATE,'DD-MON-YYYY')||'-'||PERD_TYP_CD = c_source_key
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'BEN_YR_PERD'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.yr_perd_id);
select formula_id
from ff_formulas_f
where formula_name = c_source_key
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'FF_FORMULAS_F'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.formula_id);
select id_flex_num
from fnd_id_flex_structures_vl
where id_flex_structure_name = c_source_key
;
select *
from ben_dm_resolve_mappings
where table_name = 'FND_ID_FLEX_STRUCTURES_VL'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.id_flex_num);
select user_id
from fnd_user
where user_name = c_source_key
;
select *
from ben_dm_resolve_mappings
where table_name = 'FND_USER'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.user_id);
select organization_id
from hr_all_organization_units
where name = c_source_key
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'HR_ALL_ORGANIZATION_UNITS'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.organization_id);
select organization_id
from hr_all_organization_units
where name = c_source_key
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'HR_ORGANIZATION_INFORMATION'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.organization_id);
select location_id
from hr_locations_all
where location_code = c_source_key
;
select *
from ben_dm_resolve_mappings
where table_name = 'HR_LOCATIONS_ALL'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.location_id);
select payroll_id
from pay_all_payrolls_f
where payroll_name = c_source_key
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'PAY_ALL_PAYROLLS_F'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.payroll_id);
select element_type_id
from pay_element_types_f
where element_name = c_source_key
and (business_group_id = c_business_group_id or business_group_id is null)
and (LEGISLATION_CODE = 'US' or LEGISLATION_CODE is null);
select *
from ben_dm_resolve_mappings
where table_name = 'PAY_ELEMENT_TYPES_F'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.element_type_id);
select input_value_id
from pay_input_values_f
where name = c_source_key
and element_type_id = c_target_id1
and (business_group_id = c_business_group_id or business_group_id is null)
and (LEGISLATION_CODE = 'US' or LEGISLATION_CODE is null);
select *
from ben_dm_resolve_mappings
where table_name = 'PAY_INPUT_VALUES_F'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.input_value_id);
select assignment_status_type_id
from per_assignment_status_types
where user_status = c_user_status
and nvl(legislation_code,'-x') = c_leg_code
and nvl(business_group_id,-1) = nvl(c_bg_id,-1) ;
select *
from ben_dm_resolve_mappings
where table_name = 'PER_ASSIGNMENT_STATUS_TYPES'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.assignment_status_type_id);
select grade_id
from per_grades
where name = c_source_key
;
select *
from ben_dm_resolve_mappings
where table_name = 'PER_GRADES'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.grade_id);
select job_id
from per_jobs
where name = c_source_key
;
select *
from ben_dm_resolve_mappings
where table_name = 'PER_JOBS'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.job_id);
select pay_basis_id
from per_pay_bases
where name = c_source_key
;
select *
from ben_dm_resolve_mappings
where table_name = 'PER_PAY_BASES'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.pay_basis_id);
select person_type_id
from per_person_types
where user_person_type = c_source_key
and business_group_id = c_business_group_id ;
select *
from ben_dm_resolve_mappings
where table_name = 'PER_PERSON_TYPES'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.person_type_id);
select absence_attendance_type_id
from per_absence_attendance_types
where name = c_source_key
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'PER_ABSENCE_ATTENDANCE_TYPES'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.absence_attendance_type_id);
select abs_attendance_reason_id
from per_abs_attendance_reasons
where name = c_source_key
and absence_attendance_type_id = c_target_id1
and business_group_id = c_business_group_id;
select *
from ben_dm_resolve_mappings
where table_name = 'PER_ABS_ATTENDANCE_REASONS'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_table_rec.abs_attendance_reason_id);
select *
from ben_dm_entity_results
where entity_result_id = c_entity_result_id;
select *
from ben_dm_resolve_mappings
where table_name = 'HR_SOFT_CODING_KEYFLEX'
and target_id is null;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_target_id);
select *
from ben_dm_entity_results
where entity_result_id = c_entity_result_id;
select *
from ben_dm_resolve_mappings
where table_name = 'PAY_PEOPLE_GROUPS'
and target_id is null;
select people_group_structure
into l_people_group_structure
from per_business_groups
where business_group_id = l_bg_id;
ben_dm_data_util.update_pk_mapping
(p_resolve_mapping_id => x.resolve_mapping_id
,p_target_id => l_target_id);
select *
from ben_dm_resolve_mappings
where target_id is null;