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

Line 1139: ben_per_in_ler pil

1135:
1136: cursor c_pct_ft is
1137: select bep.rt_pct_fl_tm_val
1138: from ben_elig_per_f bep,
1139: ben_per_in_ler pil
1140: where bep.person_id = p_person_id
1141: and nvl(bep.pgm_id,-1) = nvl(p_pgm_id,-1)
1142: and nvl(bep.pl_id,-1) = nvl(p_pl_id,-1)
1143: and p_effective_date

Line 1155: ben_per_in_ler pil

1151:
1152: cursor c_pct_ft_opt is
1153: select epo.rt_pct_fl_tm_val
1154: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
1155: ben_per_in_ler pil
1156: where bep.person_id = p_person_id
1157: and bep.elig_per_id = epo.elig_per_id
1158: and epo.opt_id = p_opt_id
1159: and nvl(bep.pgm_id,-1) = nvl(p_pgm_id,-1)

Line 1173: ben_per_in_ler pil

1169:
1170: cursor c_pct_ft_plip is
1171: select epo.rt_pct_fl_tm_val
1172: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
1173: ben_per_in_ler pil
1174: where bep.person_id = p_person_id
1175: and bep.elig_per_id = epo.elig_per_id
1176: and epo.opt_id = p_opt_id
1177: and nvl(bep.pgm_id,-1) = nvl(p_pgm_id,-1)

Line 1484: ben_per_in_ler pil

1480:
1481: cursor c_hrs_wkd is
1482: select bep.rt_hrs_wkd_val
1483: from ben_elig_per_f bep,
1484: ben_per_in_ler pil
1485: where bep.person_id = p_person_id
1486: and nvl(bep.pgm_id,-1) = nvl(p_pgm_id,-1)
1487: and nvl(bep.pl_id,-1) = nvl(p_pl_id,-1)
1488: and p_effective_date between bep.effective_start_date

Line 1498: ben_per_in_ler pil

1494:
1495: cursor c_hrs_wkd_opt is
1496: select epo.rt_hrs_wkd_val
1497: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
1498: ben_per_in_ler pil
1499: where bep.person_id = p_person_id
1500: and bep.elig_per_id = epo.elig_per_id
1501: and epo.opt_id = p_opt_id
1502: and nvl(bep.pgm_id,-1) = nvl(p_pgm_id,-1)

Line 1516: ben_per_in_ler pil

1512:
1513: cursor c_hrs_wkd_plip is
1514: select epo.rt_hrs_wkd_val
1515: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
1516: ben_per_in_ler pil
1517: where bep.person_id = p_person_id
1518: and bep.elig_per_id = epo.elig_per_id
1519: and epo.opt_id = p_opt_id
1520: and nvl(bep.pgm_id,-1) = nvl(p_pgm_id,-1)

Line 3804: ,ben_per_in_ler pil

3800: cursor c_get_quald_bnf is
3801: select cqb.*, crp.per_in_ler_id
3802: from ben_cbr_quald_bnf cqb
3803: ,ben_cbr_per_in_ler crp
3804: ,ben_per_in_ler pil
3805: where cqb.quald_bnf_person_id = p_person_id
3806: and cqb.quald_bnf_flag = 'Y'
3807: and nvl(p_lf_evt_ocrd_dt,p_effective_date)
3808: between cqb.cbr_elig_perd_strt_dt and

Line 3824: ,ben_per_in_ler pil

3820: cursor c_get_all_quald_bnf(p_cvrd_emp_person_id in number) is
3821: select cqb.*
3822: from ben_cbr_quald_bnf cqb
3823: ,ben_cbr_per_in_ler crp
3824: ,ben_per_in_ler pil
3825: where cqb.cvrd_emp_person_id = p_cvrd_emp_person_id
3826: and cqb.quald_bnf_flag = 'Y'
3827: and nvl(p_lf_evt_ocrd_dt,p_effective_date)
3828: between cqb.cbr_elig_perd_strt_dt and

Line 3844: , ben_per_in_ler pil

3840: cursor c_get_dsblity_evt(p_cbr_quald_bnf_id number) is
3841: select null
3842: from ben_cbr_per_in_ler crp
3843: , ben_ler_f ler
3844: , ben_per_in_ler pil
3845: where crp.cbr_quald_bnf_id = p_cbr_quald_bnf_id
3846: and crp.per_in_ler_id = pil.per_in_ler_id
3847: and pil.ler_id = ler.ler_id
3848: and ler.typ_cd = 'DSBLTY'

Line 3858: ,ben_per_in_ler pil2

3854: and ler.business_group_id = pil.business_group_id
3855: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
3856: and crp.cnt_num = (select max(cnt_num)
3857: from ben_cbr_per_in_ler crp2
3858: ,ben_per_in_ler pil2
3859: where crp2.cbr_quald_bnf_id = p_cbr_quald_bnf_id
3860: and crp2.per_in_ler_id = pil2.per_in_ler_id
3861: and pil2.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
3862: and crp2.business_group_id = p_business_group_id

Line 4387: ,ben_per_in_ler pil

4383: ,p_ptip_id in number) is
4384: select cqb.quald_bnf_flag
4385: from ben_cbr_quald_bnf cqb
4386: ,ben_cbr_per_in_ler crp
4387: ,ben_per_in_ler pil
4388: where cqb.quald_bnf_person_id = p_person_id
4389: and cqb.pgm_id = nvl(p_pgm_id,cqb.pgm_id)
4390: and nvl(cqb.ptip_id,-1) = nvl(p_ptip_id, -1)
4391: and p_lf_evt_ocrd_dt

Line 4946: ben_per_in_ler pil

4942: --
4943: cursor c1(p_pl_id in number) is
4944: select null
4945: from ben_elig_per_f epo,
4946: ben_per_in_ler pil
4947: where epo.person_id = p_person_id
4948: and epo.pl_id = p_pl_id
4949: and p_effective_date
4950: between epo.effective_start_date

Line 5104: ben_per_in_ler pil

5100: ben_ptip_f ctp,
5101: ben_pl_regn_f prg,
5102: ben_regn_f reg,
5103: ben_elig_per_f epo,
5104: ben_per_in_ler pil
5105: where pln.pl_id = cpp.pl_id
5106: and pln.business_group_id = c_business_group_id
5107: and c_effective_date
5108: between pln.effective_start_date

Line 5965: ben_per_in_ler pil

5961: ben_plip_f cpp,
5962: ben_ptip_f ctp,
5963: ben_elig_per_f epo,
5964: ben_elig_dpnt edp,
5965: ben_per_in_ler pil
5966: where pln.pl_id = cpp.pl_id
5967: and pln.business_group_id = c_bgp_id
5968: and c_eff_date
5969: between pln.effective_start_date and pln.effective_end_date

Line 5989: ,ben_per_in_ler pil2

5985: and epo.elig_flag = 'Y'
5986: and edp.dpnt_inelig_flag = 'N'
5987: and edp.create_dt = (select max(edp2.create_dt)
5988: from ben_elig_dpnt edp2
5989: ,ben_per_in_ler pil2
5990: where edp2.dpnt_person_id = edp.dpnt_person_id
5991: and edp2.elig_per_id = epo.elig_per_id
5992: and pil2.per_in_ler_id(+)=edp2.per_in_ler_id
5993: and pil2.business_group_id(+)=edp2.business_group_id

Line 7182: ben_per_in_ler pil

7178: epe.oiplip_id,
7179: pil.ler_id,
7180: pil.per_in_ler_id
7181: from ben_elig_per_elctbl_chc epe,
7182: ben_per_in_ler pil
7183: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
7184: and epe.per_in_ler_id = pil.per_in_ler_id;
7185: --
7186: l_epe c_epe%rowtype;