APPS.BEN_DM_DOWNLOAD_DK SQL Statements

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

Line: 74

 select name
 from   ben_actl_prem_f apr
 where  actl_prem_id = p_source_id;

Line: 80

  l_rec_inserted_cnt             number := 0;

Line: 89

  l_rec_inserted_cnt := 0;

Line: 144

   select name
     from ben_actn_typ
    where actn_typ_id = p_source_id;

Line: 209

   select name
     from ben_acty_base_rt_f
    where acty_base_rt_id = p_source_id;

Line: 274

   select name
     from ben_benfts_grp
    where benfts_grp_id = p_source_id;

Line: 339

   select name
     from ben_bnfts_bal_f
    where bnfts_bal_id = p_source_id;

Line: 405

   select name
     from ben_bnft_prvdr_pool_f
    where bnft_prvdr_pool_id = p_source_id;

Line: 470

   select name
     from ben_cmbn_plip_f
    where cmbn_plip_id = p_source_id;

Line: 535

   select name
     from ben_cmbn_ptip_f
    where cmbn_ptip_id = p_source_id;

Line: 600

   select name
     from ben_cmbn_ptip_opt_f
    where cmbn_ptip_opt_id = p_source_id;

Line: 665

   select cm_trgr_src_cd||cm_trgr_typ_cd||proc_cd name
     from ben_cm_trgr
    where cm_trgr_id = p_source_id;

Line: 730

   select name
     from ben_cm_typ_f
    where cm_typ_id = p_source_id;

Line: 795

   select name
     from ben_comp_lvl_fctr
    where comp_lvl_fctr_id = p_source_id;

Line: 860

   select name
     from ben_cvg_amt_calc_mthd_f
    where cvg_amt_calc_mthd_id = p_source_id;

Line: 925

   select *
     from ben_enrt_perd
    where enrt_perd_id = p_source_id;

Line: 933

   select *
     from ben_popl_enrt_typ_cycl_f
    where popl_enrt_typ_cycl_id = c_popl_enrt_typ_cycl_id;

Line: 1039

   select ler_id,
          popl_enrt_typ_cycl_id,
          effective_start_date
     from ben_lee_rsn_f
    where lee_rsn_id = p_source_id
   order by effective_start_date asc;

Line: 1050

   select *
     from ben_popl_enrt_typ_cycl_f
    where popl_enrt_typ_cycl_id = c_popl_enrt_typ_cycl_id;

Line: 1157

   select name
     from ben_ler_f
    where ler_id = p_source_id;

Line: 1230

   select *
     from ben_oiplip_f
    where oiplip_id = p_source_id;

Line: 1313

   select *
     from ben_oipl_f
    where oipl_id = p_source_id;

Line: 1409

   select name
     from ben_opt_f
    where opt_id = p_source_id;

Line: 1481

   select name
     from ben_pgm_f
    where pgm_id = p_source_id;

Line: 1553

   select *
     from ben_plip_f
    where plip_id = p_source_id;

Line: 1644

   select name
     from ben_pl_f
    where pl_id = p_source_id;

Line: 1716

   select name
     from ben_pl_typ_f
    where pl_typ_id = p_source_id;

Line: 1788

   select *
     from ben_ptip_f
    where ptip_id = p_source_id;

Line: 1870

   select to_char(END_DATE,'YYYYMMDD:HH24:mi:ss')||'-'||to_char(START_DATE,'DD-MON-YYYY')||'-'||PERD_TYP_CD name
     from ben_yr_perd
    where yr_perd_id = p_source_id;

Line: 1942

   select formula_name
     from ff_formulas_f
    where formula_id = p_source_id;

Line: 2007

   select id_flex_structure_name
     from fnd_id_flex_structures_vl
    where id_flex_num = p_source_id;

Line: 2072

   select user_name
     from fnd_user
    where user_id = p_source_id;

Line: 2137

   select name, business_group_id
     from hr_all_organization_units
    where organization_id = p_source_id;

Line: 2234

   select location_code
     from hr_locations_all
    where location_id = p_source_id;

Line: 2299

   select payroll_name
     from pay_all_payrolls_f
    where payroll_id = p_source_id;

Line: 2364

   select element_name
     from pay_element_types_f
    where element_type_id = p_source_id;

Line: 2437

   select *
     from pay_input_values_f
    where input_value_id = p_source_id;

Line: 2510

   select *
     from pay_element_links_f
    where element_link_id = p_source_id;

Line: 2583

   select user_status||'-'||nvl(legislation_code,'-x')||'-'||decode(business_group_id, null,'N','Y') status
     from per_assignment_status_types
    where assignment_status_type_id = p_source_id;

Line: 2648

   select name
     from per_grades
    where grade_id = p_source_id;

Line: 2713

   select name
     from per_jobs
    where job_id = p_source_id;

Line: 2778

   select name
     from per_pay_bases
    where pay_basis_id = p_source_id;

Line: 2843

   select user_person_type
     from per_person_types
    where person_type_id = p_source_id;

Line: 2908

   select name
     from per_absence_attendance_types
    where absence_attendance_type_id = p_source_id;

Line: 2984

   select *
     from per_abs_attendance_reasons
    where abs_attendance_reason_id = p_source_id;

Line: 3058

   select *
     from hr_soft_coding_keyflex
    where soft_coding_keyflex_id = p_source_id;

Line: 3105

   select max(migration_id)
     into l_migration_id
     from ben_dm_migrations;

Line: 3151

   ,P_INFORMATION213   => l_table_rec.LAST_UPDATE_DATE
   ,P_INFORMATION133   => l_table_rec.LAST_UPDATED_BY
   ,P_INFORMATION134   => l_table_rec.LAST_UPDATE_LOGIN
   ,P_INFORMATION135   => l_table_rec.CREATED_BY
   ,P_INFORMATION214   => l_table_rec.CREATION_DATE);

Line: 3181

   select *
     from pay_people_groups
    where people_group_id = p_source_id;

Line: 3228

   select max(migration_id)
     into l_migration_id
     from ben_dm_migrations;

Line: 3274

   ,P_INFORMATION213   => l_table_rec.LAST_UPDATE_DATE
   ,P_INFORMATION133   => l_table_rec.LAST_UPDATED_BY
   ,P_INFORMATION134   => l_table_rec.LAST_UPDATE_LOGIN
   ,P_INFORMATION135   => l_table_rec.CREATED_BY
   ,P_INFORMATION214   => l_table_rec.CREATION_DATE);