[Home] [Help]
112: ,enp.prsvr_bdgt_cd prsrv_bdgt_cd
113: from ben_pl_typ_f typ
114: ,ben_pl_f pl
115: ,ben_popl_enrt_typ_cycl_f cyc
116: ,ben_enrt_perd enp
117: where typ.opt_typ_cd = 'CWB'
118: and typ.pl_typ_id = pl.pl_typ_id
119: and pl.pl_id = cyc.pl_id
120: and cyc.popl_enrt_typ_cycl_id = enp.popl_enrt_typ_cycl_id
282: end if; -- pl_typ_id <> old_pl_typ_id
283:
284:
285: begin
286: update ben_enrt_perd perd
287: set perd.data_freeze_date = perd.asnd_lf_evt_dt
288: ,perd.approval_mode_cd = g_approval_mode
289: where perd.enrt_perd_id = l_pl_dsgn.enrt_perd_id
290: and perd.data_freeze_date is null;
1676: ,enp.emp_interview_type_cd
1677: ,tx.attribute3
1678: from ben_transaction tx
1679: ,ben_pil_elctbl_chc_popl popl
1680: ,ben_enrt_perd enp
1681: where tx.transaction_type = 'CWBWSASG'
1682: and tx.attribute1 is not null
1683: and tx.attribute3 is not null
1684: and tx.transaction_id = popl.pil_elctbl_chc_popl_id