APPS.BEN_DM_UPLOAD_DK SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 19

  select target_id
   into l_target_id
   from  ben_dm_resolve_mappings
   where resolve_mapping_id = p_resolve_mapping_id;

Line: 38

 select actl_prem_id
 from   ben_actl_prem_f apr
 where  business_group_id = c_business_group_id
   and  name = c_source_key;

Line: 44

 select *
   from ben_dm_resolve_mappings cm
  where table_name = 'BEN_ACTL_PREM_F'
    and target_id is null;

Line: 86

        ben_dm_data_util.update_pk_mapping
        (p_resolve_mapping_id  => x.resolve_mapping_id
        ,p_target_id           => l_table_rec.actl_prem_id);

Line: 103

   select actn_typ_id
     from ben_actn_typ
    where name = c_source_key
     and   business_group_id = c_business_group_id
      ;

Line: 110

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_ACTN_TYP'
      and target_id is null;

Line: 156

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.actn_typ_id);

Line: 173

   select acty_base_rt_id
     from ben_acty_base_rt_f
    where name = c_source_key
      and business_group_id = c_business_group_id;

Line: 179

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_ACTY_BASE_RT_F'
      and target_id is null;

Line: 219

     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);

Line: 235

   select benfts_grp_id
     from ben_benfts_grp
    where name = c_source_key
      ;

Line: 241

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_BENFTS_GRP'
      and target_id is null;

Line: 281

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.benfts_grp_id);

Line: 298

   select element_Link_id
     from pay_element_links_f
    where element_type_id = c_source_id
      and business_group_id = c_business_group_id;

Line: 304

   select *
     from ben_dm_resolve_mappings
    where table_name = 'PAY_ELEMENT_LINKS_F'
      and target_id is null;

Line: 353

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.element_link_id);

Line: 370

   select bnfts_bal_id
     from ben_bnfts_bal_f
    where name = c_source_key
      and business_group_id = c_business_group_id;

Line: 376

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_BNFTS_BAL_F'
      and target_id is null;

Line: 416

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.bnfts_bal_id);

Line: 433

   select bnft_prvdr_pool_id
     from ben_bnft_prvdr_pool_f
    where name = c_source_key
      and business_group_id = c_business_group_id;

Line: 439

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_BNFT_PRVDR_POOL_F'
      and target_id is null;

Line: 479

     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);

Line: 496

   select cmbn_plip_id
     from ben_cmbn_plip_f
    where name = c_source_key
      and business_group_id = c_business_group_id;

Line: 502

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_CMBN_PLIP_F'
      and target_id is null;

Line: 542

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.cmbn_plip_id);

Line: 559

   select cmbn_ptip_id
     from ben_cmbn_ptip_f
    where name = c_source_key
      and business_group_id = c_business_group_id;

Line: 565

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_CMBN_PTIP_F'
      and target_id is null;

Line: 605

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.cmbn_ptip_id);

Line: 622

   select cmbn_ptip_opt_id
     from ben_cmbn_ptip_opt_f
    where name = c_source_key
      and business_group_id = c_business_group_id;

Line: 628

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_CMBN_PTIP_OPT_F'
      and target_id is null;

Line: 668

     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);

Line: 685

   select cm_trgr_id
     from ben_cm_trgr
    where cm_trgr_src_cd||cm_trgr_typ_cd||proc_cd = c_source_key
      ;

Line: 691

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_CM_TRGR'
      and target_id is null;

Line: 731

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.cm_trgr_id);

Line: 748

   select cm_typ_id
     from ben_cm_typ_f
    where name = c_source_key
      and business_group_id = c_business_group_id;

Line: 754

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_CM_TYP_F'
      and target_id is null;

Line: 794

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.cm_typ_id);

Line: 811

   select comp_lvl_fctr_id
     from ben_comp_lvl_fctr
    where name = c_source_key
      and business_group_id = c_business_group_id
      ;

Line: 818

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_COMP_LVL_FCTR'
      and target_id is null;

Line: 858

     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);

Line: 875

   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;

Line: 881

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_CVG_AMT_CALC_MTHD_F'
      and target_id is null;

Line: 921

     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);

Line: 939

   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
  ;

Line: 948

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_ENRT_PERD'
      and target_id is null;

Line: 954

   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;

Line: 1023

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.enrt_perd_id);

Line: 1042

   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;

Line: 1050

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_LEE_RSN_F'
      and target_id is null;

Line: 1056

   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';

Line: 1126

            ben_dm_data_util.update_pk_mapping
            (p_resolve_mapping_id  => x.resolve_mapping_id
            ,p_target_id           => l_table_rec.lee_rsn_id);

Line: 1143

   select ler_id
     from ben_ler_f
    where name = c_source_key
      and business_group_id = c_business_group_id;

Line: 1149

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_LER_F'
      and target_id is null;

Line: 1189

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.ler_id);

Line: 1207

   select oiplip_id
     from ben_oiplip_f
    where oipl_id = c_target_id1
      and plip_id = c_target_id2;

Line: 1213

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_OIPLIP_F'
      and target_id is null;

Line: 1260

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.oiplip_id);

Line: 1278

   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;

Line: 1285

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_OIPL_F'
      and target_id is null;

Line: 1333

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.oipl_id);

Line: 1350

   select opt_id
     from ben_opt_f
    where name = c_source_key
      and business_group_id = c_business_group_id;

Line: 1356

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_OPT_F'
      and target_id is null;

Line: 1396

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.opt_id);

Line: 1413

   select pgm_id
     from ben_pgm_f
    where name = c_source_key
      and business_group_id = c_business_group_id;

Line: 1419

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_PGM_F'
      and target_id is null;

Line: 1459

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.pgm_id);

Line: 1477

   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;

Line: 1484

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_PLIP_F'
      and target_id is null;

Line: 1532

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.plip_id);

Line: 1549

   select pl_id
     from ben_pl_f
    where name = c_source_key
      and business_group_id = c_business_group_id;

Line: 1555

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_PL_F'
      and target_id is null;

Line: 1595

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.pl_id);

Line: 1612

   select pl_typ_id
     from ben_pl_typ_f
    where name = c_source_key
      and business_group_id = c_business_group_id;

Line: 1618

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_PL_TYP_F'
      and target_id is null;

Line: 1658

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.pl_typ_id);

Line: 1676

   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;

Line: 1683

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_PTIP_F'
      and target_id is null;

Line: 1731

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.ptip_id);

Line: 1748

   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;

Line: 1754

   select *
     from ben_dm_resolve_mappings
    where table_name = 'BEN_YR_PERD'
      and target_id is null;

Line: 1794

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.yr_perd_id);

Line: 1811

   select formula_id
     from ff_formulas_f
    where formula_name = c_source_key
      and business_group_id = c_business_group_id;

Line: 1817

   select *
     from ben_dm_resolve_mappings
    where table_name = 'FF_FORMULAS_F'
      and target_id is null;

Line: 1857

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.formula_id);

Line: 1874

   select id_flex_num
     from fnd_id_flex_structures_vl
    where id_flex_structure_name = c_source_key
      ;

Line: 1880

   select *
     from ben_dm_resolve_mappings
    where table_name = 'FND_ID_FLEX_STRUCTURES_VL'
      and target_id is null;

Line: 1920

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.id_flex_num);

Line: 1937

   select user_id
     from fnd_user
    where user_name = c_source_key
      ;

Line: 1943

   select *
     from ben_dm_resolve_mappings
    where table_name = 'FND_USER'
      and target_id is null;

Line: 1983

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.user_id);

Line: 2000

   select organization_id
     from hr_all_organization_units
    where name = c_source_key
      and business_group_id = c_business_group_id;

Line: 2006

   select *
     from ben_dm_resolve_mappings
    where table_name = 'HR_ALL_ORGANIZATION_UNITS'
      and target_id is null;

Line: 2046

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.organization_id);

Line: 2066

   select organization_id
     from hr_all_organization_units
    where name = c_source_key
      and business_group_id = c_business_group_id;

Line: 2072

   select *
     from ben_dm_resolve_mappings
    where table_name = 'HR_ORGANIZATION_INFORMATION'
      and target_id is null;

Line: 2113

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.organization_id);

Line: 2133

   select location_id
     from hr_locations_all
    where location_code = c_source_key
      ;

Line: 2139

   select *
     from ben_dm_resolve_mappings
    where table_name = 'HR_LOCATIONS_ALL'
      and target_id is null;

Line: 2179

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.location_id);

Line: 2196

   select payroll_id
     from pay_all_payrolls_f
    where payroll_name = c_source_key
      and business_group_id = c_business_group_id;

Line: 2202

   select *
     from ben_dm_resolve_mappings
    where table_name = 'PAY_ALL_PAYROLLS_F'
      and target_id is null;

Line: 2242

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.payroll_id);

Line: 2259

   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);

Line: 2266

   select *
     from ben_dm_resolve_mappings
    where table_name = 'PAY_ELEMENT_TYPES_F'
      and target_id is null;

Line: 2306

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.element_type_id);

Line: 2324

   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);

Line: 2332

   select *
     from ben_dm_resolve_mappings
    where table_name = 'PAY_INPUT_VALUES_F'
      and target_id is null;

Line: 2378

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.input_value_id);

Line: 2397

   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) ;

Line: 2404

   select *
     from ben_dm_resolve_mappings
    where table_name = 'PER_ASSIGNMENT_STATUS_TYPES'
      and target_id is null;

Line: 2465

     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);

Line: 2482

   select grade_id
     from per_grades
    where name = c_source_key
      ;

Line: 2488

   select *
     from ben_dm_resolve_mappings
    where table_name = 'PER_GRADES'
      and target_id is null;

Line: 2528

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.grade_id);

Line: 2545

   select job_id
     from per_jobs
    where name = c_source_key
      ;

Line: 2551

   select *
     from ben_dm_resolve_mappings
    where table_name = 'PER_JOBS'
      and target_id is null;

Line: 2591

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.job_id);

Line: 2608

   select pay_basis_id
     from per_pay_bases
    where name = c_source_key
      ;

Line: 2614

   select *
     from ben_dm_resolve_mappings
    where table_name = 'PER_PAY_BASES'
      and target_id is null;

Line: 2654

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.pay_basis_id);

Line: 2671

   select person_type_id
     from per_person_types
    where user_person_type = c_source_key
      and business_group_id = c_business_group_id ;

Line: 2677

   select *
     from ben_dm_resolve_mappings
    where table_name = 'PER_PERSON_TYPES'
      and target_id is null;

Line: 2717

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_table_rec.person_type_id);

Line: 2734

   select absence_attendance_type_id
     from per_absence_attendance_types
    where name = c_source_key
      and business_group_id = c_business_group_id;

Line: 2740

   select *
     from ben_dm_resolve_mappings
    where table_name = 'PER_ABSENCE_ATTENDANCE_TYPES'
      and target_id is null;

Line: 2782

     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);

Line: 2800

   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;

Line: 2807

   select *
     from ben_dm_resolve_mappings
    where table_name = 'PER_ABS_ATTENDANCE_REASONS'
      and target_id is null;

Line: 2853

     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);

Line: 2870

   select *
     from ben_dm_entity_results
    where entity_result_id = c_entity_result_id;

Line: 2875

   select *
     from ben_dm_resolve_mappings
    where table_name = 'HR_SOFT_CODING_KEYFLEX'
      and target_id is null;

Line: 2958

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_target_id);

Line: 2975

   select *
     from ben_dm_entity_results
    where entity_result_id = c_entity_result_id;

Line: 2980

   select *
     from ben_dm_resolve_mappings
    where table_name = 'PAY_PEOPLE_GROUPS'
      and target_id is null;

Line: 3027

    select people_group_structure
      into l_people_group_structure
      from per_business_groups
     where business_group_id = l_bg_id;

Line: 3110

     ben_dm_data_util.update_pk_mapping
     (p_resolve_mapping_id  => x.resolve_mapping_id
     ,p_target_id           => l_target_id);

Line: 3124

   select *
     from ben_dm_resolve_mappings
    where target_id is null;