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 652: ben_per_in_ler pil

648: epe.pl_id,
649: epe.pgm_id
650: from ben_prtt_enrt_rslt_f pen,
651: ben_elig_per_elctbl_chc epe,
652: ben_per_in_ler pil
653: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
654: and pen.prtt_enrt_rslt_stat_cd is null
655: and p_effective_date between
656: pen.effective_start_date and pen.effective_end_date

Line 841: ben_per_in_ler pil

837: select pea.prtt_enrt_actn_id,
838: pea.cmpltd_dt,
839: pea.object_version_number
840: from ben_prtt_enrt_actn_f pea,
841: ben_per_in_ler pil
842: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
843: and pea.actn_typ_id = p_actn_typ_id
844: and pea.pl_bnf_id is null
845: and pea.elig_cvrd_dpnt_id is null

Line 864: ben_per_in_ler pil

860: select pea.prtt_enrt_actn_id,
861: pea.cmpltd_dt,
862: pea.object_version_number
863: from ben_prtt_enrt_actn_f pea,
864: ben_per_in_ler pil
865: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
866: and pea.actn_typ_id = p_actn_typ_id
867: and pea.per_in_ler_id = pil.per_in_ler_id
868: and pil.per_in_ler_stat_cd not in ('BCKDT', 'VOIDD')

Line 884: ben_per_in_ler pil

880: select pea.prtt_enrt_actn_id,
881: pea.cmpltd_dt,
882: pea.object_version_number
883: from ben_prtt_enrt_actn_f pea,
884: ben_per_in_ler pil
885: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
886: and pea.actn_typ_id = p_actn_typ_id
887: and pea.pl_bnf_id = p_pl_bnf_id
888: and pea.per_in_ler_id = pil.per_in_ler_id

Line 1308: ben_per_in_ler pil

1304: and ecp.prtt_enrt_actn_id=p_prtt_enrt_actn_id
1305: and exists -- Bug 6022327: Changed from not exists to exists
1306: ( select pea.prtt_enrt_actn_id
1307: from ben_prtt_enrt_actn_f pea,
1308: ben_per_in_ler pil
1309: where pea.per_in_ler_id = pil.per_in_ler_id
1310: and pil.per_in_ler_stat_cd not in ('BCKDT', 'VOIDD')
1311: and pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1312: and p_effective_date between

Line 1831: ben_per_in_ler pil

1827: select pcs.prtt_enrt_ctfn_prvdd_id,
1828: pcs.object_version_number
1829: from ben_prtt_enrt_ctfn_prvdd_f pcs,
1830: ben_prtt_enrt_actn_f pea,
1831: ben_per_in_ler pil
1832: where pcs.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1833: and pcs.enrt_ctfn_recd_dt is NULL
1834: and pcs.business_group_id = p_business_group_id
1835: and p_effective_date between pcs.effective_start_date

Line 1902: ben_per_in_ler pil

1898: cursor c_dpnt_ctfn_prvdd is
1899: select prv.cvrd_dpnt_ctfn_prvdd_id,
1900: prv.object_version_number
1901: from ben_elig_cvrd_dpnt_f ecd, ben_cvrd_dpnt_ctfn_prvdd_f prv,
1902: ben_per_in_ler pil
1903: where ecd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1904: and ecd.cvg_strt_dt is not null
1905: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
1906: and ecd.elig_cvrd_dpnt_id = prv.elig_cvrd_dpnt_id

Line 3405: ben_per_in_ler pil

3401: pen.ptip_id,
3402: pen.pl_id
3403: from ben_elig_cvrd_dpnt_f ecd,
3404: ben_prtt_enrt_rslt_f pen,
3405: ben_per_in_ler pil
3406: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3407: and pen.prtt_enrt_rslt_id = ecd.prtt_enrt_rslt_id
3408: and ecd.cvg_strt_dt is not null
3409: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot

Line 3427: ben_per_in_ler pil

3423: ccp.dpnt_dsgn_ctfn_rqd_flag,
3424: ccp.dpnt_dsgn_ctfn_recd_dt
3425: from ben_cvrd_dpnt_ctfn_prvdd_f ccp,
3426: ben_elig_cvrd_dpnt_f ecd,
3427: ben_per_in_ler pil
3428: where ccp.elig_cvrd_dpnt_id = cl_dpnt_id
3429: and ccp.dpnt_dsgn_ctfn_recd_dt IS NULL
3430: and ccp.business_group_id = p_business_group_id
3431: and p_effective_date between

Line 4651: ben_per_in_ler pil

4647: --
4648: cursor c_dpnt_dsgn is
4649: select ecd.dpnt_person_id
4650: from ben_elig_cvrd_dpnt_f ecd,
4651: ben_per_in_ler pil
4652: where ecd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4653: and ecd.cvg_strt_dt is not null
4654: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
4655: and ecd.business_group_id = p_business_group_id

Line 4673: ben_per_in_ler pil

4669: select pea.prtt_enrt_actn_id,
4670: pea.object_version_number
4671: from ben_prtt_enrt_actn_f pea,
4672: ben_actn_typ typ,
4673: ben_per_in_ler pil
4674: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4675: and pea.business_group_id = p_business_group_id
4676: and typ.type_cd <> 'DD'
4677: and typ.type_cd like 'DD%'

Line 5096: ben_per_in_ler pil

5092: --
5093: cursor c_num_of_dpnts is
5094: select count(1) cnt
5095: from ben_elig_cvrd_dpnt_f ecd,
5096: ben_per_in_ler pil
5097: where p_prtt_enrt_rslt_id = ecd.prtt_enrt_rslt_id
5098: and ecd.cvg_strt_dt is not null
5099: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
5100: and ecd.business_group_id = p_business_group_id

Line 5143: ben_per_in_ler pil

5139: and mn_dpnts_rqd_num >
5140: (select count(1)
5141: from ben_elig_cvrd_dpnt_f ecd,
5142: per_contact_relationships pcr,
5143: ben_per_in_ler pil
5144: where ecd.prtt_enrt_rslt_id = perslt.prtt_enrt_rslt_id
5145: and ecd.cvg_strt_dt is not null
5146: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
5147: and ecd.business_group_id = p_business_group_id

Line 5169: ben_per_in_ler pil,

5165: cursor c_get_ler_typ is
5166: select ler.typ_cd,
5167: pil.lf_evt_ocrd_dt
5168: from ben_prtt_enrt_rslt_f pen,
5169: ben_per_in_ler pil,
5170: ben_ler_f ler
5171: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5172: and pen.per_in_ler_id = pil.per_in_ler_id
5173: and ler.ler_id = pil.ler_id

Line 5420: ben_per_in_ler pil

5416: cursor c_chc_flags is
5417: select epe.alws_dpnt_dsgn_flag, epe.dpnt_dsgn_cd
5418: from ben_prtt_enrt_rslt_f pen,
5419: ben_elig_per_elctbl_chc epe,
5420: ben_per_in_ler pil
5421: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5422: and pen.prtt_enrt_rslt_stat_cd is null
5423: and p_effective_date between
5424: pen.effective_start_date and pen.effective_end_date

Line 5605: ben_per_in_ler pil

5601: p_enrt_ctfn_typ_cd varchar2 ) is
5602: select 'Y'
5603: from ben_ler_rqrs_enrt_ctfn_f lre,
5604: ben_ler_enrt_ctfn_f lec,
5605: ben_per_in_ler pil
5606: where lre.pl_id = p_pl_id
5607: and pil.per_in_ler_id = p_per_in_ler_id
5608: and lre.ler_id = pil.ler_id
5609: and p_effective_date between lre.effective_start_date

Line 5870: ben_per_in_ler pil

5866: p_per_in_ler_id number,
5867: p_pl_id number) is
5868: select rstrn.cvg_incr_r_decr_only_cd
5869: from ben_ler_bnft_rstrn_f rstrn,
5870: ben_per_in_ler pil
5871: where rstrn.ler_id = pil.ler_id
5872: and rstrn.pl_id = p_pl_id
5873: and pil.per_in_ler_id = p_per_in_ler_id
5874: and p_effective_date

Line 6169: ben_per_in_ler pil

6165: nvl(pen.bnft_amt, 0) bnft_amt,
6166: pen.oipl_id
6167: from ben_prtt_enrt_rslt_f pen,
6168: ben_elig_per_elctbl_chc epe,
6169: ben_per_in_ler pil
6170: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6171: and pen.prtt_enrt_rslt_stat_cd is null
6172: and p_effective_date between
6173: pen.effective_start_date and pen.effective_end_date

Line 6242: ben_per_in_ler pil

6238: is
6239: select pea.prtt_enrt_actn_id,
6240: pea.per_in_ler_id
6241: from ben_prtt_enrt_actn_f pea,
6242: ben_per_in_ler pil
6243: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6244: and pea.actn_typ_id = p_actn_typ_id
6245: and pea.pl_bnf_id is null
6246: and pea.elig_cvrd_dpnt_id is null

Line 6265: ben_per_in_ler pil

6261: p_per_in_ler_id number,
6262: p_pl_id number) is
6263: select rstrn.cvg_incr_r_decr_only_cd
6264: from ben_ler_bnft_rstrn_f rstrn,
6265: ben_per_in_ler pil
6266: where rstrn.ler_id = pil.ler_id
6267: and rstrn.pl_id = p_pl_id
6268: and pil.per_in_ler_id = p_per_in_ler_id
6269: and p_effective_date

Line 7673: ben_per_in_ler pil

7669: cursor c_dsgn_bnf is
7670: select pbd.pl_bnf_id,
7671: pbd.bnf_person_id
7672: from ben_pl_bnf_f pbd,
7673: ben_per_in_ler pil
7674: where pbd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
7675: and pbd.dsgn_strt_dt is not null
7676: and nvl(pbd.dsgn_thru_dt, hr_api.g_eot) = hr_api.g_eot
7677: and pbd.business_group_id = p_business_group_id

Line 8492: ben_per_in_ler pil

8488: --
8489: cursor c_find_bnf is
8490: select pl_bnf_id
8491: from ben_pl_bnf_f,
8492: ben_per_in_ler pil
8493: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8494: and p_effective_date between
8495: effective_start_date and effective_end_date
8496: and pil.per_in_ler_id=ben_pl_bnf_f.per_in_ler_id

Line 8511: ben_per_in_ler pil

8507: select pea.prtt_enrt_actn_id,
8508: pea.object_version_number
8509: from ben_prtt_enrt_actn_f pea,
8510: ben_actn_typ typ,
8511: ben_per_in_ler pil
8512: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8513: and pea.business_group_id = p_business_group_id
8514: and typ.type_cd <> 'BNF'
8515: and typ.type_cd like 'BNF%'

Line 8780: ben_per_in_ler pil

8776: cursor c_sum_bnf_pct is
8777: select prmry_cntngnt_cd cntgcd,
8778: sum(pct_dsgd_num) prcnt
8779: from ben_pl_bnf_f ,
8780: ben_per_in_ler pil
8781: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8782: and ben_pl_bnf_f.business_group_id = p_business_group_id
8783: and p_effective_date between
8784: ben_pl_bnf_f.effective_start_date and ben_pl_bnf_f.effective_end_date

Line 8832: ben_per_in_ler pil

8828: per_contact_relationships pcr,
8829: ben_pl_f pl,
8830: ben_pl_bnf_f plb,
8831: ben_prtt_enrt_rslt_f pen,
8832: ben_per_in_ler pil
8833: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8834: and pen.pl_id = pl.pl_id
8835: and pl.bnf_qdro_rl_apls_flag = 'Y'
8836: and pl.bnf_ctfn_rqd_flag = 'N' -- Flag is named incorrectly(opposite).

Line 8871: ben_per_in_ler pil

8867: hr_all_organization_units o,
8868: ben_pl_f pl,
8869: ben_pl_bnf_f plb,
8870: ben_prtt_enrt_rslt_f pen,
8871: ben_per_in_ler pil
8872: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8873: and pen.pl_id = pl.pl_id
8874: and pl.bnf_qdro_rl_apls_flag = 'Y'
8875: and pl.bnf_may_dsgt_org_flag = 'Y'