[Home] [Help]
547: pen.enrt_cvg_strt_dt,
548: decode(pen.enrt_cvg_thru_dt,to_date('31-12-4712','dd-mm-yyyy'),null,pen.enrt_cvg_thru_dt) enrt_cvg_thru_dt ,
549: popl.val,
550: nvl(pen.uom, popl.uom) uom,
551: decode(apr.pl_id, null, ben_batch_utils.get_opt_name(apr.oipl_id, p_business_group_id, p_run_date)) option_name,
552: apr.oipl_id,
553: apr.pl_id ,
554: ben_recn_rep.get_prtt_rate_val(pen.prtt_enrt_rslt_id , p_report_start_date, pen.per_in_ler_id, p_report_end_date) rate-- 3608119
555: from ben_prtt_enrt_rslt_f pen
659: begin
660:
661: -- Report Headers
662: if p_pgm_id is not null then
663: l_pgm_name := ben_batch_utils.get_pgm_name(p_pgm_id, p_business_group_id,p_run_date);
664: end if;
665: --
666: l_pl_name := ben_batch_utils.get_pl_name(p_pl_id,p_business_group_id,p_run_date);
667: l_date := ' ' || to_char(p_report_start_date,'DD Month YYYY')
662: if p_pgm_id is not null then
663: l_pgm_name := ben_batch_utils.get_pgm_name(p_pgm_id, p_business_group_id,p_run_date);
664: end if;
665: --
666: l_pl_name := ben_batch_utils.get_pl_name(p_pl_id,p_business_group_id,p_run_date);
667: l_date := ' ' || to_char(p_report_start_date,'DD Month YYYY')
668: || ' - ' || to_char(p_report_end_date,'DD Month YYYY');
669: l_plan_recn_rep_header := l_pl_name ||' Reconciliations for'|| l_date;
670: l_plan_disc_rep_header := l_pl_name ||' Discrepancies for'|| l_date;
1870: --
1871: p_ret_emp_name_format := hr_general.decode_lookup('BEN_PER_NAME_FMT',p_emp_name_format );
1872: --
1873: if p_pgm_id is not null then
1874: p_ret_pgm := ben_batch_utils.get_pgm_name(p_pgm_id, p_business_group_id,p_run_date);
1875: else
1876: p_ret_pgm := l_all;
1877: end if;
1878: --
1875: else
1876: p_ret_pgm := l_all;
1877: end if;
1878: --
1879: p_ret_pl := ben_batch_utils.get_pl_name(p_pl_id,p_business_group_id,p_run_date);
1880: --
1881: if p_per_sel_rule_id is not null then
1882: open c_formula;
1883: fetch c_formula into p_ret_per_sel_rule;