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_ENROLLMENT_ACTION_ITEMS dependencies on BEN_PER_IN_LER

Line 639: ben_per_in_ler pil

635: epe.pl_id,
636: epe.pgm_id
637: from ben_prtt_enrt_rslt_f pen,
638: ben_elig_per_elctbl_chc epe,
639: ben_per_in_ler pil
640: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
641: and pen.prtt_enrt_rslt_stat_cd is null
642: and p_effective_date between
643: pen.effective_start_date and pen.effective_end_date

Line 828: ben_per_in_ler pil

824: select pea.prtt_enrt_actn_id,
825: pea.cmpltd_dt,
826: pea.object_version_number
827: from ben_prtt_enrt_actn_f pea,
828: ben_per_in_ler pil
829: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
830: and pea.actn_typ_id = p_actn_typ_id
831: and pea.pl_bnf_id is null
832: and pea.elig_cvrd_dpnt_id is null

Line 851: ben_per_in_ler pil

847: select pea.prtt_enrt_actn_id,
848: pea.cmpltd_dt,
849: pea.object_version_number
850: from ben_prtt_enrt_actn_f pea,
851: ben_per_in_ler pil
852: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
853: and pea.actn_typ_id = p_actn_typ_id
854: and pea.per_in_ler_id = pil.per_in_ler_id
855: and pil.per_in_ler_stat_cd not in ('BCKDT', 'VOIDD')

Line 871: ben_per_in_ler pil

867: select pea.prtt_enrt_actn_id,
868: pea.cmpltd_dt,
869: pea.object_version_number
870: from ben_prtt_enrt_actn_f pea,
871: ben_per_in_ler pil
872: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
873: and pea.actn_typ_id = p_actn_typ_id
874: and pea.pl_bnf_id = p_pl_bnf_id
875: and pea.per_in_ler_id = pil.per_in_ler_id

Line 1295: ben_per_in_ler pil

1291: and ecp.prtt_enrt_actn_id=p_prtt_enrt_actn_id
1292: and exists -- Bug 6022327: Changed from not exists to exists
1293: ( select pea.prtt_enrt_actn_id
1294: from ben_prtt_enrt_actn_f pea,
1295: ben_per_in_ler pil
1296: where pea.per_in_ler_id = pil.per_in_ler_id
1297: and pil.per_in_ler_stat_cd not in ('BCKDT', 'VOIDD')
1298: and pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1299: and p_effective_date between

Line 1818: ben_per_in_ler pil

1814: select pcs.prtt_enrt_ctfn_prvdd_id,
1815: pcs.object_version_number
1816: from ben_prtt_enrt_ctfn_prvdd_f pcs,
1817: ben_prtt_enrt_actn_f pea,
1818: ben_per_in_ler pil
1819: where pcs.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1820: and pcs.enrt_ctfn_recd_dt is NULL
1821: and pcs.business_group_id = p_business_group_id
1822: and p_effective_date between pcs.effective_start_date

Line 1889: ben_per_in_ler pil

1885: cursor c_dpnt_ctfn_prvdd is
1886: select prv.cvrd_dpnt_ctfn_prvdd_id,
1887: prv.object_version_number
1888: from ben_elig_cvrd_dpnt_f ecd, ben_cvrd_dpnt_ctfn_prvdd_f prv,
1889: ben_per_in_ler pil
1890: where ecd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1891: and ecd.cvg_strt_dt is not null
1892: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
1893: and ecd.elig_cvrd_dpnt_id = prv.elig_cvrd_dpnt_id

Line 3392: ben_per_in_ler pil

3388: pen.ptip_id,
3389: pen.pl_id
3390: from ben_elig_cvrd_dpnt_f ecd,
3391: ben_prtt_enrt_rslt_f pen,
3392: ben_per_in_ler pil
3393: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3394: and pen.prtt_enrt_rslt_id = ecd.prtt_enrt_rslt_id
3395: and ecd.cvg_strt_dt is not null
3396: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot

Line 3414: ben_per_in_ler pil

3410: ccp.dpnt_dsgn_ctfn_rqd_flag,
3411: ccp.dpnt_dsgn_ctfn_recd_dt
3412: from ben_cvrd_dpnt_ctfn_prvdd_f ccp,
3413: ben_elig_cvrd_dpnt_f ecd,
3414: ben_per_in_ler pil
3415: where ccp.elig_cvrd_dpnt_id = cl_dpnt_id
3416: and ccp.dpnt_dsgn_ctfn_recd_dt IS NULL
3417: and ccp.business_group_id = p_business_group_id
3418: and p_effective_date between

Line 4638: ben_per_in_ler pil

4634: --
4635: cursor c_dpnt_dsgn is
4636: select ecd.dpnt_person_id
4637: from ben_elig_cvrd_dpnt_f ecd,
4638: ben_per_in_ler pil
4639: where ecd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4640: and ecd.cvg_strt_dt is not null
4641: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
4642: and ecd.business_group_id = p_business_group_id

Line 4660: ben_per_in_ler pil

4656: select pea.prtt_enrt_actn_id,
4657: pea.object_version_number
4658: from ben_prtt_enrt_actn_f pea,
4659: ben_actn_typ typ,
4660: ben_per_in_ler pil
4661: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4662: and pea.business_group_id = p_business_group_id
4663: and typ.type_cd <> 'DD'
4664: and typ.type_cd like 'DD%'

Line 5082: ben_per_in_ler pil

5078: --
5079: cursor c_num_of_dpnts is
5080: select count(1) cnt
5081: from ben_elig_cvrd_dpnt_f ecd,
5082: ben_per_in_ler pil
5083: where p_prtt_enrt_rslt_id = ecd.prtt_enrt_rslt_id
5084: and ecd.cvg_strt_dt is not null
5085: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
5086: and ecd.business_group_id = p_business_group_id

Line 5128: ben_per_in_ler pil

5124: and mn_dpnts_rqd_num >
5125: (select count(1)
5126: from ben_elig_cvrd_dpnt_f ecd,
5127: per_contact_relationships pcr,
5128: ben_per_in_ler pil
5129: where ecd.prtt_enrt_rslt_id = perslt.prtt_enrt_rslt_id
5130: and ecd.cvg_strt_dt is not null
5131: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
5132: and ecd.business_group_id = p_business_group_id

Line 5342: ben_per_in_ler pil

5338: cursor c_chc_flags is
5339: select epe.alws_dpnt_dsgn_flag, epe.dpnt_dsgn_cd
5340: from ben_prtt_enrt_rslt_f pen,
5341: ben_elig_per_elctbl_chc epe,
5342: ben_per_in_ler pil
5343: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5344: and pen.prtt_enrt_rslt_stat_cd is null
5345: and p_effective_date between
5346: pen.effective_start_date and pen.effective_end_date

Line 5527: ben_per_in_ler pil

5523: p_enrt_ctfn_typ_cd varchar2 ) is
5524: select 'Y'
5525: from ben_ler_rqrs_enrt_ctfn_f lre,
5526: ben_ler_enrt_ctfn_f lec,
5527: ben_per_in_ler pil
5528: where lre.pl_id = p_pl_id
5529: and pil.per_in_ler_id = p_per_in_ler_id
5530: and lre.ler_id = pil.ler_id
5531: and p_effective_date between lre.effective_start_date

Line 5792: ben_per_in_ler pil

5788: p_per_in_ler_id number,
5789: p_pl_id number) is
5790: select rstrn.cvg_incr_r_decr_only_cd
5791: from ben_ler_bnft_rstrn_f rstrn,
5792: ben_per_in_ler pil
5793: where rstrn.ler_id = pil.ler_id
5794: and rstrn.pl_id = p_pl_id
5795: and pil.per_in_ler_id = p_per_in_ler_id
5796: and p_effective_date

Line 6091: ben_per_in_ler pil

6087: nvl(pen.bnft_amt, 0) bnft_amt,
6088: pen.oipl_id
6089: from ben_prtt_enrt_rslt_f pen,
6090: ben_elig_per_elctbl_chc epe,
6091: ben_per_in_ler pil
6092: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6093: and pen.prtt_enrt_rslt_stat_cd is null
6094: and p_effective_date between
6095: pen.effective_start_date and pen.effective_end_date

Line 6164: ben_per_in_ler pil

6160: is
6161: select pea.prtt_enrt_actn_id,
6162: pea.per_in_ler_id
6163: from ben_prtt_enrt_actn_f pea,
6164: ben_per_in_ler pil
6165: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6166: and pea.actn_typ_id = p_actn_typ_id
6167: and pea.pl_bnf_id is null
6168: and pea.elig_cvrd_dpnt_id is null

Line 6187: ben_per_in_ler pil

6183: p_per_in_ler_id number,
6184: p_pl_id number) is
6185: select rstrn.cvg_incr_r_decr_only_cd
6186: from ben_ler_bnft_rstrn_f rstrn,
6187: ben_per_in_ler pil
6188: where rstrn.ler_id = pil.ler_id
6189: and rstrn.pl_id = p_pl_id
6190: and pil.per_in_ler_id = p_per_in_ler_id
6191: and p_effective_date

Line 7588: ben_per_in_ler pil

7584: cursor c_dsgn_bnf is
7585: select pbd.pl_bnf_id,
7586: pbd.bnf_person_id
7587: from ben_pl_bnf_f pbd,
7588: ben_per_in_ler pil
7589: where pbd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
7590: and pbd.dsgn_strt_dt is not null
7591: and nvl(pbd.dsgn_thru_dt, hr_api.g_eot) = hr_api.g_eot
7592: and pbd.business_group_id = p_business_group_id

Line 8407: ben_per_in_ler pil

8403: --
8404: cursor c_find_bnf is
8405: select pl_bnf_id
8406: from ben_pl_bnf_f,
8407: ben_per_in_ler pil
8408: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8409: and p_effective_date between
8410: effective_start_date and effective_end_date
8411: and pil.per_in_ler_id=ben_pl_bnf_f.per_in_ler_id

Line 8426: ben_per_in_ler pil

8422: select pea.prtt_enrt_actn_id,
8423: pea.object_version_number
8424: from ben_prtt_enrt_actn_f pea,
8425: ben_actn_typ typ,
8426: ben_per_in_ler pil
8427: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8428: and pea.business_group_id = p_business_group_id
8429: and typ.type_cd <> 'BNF'
8430: and typ.type_cd like 'BNF%'

Line 8695: ben_per_in_ler pil

8691: cursor c_sum_bnf_pct is
8692: select prmry_cntngnt_cd cntgcd,
8693: sum(pct_dsgd_num) prcnt
8694: from ben_pl_bnf_f ,
8695: ben_per_in_ler pil
8696: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8697: and ben_pl_bnf_f.business_group_id = p_business_group_id
8698: and p_effective_date between
8699: ben_pl_bnf_f.effective_start_date and ben_pl_bnf_f.effective_end_date

Line 8747: ben_per_in_ler pil

8743: per_contact_relationships pcr,
8744: ben_pl_f pl,
8745: ben_pl_bnf_f plb,
8746: ben_prtt_enrt_rslt_f pen,
8747: ben_per_in_ler pil
8748: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8749: and pen.pl_id = pl.pl_id
8750: and pl.bnf_qdro_rl_apls_flag = 'Y'
8751: and pl.bnf_ctfn_rqd_flag = 'N' -- Flag is named incorrectly(opposite).

Line 8786: ben_per_in_ler pil

8782: hr_all_organization_units o,
8783: ben_pl_f pl,
8784: ben_pl_bnf_f plb,
8785: ben_prtt_enrt_rslt_f pen,
8786: ben_per_in_ler pil
8787: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8788: and pen.pl_id = pl.pl_id
8789: and pl.bnf_qdro_rl_apls_flag = 'Y'
8790: and pl.bnf_may_dsgt_org_flag = 'Y'