APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE SQL Statements

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

Line: 41

   select copy_entity_result_id mirror_src_entity_result_id
   from ben_copy_entity_results cpe
--    ,pqh_table_route trt
   where cpe.information1= c_parent_pk_id
   and   cpe.result_type_cd = l_cv_result_type_cd
   and   cpe.copy_entity_txn_id = c_copy_entity_txn_id
--   and   cpe.table_route_id = trt.table_route_id
   -- and   trt.from_clause = 'OAB'
   --and   trt.where_clause = upper(c_parent_table_name) ;

Line: 72

   select  distinct pgm_id
   from BEN_PGM_F
   where  PGM_ID = c_PGM_ID ;

Line: 78

   select  pgm.*
   from BEN_PGM_F pgm
   where  pgm.pgm_id = c_pgm_id
   --and pgm.business_group_id = p_business_group_id
   and not exists (
     select /* */ null
     from ben_copy_entity_results cpe
--ggnanagu          ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--       and trt.table_route_id = cpe.table_route_id
       and ( c_mirror_src_entity_result_id is null or
             mirror_src_entity_result_id = c_mirror_src_entity_result_id )
       and cpe.table_alias  = c_table_alias
       and information1 = c_pgm_id
       and information2 = pgm.effective_start_date
       and information3 = pgm.effective_end_date
     );

Line: 103

   select distinct ler_chg_dpnt_cvg_id
   from BEN_LER_CHG_DPNT_CVG_F
   where  PGM_ID = c_PGM_ID ;

Line: 109

   select  ldc.*
   from BEN_LER_CHG_DPNT_CVG_F ldc
   where  ldc.ler_chg_dpnt_cvg_id = c_ler_chg_dpnt_cvg_id
   --and ldc.business_group_id = p_business_group_id
   and not exists (
     select /* */ null
     from ben_copy_entity_results  cpe
--          ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--       and trt.table_route_id = cpe.table_route_id
       and mirror_src_entity_result_id = c_mirror_src_entity_result_id
       and cpe.table_alias  = c_table_alias
       and information1 = c_ler_chg_dpnt_cvg_id
       and information2 = ldc.effective_start_date
       and information3 = ldc.effective_end_date
    );

Line: 129

   select distinct cpe.information257 ler_id
     from ben_copy_entity_results cpe
--          ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--     and trt.table_route_id = cpe.table_route_id
     and mirror_src_entity_result_id = c_mirror_src_entity_result_id
     and cpe.table_alias  = c_table_alias
     and information1 = c_ler_chg_dpnt_cvg_id
    ;

Line: 147

   select distinct ler_chg_pgm_enrt_id
   from BEN_LER_CHG_PGM_ENRT_F
   where  PGM_ID = c_PGM_ID ;

Line: 153

   select  lge.*
   from BEN_LER_CHG_PGM_ENRT_F lge
   where  lge.ler_chg_pgm_enrt_id = c_ler_chg_pgm_enrt_id
   --and lge.business_group_id = p_business_group_id
   and not exists (
     select /* */ null
     from ben_copy_entity_results cpe
--          ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--       and trt.table_route_id = cpe.table_route_id
       and mirror_src_entity_result_id = c_mirror_src_entity_result_id
       and cpe.table_alias  = c_table_alias
       and information1 = c_ler_chg_pgm_enrt_id
       and information2 = lge.effective_start_date
       and information3 = lge.effective_end_date
    );

Line: 173

   select distinct cpe.information257 ler_id
     from ben_copy_entity_results cpe
--          ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--     and trt.table_route_id = cpe.table_route_id
     and mirror_src_entity_result_id = c_mirror_src_entity_result_id
     -- and trt.where_clause = 'BEN_LER_CHG_PGM_ENRT_F'
     and cpe.table_alias = c_table_alias
     and information1 = c_ler_chg_pgm_enrt_id
     -- and information4 = p_business_group_id
    ;

Line: 192

   select  elig_to_prte_rsn_id
   from BEN_ELIG_TO_PRTE_RSN_F
   where  PGM_ID = c_PGM_ID ;

Line: 198

   select  peo.*
   from BEN_ELIG_TO_PRTE_RSN_F peo
   where  peo.elig_to_prte_rsn_id = c_elig_to_prte_rsn_id
   --and peo.business_group_id = p_business_group_id
   and not exists (
     select /* */ null
     from ben_copy_entity_results cpe
     --     ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--       and trt.table_route_id = cpe.table_route_id
       and mirror_src_entity_result_id = c_mirror_src_entity_result_id
       and cpe.table_alias  = c_table_alias
       and information1 = c_elig_to_prte_rsn_id
       and information2 = peo.effective_start_date
       and information3 = peo.effective_end_date
    );

Line: 223

   select  pgm_dpnt_cvg_ctfn_id
   from BEN_PGM_DPNT_CVG_CTFN_F
   where  PGM_ID = c_PGM_ID ;

Line: 229

   select  pgc.*
   from BEN_PGM_DPNT_CVG_CTFN_F pgc
   where  pgc.pgm_dpnt_cvg_ctfn_id = c_pgm_dpnt_cvg_ctfn_id
   and not exists (
     select /* */ null
     from ben_copy_entity_results cpe
     --     ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--       and trt.table_route_id = cpe.table_route_id
       and mirror_src_entity_result_id = c_mirror_src_entity_result_id
       and cpe.table_alias  = c_table_alias
       and information1 = c_pgm_dpnt_cvg_ctfn_id
       and information2 = pgc.effective_start_date
       and information3 = pgc.effective_end_date
    );

Line: 253

   select  ler_chg_dpnt_cvg_ctfn_id
   from BEN_LER_CHG_DPNT_CVG_CTFN_F
   where  LER_CHG_DPNT_CVG_ID = c_LER_CHG_DPNT_CVG_ID ;

Line: 259

   select  lcc.*
   from BEN_LER_CHG_DPNT_CVG_CTFN_F lcc
   where  lcc.ler_chg_dpnt_cvg_ctfn_id = c_ler_chg_dpnt_cvg_ctfn_id
   and not exists (
     select /* */ null
     from ben_copy_entity_results cpe
     --     ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--       and trt.table_route_id = cpe.table_route_id
       and mirror_src_entity_result_id = c_mirror_src_entity_result_id
       and cpe.table_alias  = c_table_alias
       and information1 = c_ler_chg_dpnt_cvg_ctfn_id
       and information2 = lcc.effective_start_date
       and information3 = lcc.effective_end_date
    );

Line: 283

   select distinct plip_id
   from BEN_PLIP_F
   where  PGM_ID = c_PGM_ID ;

Line: 289

   select  cpp.*
   from BEN_PLIP_F cpp
   where  cpp.plip_id = c_plip_id
   and not exists (
     select /* */ null
     from ben_copy_entity_results cpe
     --     ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--       and trt.table_route_id = cpe.table_route_id
       and cpe.table_alias  = c_table_alias
       and information1 = c_plip_id
       and information2 = cpp.effective_start_date
       and information3 = cpp.effective_end_date
    );

Line: 312

   select  distinct ptip_id
   from BEN_PTIP_F
   where  PGM_ID = c_PGM_ID ;

Line: 318

   select  ctp.*
   from BEN_PTIP_F ctp
   where  ctp.ptip_id = c_ptip_id
   and not exists (
     select /* */ null
     from ben_copy_entity_results cpe
     --     ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--       and trt.table_route_id = cpe.table_route_id
       and mirror_src_entity_result_id = c_mirror_src_entity_result_id
       and cpe.table_alias  = c_table_alias
       and information1 = c_ptip_id
       and information2 = ctp.effective_start_date
       and information3 = ctp.effective_end_date
    );

Line: 342

   select  elig_to_prte_rsn_id
   from BEN_ELIG_TO_PRTE_RSN_F
   where  PTIP_ID = c_PTIP_ID ;

Line: 348

   select  peo.*
   from BEN_ELIG_TO_PRTE_RSN_F peo
   where  peo.elig_to_prte_rsn_id = c_elig_to_prte_rsn_id
   and not exists (
     select /* */ null
     from ben_copy_entity_results cpe
     --     ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--     and trt.table_route_id = cpe.table_route_id
     and mirror_src_entity_result_id = c_mirror_src_entity_result_id
     and cpe.table_alias  = c_table_alias
     and information1 = c_elig_to_prte_rsn_id
       and information2 = peo.effective_start_date
       and information3 = peo.effective_end_date
    );

Line: 372

   select distinct ler_chg_dpnt_cvg_id
   from BEN_LER_CHG_DPNT_CVG_F
   where  PTIP_ID = c_PTIP_ID ;

Line: 378

   select  ldc.*
   from BEN_LER_CHG_DPNT_CVG_F ldc
   where  ldc.ler_chg_dpnt_cvg_id = c_ler_chg_dpnt_cvg_id
   and not exists (
     select /* */ null
     from ben_copy_entity_results cpe
     --     ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--     and trt.table_route_id = cpe.table_route_id
     and mirror_src_entity_result_id = c_mirror_src_entity_result_id
     and cpe.table_alias  = c_table_alias
     and information1 = c_ler_chg_dpnt_cvg_id
       and information2 = ldc.effective_start_date
       and information3 = ldc.effective_end_date
    );

Line: 396

   select distinct cpe.information257 ler_id
     from ben_copy_entity_results cpe
     --     ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--     and trt.table_route_id = cpe.table_route_id
     and mirror_src_entity_result_id = c_mirror_src_entity_result_id
     and cpe.table_alias  = c_table_alias
     and information1 = c_ler_chg_dpnt_cvg_id
    ;

Line: 414

   select distinct ler_chg_ptip_enrt_id
   from BEN_LER_CHG_PTIP_ENRT_F
   where  PTIP_ID = c_PTIP_ID ;

Line: 420

   select  lct.*
   from BEN_LER_CHG_PTIP_ENRT_F lct
   where  lct.ler_chg_ptip_enrt_id = c_ler_chg_ptip_enrt_id
   and not exists (
     select /* */ null
     from ben_copy_entity_results cpe
     --     ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--     and trt.table_route_id = cpe.table_route_id
     and mirror_src_entity_result_id = c_mirror_src_entity_result_id
     and cpe.table_alias  = c_table_alias
     and information1 = c_ler_chg_ptip_enrt_id
       and information2 = lct.effective_start_date
       and information3 = lct.effective_end_date
    );

Line: 439

   select distinct cpe.information257 ler_id
     from ben_copy_entity_results cpe
--          ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--     and trt.table_route_id = cpe.table_route_id
     and mirror_src_entity_result_id = c_mirror_src_entity_result_id
     and cpe.table_alias  = c_table_alias
     and information1 = c_ler_chg_ptip_enrt_id
    ;

Line: 456

   select  ptip_dpnt_cvg_ctfn_id
   from BEN_PTIP_DPNT_CVG_CTFN_F
   where  PTIP_ID = c_PTIP_ID ;

Line: 462

   select  pyd.*
   from BEN_PTIP_DPNT_CVG_CTFN_F pyd
   where  pyd.ptip_dpnt_cvg_ctfn_id = c_ptip_dpnt_cvg_ctfn_id
   and not exists (
     select /* */ null
     from ben_copy_entity_results cpe
     --     ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--     and trt.table_route_id = cpe.table_route_id
     and mirror_src_entity_result_id = c_mirror_src_entity_result_id
     and cpe.table_alias  = c_table_alias
     and information1 = c_ptip_dpnt_cvg_ctfn_id
       and information2 = pyd.effective_start_date
       and information3 = pyd.effective_end_date
    );

Line: 486

   select  wv_prtn_rsn_ptip_id
   from BEN_WV_PRTN_RSN_PTIP_F
   where  PTIP_ID = c_PTIP_ID ;

Line: 492

   select  wpt.*
   from BEN_WV_PRTN_RSN_PTIP_F wpt
   where  wpt.wv_prtn_rsn_ptip_id = c_wv_prtn_rsn_ptip_id
   and not exists (
     select /* */ null
     from ben_copy_entity_results cpe
     --     ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--     and trt.table_route_id = cpe.table_route_id
     and mirror_src_entity_result_id = c_mirror_src_entity_result_id
     and cpe.table_alias  = c_table_alias
     and information1 = c_wv_prtn_rsn_ptip_id
       and information2 = wpt.effective_start_date
       and information3 = wpt.effective_end_date
    );

Line: 516

   select  wv_prtn_rsn_ctfn_ptip_id
   from BEN_WV_PRTN_RSN_CTFN_PTIP_F
   where  WV_PRTN_RSN_PTIP_ID = c_WV_PRTN_RSN_PTIP_ID ;

Line: 522

   select  wct.*
   from BEN_WV_PRTN_RSN_CTFN_PTIP_F wct
   where  wct.wv_prtn_rsn_ctfn_ptip_id = c_wv_prtn_rsn_ctfn_ptip_id
   and not exists (
     select /* */ null
     from ben_copy_entity_results cpe
     --     ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--     and trt.table_route_id = cpe.table_route_id
     and mirror_src_entity_result_id = c_mirror_src_entity_result_id
     and cpe.table_alias  = c_table_alias
     and information1 = c_wv_prtn_rsn_ctfn_ptip_id
       and information2 = wct.effective_start_date
       and information3 = wct.effective_end_date
    );

Line: 546

   select  ler_chg_dpnt_cvg_ctfn_id
   from BEN_LER_CHG_DPNT_CVG_CTFN_F
   where  LER_CHG_DPNT_CVG_ID = c_LER_CHG_DPNT_CVG_ID ;

Line: 552

   select  lcc.*
   from BEN_LER_CHG_DPNT_CVG_CTFN_F lcc
   where  lcc.ler_chg_dpnt_cvg_ctfn_id = c_ler_chg_dpnt_cvg_ctfn_id
   and not exists (
     select /* */ null
     from ben_copy_entity_results cpe
          -- ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--     and trt.table_route_id = cpe.table_route_id
     and mirror_src_entity_result_id = c_mirror_src_entity_result_id
     and cpe.table_alias  = c_table_alias
     and information1 = c_ler_chg_dpnt_cvg_ctfn_id
       and information2 = lcc.effective_start_date
       and information3 = lcc.effective_end_date
    );

Line: 577

   select  elig_to_prte_rsn_id
   from BEN_ELIG_TO_PRTE_RSN_F
   where  PLIP_ID = c_PLIP_ID ;

Line: 583

   select  peo.*
   from BEN_ELIG_TO_PRTE_RSN_F peo
   where  peo.elig_to_prte_rsn_id = c_elig_to_prte_rsn_id
   and not exists (
     select /* */ null
     from ben_copy_entity_results cpe
          -- ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--     and trt.table_route_id = cpe.table_route_id
     and mirror_src_entity_result_id = c_mirror_src_entity_result_id
     and cpe.table_alias  = c_table_alias
     and information1 = c_elig_to_prte_rsn_id
       and information2 = peo.effective_start_date
       and information3 = peo.effective_end_date
   );

Line: 607

   select  ler_bnft_rstrn_id
   from BEN_LER_BNFT_RSTRN_F
   where  PLIP_ID = c_PLIP_ID ;

Line: 613

   select  lbr.*
   from BEN_LER_BNFT_RSTRN_F lbr
   where  lbr.ler_bnft_rstrn_id = c_ler_bnft_rstrn_id
   and not exists (
     select /* */ null
     from ben_copy_entity_results cpe
          -- ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--     and trt.table_route_id = cpe.table_route_id
     and mirror_src_entity_result_id = c_mirror_src_entity_result_id
     and cpe.table_alias  = c_table_alias
     and information1 = c_ler_bnft_rstrn_id
     and information2 = lbr.effective_start_date
     and information3 = lbr.effective_end_date
   );

Line: 637

   select distinct ler_chg_plip_enrt_id
   from BEN_LER_CHG_PLIP_ENRT_F
   where  PLIP_ID = c_PLIP_ID ;

Line: 643

   select  lpr.*
   from BEN_LER_CHG_PLIP_ENRT_F lpr
   where  lpr.ler_chg_plip_enrt_id = c_ler_chg_plip_enrt_id
     and not exists (
         select /* */ null
         from ben_copy_entity_results cpe
              -- ,pqh_table_route trt
         where copy_entity_txn_id = p_copy_entity_txn_id
     --    and trt.table_route_id = cpe.table_route_id
         and mirror_src_entity_result_id = c_mirror_src_entity_result_id
         and cpe.table_alias  = c_table_alias
         and information1 = c_ler_chg_plip_enrt_id
           and information2 = lpr.effective_start_date
           and information3 = lpr.effective_end_date
        );

Line: 663

   select distinct cpe.information257 ler_id
     from ben_copy_entity_results cpe
          -- ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--     and trt.table_route_id = cpe.table_route_id
     and mirror_src_entity_result_id = c_mirror_src_entity_result_id
     and cpe.table_alias  = c_table_alias
     and information1 = c_ler_chg_plip_enrt_id
    ;

Line: 679

   select distinct cp.cmbn_plip_id
   from  ben_cmbn_plip_f cp
   where cp.pgm_id = c_pgm_id;

Line: 686

   select  cpl.*
   from BEN_CMBN_PLIP_F cpl
   where  cpl.cmbn_plip_id = c_cmbn_plip_id
   and not exists (
     select /* */ null
     from ben_copy_entity_results cpe
          -- ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--     and trt.table_route_id = cpe.table_route_id
     and mirror_src_entity_result_id = c_mirror_src_entity_result_id
     and cpe.table_alias  = c_table_alias
     and information1 = c_cmbn_plip_id
     and information2 = cpl.effective_start_date
     and information3 = cpl.effective_end_date
    );

Line: 710

   select distinct cp.cmbn_ptip_id
   from ben_cmbn_ptip_f cp
   where cp.pgm_id = c_pgm_id;

Line: 717

   select  cbp.*
   from BEN_CMBN_PTIP_F cbp
   where  cbp.cmbn_ptip_id = c_cmbn_ptip_id
   and not exists (
     select /* */ null
     from ben_copy_entity_results cpe
          -- ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--     and trt.table_route_id = cpe.table_route_id
     and mirror_src_entity_result_id = c_mirror_src_entity_result_id
     and cpe.table_alias  = c_table_alias
     and information1 = c_cmbn_ptip_id
     and information2 = cbp.effective_start_date
     and information3 = cbp.effective_end_date
    );

Line: 741

   select distinct cp.cmbn_ptip_opt_id
   from ben_cmbn_ptip_opt_f cp
   where cp.pgm_id = c_pgm_id;

Line: 747

   select  cpt.*
   from BEN_CMBN_PTIP_OPT_F cpt
   where  cpt.cmbn_ptip_opt_id = c_cmbn_ptip_opt_id
   and not exists (
     select /* */ null
     from ben_copy_entity_results cpe
          -- ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--     and trt.table_route_id = cpe.table_route_id
     and mirror_src_entity_result_id = c_mirror_src_entity_result_id
     and cpe.table_alias  = c_table_alias
     and information1 = c_cmbn_ptip_opt_id
     and information2 = cpt.effective_start_date
     and information3 = cpt.effective_end_date
    );

Line: 771

   select oiplip.oiplip_id,cpe_oipl.copy_entity_result_id
   from ben_oiplip_f oiplip,
        ben_plip_f plip,
        ben_copy_entity_results cpe_oipl,
        ben_copy_entity_results cpe_pl,
        ben_copy_entity_results cpe_plip
        -- ,pqh_table_route trt
   where plip.plip_id = oiplip.plip_id
   and plip.pgm_id = c_pgm_id
   and oiplip.oipl_id = cpe_oipl.information1
--   and cpe_oipl.table_route_id = trt.table_route_id
   and cpe_oipl.table_alias  = c_table_alias
   and cpe_oipl.copy_entity_txn_id = p_copy_entity_txn_id
   and cpe_oipl.mirror_src_entity_result_id = cpe_pl.copy_entity_result_id
   and cpe_oipl.copy_entity_txn_id = cpe_pl.copy_entity_txn_id
   and cpe_pl.mirror_src_entity_result_id = cpe_plip.copy_entity_result_id
   and cpe_pl.copy_entity_txn_id = cpe_plip.copy_entity_txn_id
   and cpe_plip.information1 = oiplip.plip_id;

Line: 793

   select  opp.*
   from BEN_OIPLIP_F opp
   where  opp.oiplip_id = c_oiplip_id
   and not exists (
     select /* */ null
     from ben_copy_entity_results cpe
          -- ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--     and trt.table_route_id = cpe.table_route_id
     and mirror_src_entity_result_id = c_mirror_src_entity_result_id
     and cpe.table_alias  = c_table_alias
     and information1 = c_oiplip_id
       and information2 = opp.effective_start_date
       and information3 = opp.effective_end_date
    );

Line: 817

   select optip.optip_id,cpe.copy_entity_result_id
   from ben_optip_f optip,
        ben_ptip_f ptip,
        ben_copy_entity_results cpe
        -- ,pqh_table_route trt
   where ptip.ptip_id = optip.ptip_id
   and ptip.pgm_id = c_pgm_id
   and optip.opt_id = cpe.information1
--   and cpe.table_route_id = trt.table_route_id
   and cpe.table_alias  = c_table_alias
   and cpe.copy_entity_txn_id = p_copy_entity_txn_id ;

Line: 831

   select  otp.*
   from BEN_OPTIP_F otp
   where  otp.optip_id = c_optip_id
   and not exists (
     select /* */ null
     from ben_copy_entity_results cpe
          -- ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
  --   and trt.table_route_id = cpe.table_route_id
     and mirror_src_entity_result_id = c_mirror_src_entity_result_id
     and cpe.table_alias  = c_table_alias
     and information1 = c_optip_id
       and information2 = otp.effective_start_date
       and information3 = otp.effective_end_date
    );

Line: 855

   select  distinct pl_typ_id
   from BEN_PTIP_F
   where  PTIP_ID = c_PTIP_ID ;

Line: 866

   select hl.meaning
   from   hr_lookups hl
   where  hl.lookup_code = c_lookup_code
   and    hl.lookup_type = c_lookup_type;

Line: 875

   select null
   from ben_copy_entity_results cpe
        -- ,pqh_table_route trt
   where copy_entity_txn_id = p_copy_entity_txn_id
--   and trt.table_route_id = cpe.table_route_id
   and cpe.table_alias = c_table_alias
   and information1 = c_pk_id;

Line: 1054

            p_information16     => l_pgm_rec.update_salary_cd,
            p_information185     => l_pgm_rec.url_ref_name,
            p_information17     => l_pgm_rec.use_multi_pay_rates_flag,
            p_information18     => l_pgm_rec.use_prog_points_flag,
            p_information19     => l_pgm_rec.use_scores_cd,
            p_information27     => l_pgm_rec.uses_all_asmts_for_rts_flag,
            p_information54     => l_pgm_rec.vrfy_fmly_mmbr_cd,
            p_information274     => l_pgm_rec.vrfy_fmly_mmbr_rl,
            -- GSP
            p_information69     => l_pgm_rec.use_variable_rates_flag,
            p_information70     => l_pgm_rec.salary_calc_mthd_cd,
            p_information72     => l_pgm_rec.gsp_allow_override_flag,
            p_information293    => l_pgm_rec.salary_calc_mthd_rl,

            p_INFORMATION196    => l_pgm_rec.SUSP_IF_DPNT_SSN_NT_PRV_CD,
            p_INFORMATION190    => l_pgm_rec.SUSP_IF_DPNT_DOB_NT_PRV_CD,
            p_INFORMATION191    => l_pgm_rec.SUSP_IF_DPNT_ADR_NT_PRV_CD,
            p_INFORMATION192    => l_pgm_rec.SUSP_IF_CTFN_NOT_DPNT_FLAG,
            p_INFORMATION193    => l_pgm_rec.DPNT_CTFN_DETERMINE_CD,
            p_information265    => l_pgm_rec.object_version_number,
           --
        p_object_version_number          => l_object_version_number,
        p_effective_date                 => p_effective_date       );

Line: 5811

   select copy_entity_result_id mirror_src_entity_result_id
   from ben_copy_entity_results cpe
    -- ,pqh_table_route trt
   where cpe.information1= c_parent_pk_id
   and   cpe.result_type_cd = l_cv_result_type_cd
   and   cpe.copy_entity_txn_id = c_copy_entity_txn_id
--   and   cpe.table_route_id = trt.table_route_id
   and   cpe.table_alias = c_parent_table_alias ;

Line: 5826

   select  fff.*,fff.formula_text ff_text,ft.formula_type_name formula_type_name
   from FF_FORMULAS_F fff,FF_FORMULA_TYPES ft
   where  fff.formula_id = c_formula_id
   and fff.formula_type_id = ft.formula_type_id
   and ( fff.business_group_id = p_business_group_id or fff.business_group_id is null )
   and not exists (
     select /* */ null
     from ben_copy_entity_results cpe
          -- ,pqh_table_route trt
     where copy_entity_txn_id = p_copy_entity_txn_id
--     and trt.table_route_id = cpe.table_route_id
     and mirror_src_entity_result_id = c_mirror_src_entity_result_id
     and cpe.table_alias  = c_table_alias
     and information1 = c_FORMULA_ID
       and information2 = fff.effective_start_date
       and information3 = fff.effective_end_date
    );

Line: 5851

  select null
  from ben_copy_entity_results cpe
       -- ,pqh_table_route trt
  where copy_entity_txn_id = p_copy_entity_txn_id
--  and trt.table_route_id = cpe.table_route_id
  and cpe.table_alias = c_table_alias
  and information1 = c_pk_id;

Line: 5874

	select ptc.short_name
	from PQH_COPY_ENTITY_TXNS pcet,
	     PQH_TRANSACTION_CATEGORIES ptc
	where pcet.COPY_ENTITY_TXN_ID= p_copy_entity_txn_id
	and ptc.TRANSACTION_CATEGORY_ID = pcet.TRANSACTION_CATEGORY_ID;

Line: 5967

		select fff.formula_text into l_ff_formula_text_long from
		  ff_formulas_f fff
		where fff.formula_id =  l_fff_rec.FORMULA_ID
		and   fff.effective_start_Date = l_fff_rec.EFFECTIVE_START_DATE
		and fff.effective_end_date = l_fff_rec.EFFECTIVE_END_DATE
		--and fff.business_Group_id = l_fff_rec.business_group_id;

Line: 5977

		update ben_copy_entity_results cped
		set cped.INFORMATION325 = l_ff_formula_text_clob
		where cped.COPY_ENTITY_RESULT_ID = l_copy_entity_result_id
		and cped.copy_entity_txn_id = p_copy_entity_txn_id;

Line: 6020

     select copy_entity_result_id mirror_src_entity_result_id
     from ben_copy_entity_results cpe
        -- ,pqh_table_route trt
     where cpe.information1= c_parent_pk_id
     and   cpe.result_type_cd = l_cv_result_type_cd
     and   cpe.copy_entity_txn_id = c_copy_entity_txn_id
--     and   cpe.table_route_id = trt.table_route_id
     and   cpe.table_alias = c_parent_table_alias ;

Line: 6049

   select  eat.*
   from BEN_ACTN_TYP eat
   where  eat.business_group_id = p_business_group_id
     and not exists (
         select /* */ null
         from ben_copy_entity_results cpe
              -- ,pqh_table_route trt
         where copy_entity_txn_id = p_copy_entity_txn_id
--         and trt.table_route_id = cpe.table_route_id
         and cpe.table_alias  = c_table_alias
         and information1 = eat.actn_typ_id
        );

Line: 6165

   select ler.name
   from   ben_ler_f ler
   where  ler.ler_id = p_ler_id
   and    p_effective_date between ler.effective_start_date
   and    ler.effective_end_date;

Line: 6191

  select pgm.name
  from   ben_pgm_f pgm
  where  pgm.pgm_id = p_pgm_id
  and    p_effective_date between pgm.effective_start_date
  and    pgm.effective_end_date;

Line: 6215

  select ptp.name
  from   ben_pl_typ_f ptp
  where  ptp.pl_typ_id = p_pl_typ_id
  and    p_effective_date between ptp.effective_start_date
  and    ptp.effective_end_date;

Line: 6239

  select pln.name
  from   ben_pl_f pln
  where  pln.pl_id = p_pl_id
  and    p_effective_date between pln.effective_start_date
  and    pln.effective_end_date;

Line: 6261

  select pgm_id,pl_typ_id
  from   ben_ptip_f ctp
  where ctp.ptip_id = p_ptip_id
  and   p_effective_date between ctp.effective_start_date
        and ctp.effective_end_date;

Line: 6291

  select pgm_id,pl_id
  from   ben_plip_f cpp
  where cpp.plip_id = p_plip_id
  and   p_effective_date between cpp.effective_start_date
        and cpp.effective_end_date;

Line: 6321

  select opt_id,pl_id
  from   ben_oipl_f cop
  where cop.oipl_id = p_oipl_id
  and   p_effective_date between cop.effective_start_date
        and cop.effective_end_date;

Line: 6353

  select opt.name
  from   ben_opt_f opt
  where  opt.opt_id = p_opt_id
  and    p_effective_date between opt.effective_start_date
  and    opt.effective_end_date;

Line: 6377

  select reg.name
  from   ben_regn_f reg
  where  reg.regn_id = p_regn_id
  and    p_effective_date between reg.effective_start_date
  and    reg.effective_end_date;

Line: 6400

  select gos.name
  from   ben_gd_or_svc_typ gos
  where  gos.gd_or_svc_typ_id = p_gd_or_svc_typ_id;

Line: 6421

  select eat.name
  from   ben_actn_typ eat
  where  eat.actn_typ_id = p_actn_typ_id;

Line: 6443

  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;

Line: 6465

  select org.name
  from   hr_all_organization_units_vl org
  where  org.organization_id = p_organization_id;

Line: 6486

  select TO_CHAR(yrp.start_date,'DD-Mon-YYYY')||' -  '||
         TO_CHAR(yrp.end_date,'DD-Mon-YYYY')
  from   ben_yr_perd yrp
  where  yrp.yr_perd_id = p_yr_perd_id;

Line: 6508

  select bnr.name
  from   ben_rptg_grp bnr
  where  bnr.rptg_grp_id = p_rptg_grp_id;

Line: 6530

  select psl.name
  from   ben_per_info_chg_cs_ler_f psl
  where  psl.per_info_chg_cs_ler_id = p_per_info_chg_cs_ler_id
  and    p_effective_date between psl.effective_start_date
  and    psl.effective_end_date;

Line: 6554

  select rcl.name
  from   ben_rltd_per_chg_cs_ler_f rcl
  where  rcl.rltd_per_chg_cs_ler_id = p_rltd_per_chg_cs_ler_id
  and    p_effective_date between rcl.effective_start_date
  and    rcl.effective_end_date;

Line: 6614

  select pdl.name
  from   ben_ptd_lmt_f pdl
  where  pdl.ptd_lmt_id = p_ptd_lmt_id
  and    p_effective_date between pdl.effective_start_date
  and    pdl.effective_end_date;

Line: 6638

  select vpf.name
  from   ben_vrbl_rt_prfl_f vpf
  where  vpf.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
  and    p_effective_date between vpf.effective_start_date
  and    vpf.effective_end_date;

Line: 6661

  select agf.name
  from   ben_age_fctr agf
  where  agf.age_fctr_id = p_age_fctr_id;

Line: 6682

  select ast.assignment_set_name
  from   hr_assignment_sets ast
  where  ast.assignment_set_id = p_assignment_set_id;

Line: 6703

  select bng.name
  from   ben_benfts_grp bng
  where  bng.benfts_grp_id = p_benfts_grp_id;

Line: 6724

  select cla.name
  from   ben_cmbn_age_los_fctr cla
  where  cla.cmbn_age_los_fctr_id = p_cmbn_age_los_fctr_id;

Line: 6745

  select clf.name
  from   ben_comp_lvl_fctr clf
  where  clf.comp_lvl_fctr_id = p_comp_lvl_fctr_id;

Line: 6767

  select nvl(atl.user_status,stl.user_status) user_status
  from   per_assignment_status_types s,
         per_ass_status_type_amends a ,
         per_assignment_status_types_tl stl,
         per_ass_status_type_amends_tl atl
  where  s.assignment_status_type_id = p_assignment_status_type_id
  and    a.assignment_status_type_id (+) = s.assignment_status_type_id
  and    s.active_flag = 'Y'
  and    a.active_flag(+) = 'Y'
  and    atl.ass_status_type_amend_id (+) = a.ass_status_type_amend_id
  and    atl.language (+) = userenv('LANG')
  and    stl.assignment_status_type_id = s.assignment_status_type_id
  and    stl.language  = userenv('LANG');

Line: 6798

  select grd.name
  from   per_grades_vl grd
  where  grd.grade_id = p_grade_id;

Line: 6819

  select hwf.name
  from   ben_hrs_wkd_in_perd_fctr hwf
  where  hwf.hrs_wkd_in_perd_fctr_id = p_hrs_wkd_in_perd_fctr_id;

Line: 6856

  select aat.name
  from   per_absence_attendance_types aat
  where  aat.absence_attendance_type_id = p_absence_attendance_type_id;

Line: 6877

  select lsf.name
  from   ben_los_fctr lsf
  where  lsf.los_fctr_id = p_los_fctr_id;

Line: 6898

  select pff.name
  from   ben_pct_fl_tm_fctr pff
  where  pff.pct_fl_tm_fctr_id = p_pct_fl_tm_fctr_id;

Line: 6919

  select pty.user_person_type
  from   per_person_types_tl pty
  where  pty.person_type_id = p_person_type_id
  and    pty.language = userenv('LANG');

Line: 6941

  select nvl(ppg.group_name,segment1) name
  from   pay_people_groups ppg
  where  ppg.people_group_id = p_people_group_id;

Line: 6963

  select rzr.from_value ||' - '||rzr.to_value
  from   ben_pstl_zip_rng_f rzr
  where  rzr.pstl_zip_rng_id = p_pstl_zip_rng_id
  and    p_effective_date between rzr.effective_start_date
  and    rzr.effective_end_date;

Line: 6987

  select prl.payroll_name
  from   pay_all_payrolls_f prl
  where  prl.payroll_id = p_payroll_id
  and    p_effective_date between prl.effective_start_date
  and    prl.effective_end_date;

Line: 7010

  select pba.name
  from   per_pay_bases pba
  where  pba.pay_basis_id = p_pay_basis_id;

Line: 7032

  select sva.name
  from   ben_svc_area_f sva
  where  sva.svc_area_id = p_svc_area_id
  and    p_effective_date between sva.effective_start_date
  and    sva.effective_end_date;

Line: 7055

  select loc.location_code
  from   hr_locations loc
  where  loc.location_id = p_location_id;

Line: 7077

  select abr.name
  from   ben_acty_base_rt_f abr
  where  abr.acty_base_rt_id = p_acty_base_rt_id
  and    p_effective_date between abr.effective_start_date
  and    abr.effective_end_date;

Line: 7101

  select elp.name
  from   ben_eligy_prfl_f elp
  where  elp.eligy_prfl_id = p_eligy_prfl_id
  and    p_effective_date between elp.effective_start_date
  and    elp.effective_end_date;

Line: 7146

  select job.name
  from   per_jobs_vl job
  where  job.job_id = p_job_id;

Line: 7168

  select a.name ||b.name ||c.spinal_point name
  from per_grades_vl a, per_parent_spines b, per_spinal_points c,
       per_spinal_point_steps_f d, per_grade_spines e
  where d.step_id = p_special_ceiling_step_id
  and   d.spinal_point_id = c.spinal_point_id
  and   d.grade_spine_id  = e.grade_spine_id
  and   e.grade_id  = a.grade_id
  and   e.parent_spine_id = b.parent_spine_id
  and   p_effective_date between d.effective_start_date
        and d.effective_end_date;

Line: 7196

  select pos.name
  from   per_positions pos
  where  pos.position_id = p_position_id;

Line: 7217

  select pqt.name
  from   per_qualification_types_vl pqt
  where  pqt.qualification_type_id = p_qualification_type_id;

Line: 7239

  select dce.name
  from   ben_dpnt_cvg_eligy_prfl_f dce
  where  dce.dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id
  and    p_effective_date between dce.effective_start_date
  and    dce.effective_end_date;

Line: 7263

  select pco.name
  from   per_competences_vl pco
  where  pco.competence_id = p_competence_id;

Line: 7268

  select rtl.name
  from   per_rating_levels_vl rtl
  where  rtl.rating_level_id = p_rating_level_id;

Line: 7292

  select pon.pl_typ_id
        ,pon.opt_id
  from   ben_pl_typ_opt_typ_f pon
  where  pon.pl_typ_opt_typ_id = p_pl_typ_opt_typ_id
  and    p_effective_date between pon.effective_start_date
  and    pon.effective_end_date;

Line: 7300

  select pl_id
  from ben_oipl_f cop
  where cop.oipl_id = p_oipl_id
  and   p_effective_date between cop.effective_start_date
  and   cop.effective_end_date;

Line: 7339

     select egl.name
       from ben_eligy_criteria egl
      where egl.eligy_criteria_id = p_eligy_criteria_id;