[Home] [Help]
501: instead of a fixed format-mask.
502: 115.217 07=Apr-04 tjesumic FONM changes added
503: 115.218 19-apr-04 bmanyam Bug# 3573173 : In c_prem cursor, added
504: condition NVL(ecr.enrt_bnft_id, -1) = NVL(p_enrt_bnft_id, -1) to
505: make sure the ben_enrt_prem record refers to the correct ben_enrt_bnft_f
506: record while creating ben_prtt_prem.
507: 115.219 21-Apr-04 kmahendr Bug#3568529 - ben_env_object.init is called only if the
508: object was not initialised.
509: 115.220 04-May-04 bmanyam Bug: 3574168 - In void_enrollment, delete_enrollment and
5472: ,enb.enrt_bnft_id
5473: from ben_prtt_enrt_rslt_f pen
5474: ,ben_elig_per_elctbl_chc epe
5475: ,ben_per_in_ler pil
5476: ,ben_enrt_bnft enb
5477: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5478: and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id (+)
5479: and nvl(epe.elig_per_elctbl_chc_id, -1) = enb.elig_per_elctbl_chc_id (+)
5480: and pen.business_group_id = p_business_group_id
5516: ,epe.object_version_number epe_ovn
5517: ,enb.enrt_bnft_id
5518: from ben_elig_per_elctbl_chc epe
5519: ,ben_per_in_ler pil
5520: ,ben_enrt_bnft enb
5521: where epe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5522: and nvl(epe.elig_per_elctbl_chc_id, -1) = enb.elig_per_elctbl_chc_id (+)
5523: and pil.per_in_ler_id=epe.per_in_ler_id
5524: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
6049: ,pl.imptd_incm_calc_cd
6050: from ben_prtt_enrt_rslt_f pen
6051: ,ben_elig_per_elctbl_chc epe
6052: ,ben_per_in_ler pil
6053: ,ben_enrt_bnft enb
6054: ,ben_oipl_f oipl
6055: ,ben_pl_f pl
6056: ,ben_opt_f opt
6057: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8857: end if;
8858: --
8859: end loop;
8860: --
8861: -- Clear out ben_enrt_bnft table's prtt_enrt_rslt_id
8862: --
8863: l_step := 176;
8864: --
8865: -- Do not call manage_enrt_bnft, if it is called from election_information