DBA Data[Home] [Help]

APPS.BEN_CWB_PL_DSGN_PKG dependencies on STANDARD

Line 282: -- Bug 3975857 : In cursor CSR_PLS pick up only Active Standard Rates. Added clause <>

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 <>
283: -- to the cursor query
284: cursor csr_pls(p_group_pl_id number
285: ,p_effective_date date
286: ,p_group_pl_uom varchar2

Line 445: -- Bug 3975857 : In cursor CSR_OIPLS pick up only Active Standard Rates. Added clause <>

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 <>
446: -- to the cursor query
447: cursor csr_oipls(p_pl_id number
448: ,p_effective_date date) is
449: select oipl.oipl_id oipl_id