eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ELECTION_INFORMATION dependencies on BEN_PER_IN_LER

Line 546: getting passed from pen record. Now, passing it from ben_per_in_ler

542: global cvg and rate start date variables.
543: 10-Mar-09 krupani 115.264 BUG 8244388: When Child rate is multiple of parent, fetch the parent rate value
544: as of Child rate strat date
545: 01-Apr-09 krupani 115.265 Bug 8374859: While calling ben_determine_activity_base_rt.main, ler_id was
546: getting passed from pen record. Now, passing it from ben_per_in_ler
547: 29-Apr-09 velvanop 115.266 Bug 8300620: Fix of Bug 7206471 causing rate gap issues on processing the LifeEvent.
548: Cursor c_get_elctbl_chc fetches all the choices tied to the current PIL grouped by ptip_id.
549: As a result, besides the required plan type to be actually adjusted, all ptip's are picked up
550: and the rates are adjusted.So modified cursor to pick the correct ptip instead of pickingup

Line 1364: from ben_per_in_ler pil,

1360: and prtt_rt_val_stat_cd IS NULL ; --BUG 4938498
1361: --
1362: cursor c_unrestricted is
1363: select null
1364: from ben_per_in_ler pil,
1365: ben_ler_f ler
1366: where pil.per_in_ler_id = p_per_in_ler_id
1367: and pil.ler_id = ler.ler_id
1368: and ler.typ_cd = 'SCHEDDU'

Line 1377: from ben_per_in_ler pil,

1373:
1374: -- Bug 8374859
1375: cursor c_ler_id is
1376: select ler.ler_id
1377: from ben_per_in_ler pil,
1378: ben_ler_f ler
1379: where pil.per_in_ler_id = p_per_in_ler_id
1380: and pil.ler_id = ler.ler_id
1381: and ler.business_group_id = p_business_group_id

Line 1590: from ben_per_in_ler pil,

1586:
1587: /* Added cursor for Bug 8945818: Get the previous per_in_ler_id */
1588: cursor c_prev_per_in_ler is
1589: select pil.per_in_ler_id
1590: from ben_per_in_ler pil,
1591: ben_per_in_ler pil1,
1592: ben_ler_f ler
1593: where pil1.per_in_ler_id = p_per_in_ler_id
1594: and pil1.person_id = pil.person_id

Line 1591: ben_per_in_ler pil1,

1587: /* Added cursor for Bug 8945818: Get the previous per_in_ler_id */
1588: cursor c_prev_per_in_ler is
1589: select pil.per_in_ler_id
1590: from ben_per_in_ler pil,
1591: ben_per_in_ler pil1,
1592: ben_ler_f ler
1593: where pil1.per_in_ler_id = p_per_in_ler_id
1594: and pil1.person_id = pil.person_id
1595: and pil1.per_in_ler_id <> pil.per_in_ler_id

Line 1609: from ben_per_in_ler pil, ben_per_in_ler pil2

1605: --
1606:
1607: cursor c_get_prior_per_in_ler(c_rt_strt_dt date) is
1608: select 'Y'
1609: from ben_per_in_ler pil, ben_per_in_ler pil2
1610: where pil.per_in_ler_id <> p_per_in_ler_id
1611: /* Bug 8945818: Added 'or' condition. Check for future rates for the previous life event */
1612: and ( (trunc(pil.lf_evt_ocrd_dt, 'MM') = trunc(pil2.lf_evt_ocrd_dt, 'MM')) or
1613: ('Y' = ( select 'Y' from ben_prtt_rt_val prv,

Line 4942: ben_per_in_ler pil,ben_ler_f ler

4938:
4939: -- Bug 14803995
4940: cursor c_unrest(c_per_in_ler_id number) is
4941: select ler.typ_cd from
4942: ben_per_in_ler pil,ben_ler_f ler
4943: where pil.ler_id=ler.ler_id
4944: and p_effective_date between ler.effective_start_date
4945: and ler.effective_end_date
4946: and pil.per_in_ler_id=c_per_in_ler_id;

Line 5160: from ben_per_in_ler pil,

5156: /* Added cursor for Bug 8945818: Get the previous per_in_ler_id */
5157:
5158: cursor c_prev_per_in_ler is
5159: select pil.per_in_ler_id
5160: from ben_per_in_ler pil,
5161: ben_per_in_ler pil1,
5162: ben_ler_f ler,
5163: ben_elig_per_elctbl_chc epe
5164: where pil1.per_in_ler_id = epe.per_in_ler_id

Line 5161: ben_per_in_ler pil1,

5157:
5158: cursor c_prev_per_in_ler is
5159: select pil.per_in_ler_id
5160: from ben_per_in_ler pil,
5161: ben_per_in_ler pil1,
5162: ben_ler_f ler,
5163: ben_elig_per_elctbl_chc epe
5164: where pil1.per_in_ler_id = epe.per_in_ler_id
5165: and epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id

Line 5179: from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil,

5175: l_prev_pil_id number;
5176:
5177: cursor c_get_prior_per_in_ler(c_cvg_strt_dt date) is
5178: select 'Y'
5179: from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil,
5180: ben_per_in_ler pil2
5181: where epe.elig_per_elctbl_chc_id=p_elig_per_elctbl_chc_id
5182: and pil.per_in_ler_id <> epe.per_in_ler_id
5183: /* Bug 8945818: Added 'or' condition. Check for future coverage for the previous life event */

Line 5180: ben_per_in_ler pil2

5176:
5177: cursor c_get_prior_per_in_ler(c_cvg_strt_dt date) is
5178: select 'Y'
5179: from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil,
5180: ben_per_in_ler pil2
5181: where epe.elig_per_elctbl_chc_id=p_elig_per_elctbl_chc_id
5182: and pil.per_in_ler_id <> epe.per_in_ler_id
5183: /* Bug 8945818: Added 'or' condition. Check for future coverage for the previous life event */
5184: and ( (trunc(pil.lf_evt_ocrd_dt, 'MM') = trunc(pil2.lf_evt_ocrd_dt, 'MM')) or

Line 5215: from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil,

5211: -- for the coverage that are starting the future.the below cursor c_get_prior_per_in_ler_1 checks
5212: -- for any coverage that are end dating in the future
5213: cursor c_get_prior_per_in_ler_1(c_cvg_strt_dt date) is
5214: select 'Y'
5215: from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil,
5216: ben_per_in_ler pil2
5217: where epe.elig_per_elctbl_chc_id=p_elig_per_elctbl_chc_id
5218: and pil.per_in_ler_id <> epe.per_in_ler_id
5219: /* Bug 8945818: Added 'or' condition. Check for future coverage for the previous life event */

Line 5216: ben_per_in_ler pil2

5212: -- for any coverage that are end dating in the future
5213: cursor c_get_prior_per_in_ler_1(c_cvg_strt_dt date) is
5214: select 'Y'
5215: from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil,
5216: ben_per_in_ler pil2
5217: where epe.elig_per_elctbl_chc_id=p_elig_per_elctbl_chc_id
5218: and pil.per_in_ler_id <> epe.per_in_ler_id
5219: /* Bug 8945818: Added 'or' condition. Check for future coverage for the previous life event */
5220: and ( (trunc(pil.lf_evt_ocrd_dt, 'MM') = trunc(pil2.lf_evt_ocrd_dt, 'MM')) or

Line 5291: ,ben_per_in_ler pil

5287: ) is
5288: select pen.*, epe.per_in_ler_id pil_id
5289: from ben_prtt_enrt_rslt_f pen
5290: ,ben_ptip_f ptip
5291: ,ben_per_in_ler pil
5292: ,ben_elig_per_elctbl_chc epe
5293: where pen.effective_end_date = hr_api.g_eot -- '31-dec-4712'
5294: and pen.enrt_cvg_thru_dt <> hr_api.g_eot -- '31-dec-4712'
5295: and pen.prtt_enrt_rslt_stat_cd is null

Line 5366: FROM ben_per_in_ler pil

5362: -----Enf of Bug 9139820
5363: ----Bug 8596122
5364: cursor c_prev_pil(p_person_id number) is
5365: SELECT pil.per_in_ler_id
5366: FROM ben_per_in_ler pil
5367: WHERE pil.business_group_id = p_business_group_id
5368: AND pil.person_id = p_person_id
5369: AND pil.per_in_ler_stat_cd = 'PROCD'
5370: ORDER BY pil.lf_evt_ocrd_dt DESC ;

Line 5377: FROM ben_per_in_ler pil

5373:
5374: ---Bug 9430735
5375: cursor c_prev_pil_with_pen(p_person_id number,p_pen_id number) is
5376: SELECT pil.per_in_ler_id
5377: FROM ben_per_in_ler pil
5378: WHERE pil.business_group_id = p_business_group_id
5379: AND pil.person_id = p_person_id
5380: AND pil.per_in_ler_stat_cd = 'PROCD'
5381: and exists(select null

Line 8094: ben_per_in_ler pil

8090: select ebr.enrt_bnft_id,
8091: ebr.object_version_number
8092: from ben_enrt_bnft ebr,
8093: ben_elig_per_elctbl_chc epe,
8094: ben_per_in_ler pil
8095: where ebr.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id and
8096: ( p_enrt_bnft_id is null OR
8097: ebr.enrt_bnft_id <> p_enrt_bnft_id )
8098: and epe.elig_per_elctbl_chc_id=ebr.elig_per_elctbl_chc_id