278: and yr.yr_perd_id = enp.yr_perd_id
279: and wyr.wthn_yr_perd_id (+) = enp.wthn_yr_perd_id;
280:
281: -- cursor to fetch the plan details
282: -- Bug 3975857 : In cursor CSR_PLS pick up only Active Standard Rates. Added clause <
284: cursor csr_pls(p_group_pl_id number
285: ,p_effective_date date
286: ,p_group_pl_uom varchar2
441: where dsgn.group_pl_id = p_group_pl_id
442: and dsgn.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
443: and dsgn.pl_id = pl.pl_id);
444:
445: -- Bug 3975857 : In cursor CSR_OIPLS pick up only Active Standard Rates. Added clause <
447: cursor csr_oipls(p_pl_id number
448: ,p_effective_date date) is
449: select oipl.oipl_id oipl_id