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

Line 176: from ben_per_cm_f pcm, ben_per_in_ler pil

172: ,c_comm_sdt date
173: )
174: is
175: select pcm.per_cm_id
176: from ben_per_cm_f pcm, ben_per_in_ler pil
177: -- if commu table has no ler id dont compare , pil_id take care
178: -- of validation # 3296015
179: where (pcm.ler_id is null or pcm.ler_id = c_ler_id)
180: and nvl(pcm.prtt_enrt_actn_id,-1) = nvl(c_pna_id,-1)

Line 1076: from ben_per_in_ler pil,

1072: -- Bug 11654610
1073:
1074: cursor c_prev_pil(c_per_in_ler_id number ) is
1075: select pil.per_in_ler_id
1076: from ben_per_in_ler pil,
1077: ben_ler_f ler
1078: where pil.per_in_ler_id not in (c_per_in_ler_id)
1079: and pil.person_id = p_person_id
1080: and pil.ler_id = ler.ler_id

Line 1094: select pil.per_in_ler_id from ben_per_in_ler pil,ben_ler_f le

1090:
1091:
1092: /* Added for Bug 8227214 */
1093: cursor c_get_per_in_ler(c_lf_evt_ocrd_dt date) is
1094: select pil.per_in_ler_id from ben_per_in_ler pil,ben_ler_f le
1095: where pil.lf_evt_ocrd_dt=c_lf_evt_ocrd_dt
1096: and pil.ler_id=le.ler_id
1097: and pil.person_id=p_person_id
1098: and c_lf_evt_ocrd_dt between le.effective_start_date and le.effective_end_date

Line 1120: ben_per_in_ler pil

1116: pep.pgm_id ppgm_id,
1117: pep.pl_id ppl_id
1118: from ben_cm_typ_usg_f ctu,
1119: ben_elig_per_f pep,
1120: ben_per_in_ler pil
1121: where ctu.business_group_id = p_business_group_id
1122: and pep.business_group_id = ctu.business_group_id
1123: and pep.person_id = p_person_id
1124: and pil.per_in_ler_id = l_per_in_ler_id -- Bug 8227214

Line 1185: FROM ben_elig_per_f pep2, ben_per_in_ler pil2

1181: and nvl(pil.per_in_ler_stat_cd,'-1') not in ('VOIDD','BCKDT')
1182: ---look for previous eligble
1183: and (( p_eligible_flag = 'Y'
1184: and not exists ( SELECT 'x'
1185: FROM ben_elig_per_f pep2, ben_per_in_ler pil2
1186: WHERE pep2.person_id = pep.person_id
1187: AND (ctu.pl_id is null or nvl(pep2.pl_id,-1) = nvl(pep.pl_id,-1) )
1188: AND (ctu.pgm_id is null or nvl(pep2.pgm_id,-1) = nvl(pep.pgm_id,-1) )
1189: --- pep ler id is not updated so pil ler id is validated # 2784972

Line 1222: FROM ben_elig_per_f pep2, ben_per_in_ler pil2

1218: --for previous life event and not eligible for the current LE. Added both exists clause for the bug fix
1219: OR
1220: ( p_eligible_flag = 'N'
1221: and exists ( SELECT 'x'
1222: FROM ben_elig_per_f pep2, ben_per_in_ler pil2
1223: WHERE pep2.person_id = pep.person_id
1224: AND (ctu.pl_id is null or nvl(pep2.pl_id,-1) = nvl(pep.pl_id,-1) )
1225: AND (ctu.pgm_id is null or nvl(pep2.pgm_id,-1) = nvl(pep.pgm_id,-1) )
1226: -- AND (ctu.ler_id is null or nvl(ctu.ler_id,-1) = nvl(pil2.ler_id,-1) )

Line 1250: FROM ben_elig_per_f pep2, ben_per_in_ler pil2

1246: ( 'VOIDD', 'BCKDT')
1247: OR pil2.per_in_ler_stat_cd IS NULL) --
1248: )
1249: and exists ( SELECT 'x'
1250: FROM ben_elig_per_f pep2, ben_per_in_ler pil2
1251: WHERE pep2.person_id = pep.person_id
1252: AND (ctu.pl_id is null or nvl(pep2.pl_id,-1) = nvl(pep.pl_id,-1) )
1253: AND (ctu.pgm_id is null or nvl(pep2.pgm_id,-1) = nvl(pep.pgm_id,-1) )
1254: AND (ctu.ler_id is null or nvl(ctu.ler_id,-1) = nvl(pil2.ler_id,-1) )

Line 1284: ben_per_in_ler pil

1280: --
1281: cursor c2(cv_effective_date date, cv_lf_evt_ocrd_dt date) is
1282: select null
1283: from ben_elig_per_f pep,
1284: ben_per_in_ler pil
1285: where pep.business_group_id = p_business_group_id
1286: and pep.person_id = p_person_id
1287: and nvl(get_cvg_strt_dt(pep.elig_per_id,pil.per_in_ler_id),cv_effective_date)
1288: between pep.effective_start_date and pep.effective_end_date

Line 1319: ben_per_in_ler pil,

1315: c_pl_typ_id number,
1316: cv_effective_date date) is
1317: select 'x'
1318: FROM ben_elig_per_f pep,
1319: ben_per_in_ler pil,
1320: ben_elig_dpnt egd
1321: WHERE egd.dpnt_person_id = p_person_id
1322: and egd.business_group_id = p_business_group_id
1323: and egd.elig_per_id = pep.elig_per_id

Line 1742: FROM ben_cm_typ_usg_f ctu, ben_per_in_ler pil

1738: )
1739: IS
1740: SELECT ctu.cm_typ_usg_id, ctu.cm_usg_rl, ctu.pl_id, ctu.pgm_id,
1741: ctu.pl_typ_id
1742: FROM ben_cm_typ_usg_f ctu, ben_per_in_ler pil
1743: WHERE ctu.business_group_id = c_bgp_id
1744: AND ctu.cm_typ_id = c_cm_typ_id
1745: AND ctu.all_r_any_cd = 'ALL'
1746: AND ( c_asnd_lf_evt_dt IS NULL

Line 1786: ben_per_in_ler pil,

1782: ctu.pl_id,
1783: ctu.pgm_id,
1784: ctu.pl_typ_id
1785: from ben_cm_typ_usg_f ctu,
1786: ben_per_in_ler pil,
1787: ben_elig_per_elctbl_chc epe
1788: where pil.per_in_ler_id = c_pil_id
1789: and pil.business_group_id = c_bgp_id
1790: and ctu.business_group_id = pil.business_group_id

Line 1818: ben_per_in_ler pil

1814: --
1815: cursor c2 is
1816: select null
1817: from ben_elig_per_elctbl_chc epe,
1818: ben_per_in_ler pil
1819: where pil.per_in_ler_id = p_per_in_ler_id
1820: and pil.business_group_id = p_business_group_id
1821: and epe.per_in_ler_id = pil.per_in_ler_id
1822: and epe.elctbl_flag = 'Y';

Line 2154: ben_per_in_ler pil

2150: ctu.pgm_id,
2151: ctu.pl_typ_id
2152: from ben_cm_typ_usg_f ctu,
2153: ben_prtt_enrt_rslt_f pen,
2154: ben_per_in_ler pil
2155: where ctu.business_group_id = p_business_group_id
2156: /* First join comp objects */
2157: and pen.business_group_id = ctu.business_group_id
2158: and pen.per_in_ler_id = p_per_in_ler_id

Line 2204: ben_per_in_ler pil

2200: --
2201: cursor c2 is
2202: select null
2203: from ben_prtt_enrt_rslt_f pen,
2204: ben_per_in_ler pil
2205: where pen.business_group_id = p_business_group_id
2206: and pen.per_in_ler_id = p_per_in_ler_id
2207: and pen.per_in_ler_id = pil.per_in_ler_id -- 5926672 join to pil
2208: and pen.enrt_cvg_thru_dt < hr_api.g_eot

Line 2387: ben_per_in_ler pil

2383: --
2384: cursor c2 is
2385: select null
2386: from ben_elig_per_elctbl_chc epe,
2387: ben_per_in_ler pil
2388: where pil.per_in_ler_id = p_per_in_ler_id
2389: and pil.business_group_id = p_business_group_id
2390: and epe.per_in_ler_id = pil.per_in_ler_id;
2391: --

Line 2541: ben_per_in_ler pil

2537: --
2538: cursor c2 is
2539: select null
2540: from ben_elig_per_elctbl_chc epe,
2541: ben_per_in_ler pil
2542: where pil.per_in_ler_id = p_per_in_ler_id
2543: and pil.business_group_id = p_business_group_id
2544: and epe.per_in_ler_id = pil.per_in_ler_id;
2545: --

Line 3781: ben_per_in_ler pil,

3777: cursor c_epe(v_pgm_id in number,
3778: v_pl_typ_id in number) is
3779: select 'Y'
3780: from ben_elig_per_elctbl_chc epe,
3781: ben_per_in_ler pil,
3782: ben_pl_f pln,
3783: ben_oipl_f cop,
3784: ben_opt_f opt
3785: where epe.per_in_ler_id = p_per_in_ler_id

Line 4530: l_pil_rec ben_per_in_ler%rowtype;

4526: l_proc varchar2(80) := g_package||'main';
4527: --
4528: l_ass_rec per_all_assignments_f%rowtype;
4529: l_pl_rec ben_pl_f%rowtype;
4530: l_pil_rec ben_per_in_ler%rowtype;
4531: l_loc_rec hr_locations_all%rowtype;
4532: l_effective_date date;
4533: --
4534: cursor c_triggers(p_eff_date date) is

Line 4592: from ben_per_in_ler pil ,

4588: --
4589: cursor c_pil (p_per_in_ler_id number ) is
4590: select pil.lf_evt_ocrd_dt,
4591: ler.typ_cd
4592: from ben_per_in_ler pil ,
4593: ben_ler_f ler
4594: where pil.per_in_ler_id = p_per_in_ler_id
4595: and ler.ler_id = pil.ler_id
4596: and p_effective_date between

Line 4604: FROM ben_per_in_ler pil, ben_ler_f ler

4600: --
4601: CURSOR c_get_pil IS
4602: --
4603: SELECT pil.*
4604: FROM ben_per_in_ler pil, ben_ler_f ler
4605: WHERE pil.person_id = p_person_id
4606: AND pil.per_in_ler_stat_cd = 'STRTD'
4607: AND ler.ler_id = pil.ler_id
4608: AND ler.ler_id = NVL (p_ler_id, pil.ler_id)