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

Line 111: ben_per_in_ler pil,

107: cursor c_dpnt_usage is
108: select ctu.cm_typ_usg_id,
109: ctu.cm_usg_rl
110: from ben_cm_typ_usg_f ctu,
111: ben_per_in_ler pil,
112: ben_elig_per_elctbl_chc epe
113: where pil.per_in_ler_id = p_per_in_ler_id
114: and pil.business_group_id = p_business_group_id
115: and ctu.business_group_id = pil.business_group_id

Line 163: ben_per_in_ler pil

159: --
160: cursor c_dpnt_always is
161: select null
162: from ben_elig_per_elctbl_chc epe,
163: ben_per_in_ler pil
164: where pil.per_in_ler_id = p_per_in_ler_id
165: and pil.business_group_id = p_business_group_id
166: and epe.business_group_id = pil.business_group_id
167: and epe.per_in_ler_id = pil.per_in_ler_id

Line 182: ben_per_in_ler pil,

178: cursor c_bnf_usage is
179: select ctu.cm_typ_usg_id,
180: ctu.cm_usg_rl
181: from ben_cm_typ_usg_f ctu,
182: ben_per_in_ler pil,
183: ben_elig_per_elctbl_chc epe
184: where pil.per_in_ler_id = p_per_in_ler_id
185: and pil.business_group_id = p_business_group_id
186: and ctu.business_group_id = pil.business_group_id

Line 242: ben_per_in_ler pil

238: --
239: cursor c_bnf_always is
240: select null
241: from ben_elig_per_elctbl_chc epe,
242: ben_per_in_ler pil
243: where pil.per_in_ler_id = p_per_in_ler_id
244: and pil.business_group_id = p_business_group_id
245: and epe.business_group_id = pil.business_group_id
246: and epe.per_in_ler_id = pil.per_in_ler_id

Line 1140: ben_per_in_ler pil

1136: and ctu.cm_typ_id = p_cm_typ_id
1137: and ctu.all_r_any_cd = 'ALL'
1138: and exists (select null
1139: from ben_pl_bnf_f pbn1,
1140: ben_per_in_ler pil
1141: where pbn1.bnf_person_id = p_rcpent_person_id
1142: and pbn1.business_group_id = pen.business_group_id
1143: and pbn1.effective_start_date = p_effective_date
1144: and pbn1.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id

Line 1164: ben_per_in_ler pil

1160: and pen.business_group_id = prv.business_group_id
1161: and pen.per_in_ler_id <> prv.per_in_ler_id
1162: and exists (select null
1163: from ben_pl_bnf_f pbn,
1164: ben_per_in_ler pil
1165: where pbn.bnf_person_id = p_rcpent_person_id
1166: and pbn.business_group_id = pen.business_group_id
1167: and pbn.effective_start_date = p_effective_date
1168: and pbn.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id

Line 1230: ben_per_in_ler pil

1226: and ctu.cm_typ_id = p_cm_typ_id
1227: and ctu.all_r_any_cd = 'ALL'
1228: and exists (select null
1229: from ben_elig_cvrd_dpnt_f pdp,
1230: ben_per_in_ler pil
1231: where pdp.dpnt_person_id = p_rcpent_person_id
1232: and pdp.business_group_id = pen.business_group_id
1233: and pdp.effective_start_date = p_effective_date
1234: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id

Line 1254: ben_per_in_ler pil

1250: and pen.business_group_id = prv.business_group_id
1251: and pen.per_in_ler_id <> prv.per_in_ler_id
1252: and exists (select null
1253: from ben_elig_cvrd_dpnt_f pdp,
1254: ben_per_in_ler pil
1255: where pdp.dpnt_person_id = p_rcpent_person_id
1256: and pdp.business_group_id = pen.business_group_id
1257: and pdp.effective_start_date = p_effective_date
1258: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id

Line 1541: ben_per_in_ler pil

1537: and ctu.all_r_any_cd = 'ALL'
1538: and pen.enrt_cvg_thru_dt < hr_api.g_eot
1539: and exists (select null
1540: from ben_pl_bnf_f pbn1,
1541: ben_per_in_ler pil
1542: where pbn1.bnf_person_id = p_rcpent_person_id
1543: and pbn1.business_group_id = pen.business_group_id
1544: and pbn1.effective_start_date = p_effective_date
1545: and pbn1.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id

Line 1560: ben_per_in_ler pil

1556: and pen.per_in_ler_id = p_per_in_ler_id
1557: and pen.enrt_cvg_thru_dt < hr_api.g_eot
1558: and exists (select null
1559: from ben_pl_bnf_f pbn,
1560: ben_per_in_ler pil
1561: where pbn.bnf_person_id = p_rcpent_person_id
1562: and pbn.business_group_id = pen.business_group_id
1563: and pbn.effective_start_date = p_effective_date
1564: and pbn.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id

Line 1620: ben_per_in_ler pil

1616: and ctu.all_r_any_cd = 'ALL'
1617: and pen.enrt_cvg_thru_dt < hr_api.g_eot
1618: and exists (select null
1619: from ben_elig_cvrd_dpnt_f pdp,
1620: ben_per_in_ler pil
1621: where pdp.dpnt_person_id = p_rcpent_person_id
1622: and pdp.business_group_id = pen.business_group_id
1623: and pdp.effective_start_date = p_effective_date
1624: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id

Line 1638: ben_per_in_ler pil

1634: and pen.per_in_ler_id = p_per_in_ler_id
1635: and pen.enrt_cvg_thru_dt < hr_api.g_eot
1636: and exists (select null
1637: from ben_elig_cvrd_dpnt_f pdp,
1638: ben_per_in_ler pil
1639: where pdp.dpnt_person_id = p_rcpent_person_id
1640: and pdp.business_group_id = pen.business_group_id
1641: and pdp.effective_start_date = p_effective_date
1642: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id

Line 1924: ben_per_in_ler pil

1920: --
1921: cursor c_bnf_always is
1922: select null
1923: from ben_prtt_enrt_rslt_f pen,
1924: ben_per_in_ler pil
1925: where pil.per_in_ler_id = p_per_in_ler_id
1926: and pil.business_group_id = p_business_group_id
1927: and pen.business_group_id = pil.business_group_id
1928: and pen.per_in_ler_id = pil.per_in_ler_id

Line 1985: ben_per_in_ler pil

1981: --
1982: cursor c_dpnt_always is
1983: select null
1984: from ben_prtt_enrt_rslt_f pen,
1985: ben_per_in_ler pil
1986: where pil.per_in_ler_id = p_per_in_ler_id
1987: and pil.business_group_id = p_business_group_id
1988: and pen.business_group_id = pil.business_group_id
1989: and pen.per_in_ler_id = pil.per_in_ler_id

Line 2259: ben_per_in_ler pil

2255: --
2256: cursor c_dpnt_always is
2257: select null
2258: from ben_elig_per_elctbl_chc epe,
2259: ben_per_in_ler pil
2260: where pil.per_in_ler_id = p_per_in_ler_id
2261: and pil.business_group_id = p_business_group_id
2262: and epe.business_group_id = pil.business_group_id
2263: and epe.per_in_ler_id = pil.per_in_ler_id

Line 2301: ben_per_in_ler pil

2297: --
2298: cursor c_bnf_always is
2299: select null
2300: from ben_elig_per_elctbl_chc epe,
2301: ben_per_in_ler pil
2302: where pil.per_in_ler_id = p_per_in_ler_id
2303: and pil.business_group_id = p_business_group_id
2304: and epe.business_group_id = pil.business_group_id
2305: and epe.per_in_ler_id = pil.per_in_ler_id

Line 4380: ben_per_in_ler pil,

4376: cursor c_epe is
4377: select 'Y'
4378: from ben_elig_dpnt egd,
4379: ben_elig_per_elctbl_chc epe,
4380: ben_per_in_ler pil,
4381: ben_pl_f pln,
4382: ben_oipl_f cop,
4383: ben_opt_f opt
4384: where epe.per_in_ler_id = p_per_in_ler_id

Line 4461: ben_per_in_ler pil

4457: ben_prtt_enrt_rslt_f pen,
4458: ben_pl_f pln,
4459: ben_oipl_f cop,
4460: ben_opt_f opt,
4461: ben_per_in_ler pil
4462: where pdp.cvg_thru_dt = hr_api.g_eot
4463: and pdp.dpnt_person_id = p_rcpent_person_id
4464: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
4465: -- and nvl(pen.pgm_id,-1) = nvl(l_pgm_id,-1) maagrawa(02/11/00)

Line 4501: ben_per_in_ler pil,

4497: cursor c_prtt_epe(v_pgm_id in number,
4498: v_pl_typ_id in number) is
4499: select 'Y'
4500: from ben_elig_per_elctbl_chc epe,
4501: ben_per_in_ler pil,
4502: ben_pl_f pln,
4503: ben_oipl_f cop,
4504: ben_opt_f opt
4505: where epe.per_in_ler_id = p_per_in_ler_id

Line 4869: l_pil_rec ben_per_in_ler%rowtype;

4865: l_proc varchar2(80) := g_package||'main';
4866: l_usages_created boolean := false;
4867: l_per_cm_id number;
4868: l_con_rec ben_person_object.g_cache_con_table;
4869: l_pil_rec ben_per_in_ler%rowtype;
4870: --
4871: -- Bug 6770385
4872: --
4873: CURSOR c_get_pil IS

Line 4876: FROM ben_per_in_ler pil, ben_ler_f ler

4872: --
4873: CURSOR c_get_pil IS
4874: --
4875: SELECT pil.*
4876: FROM ben_per_in_ler pil, ben_ler_f ler
4877: WHERE pil.person_id = p_person_id
4878: AND pil.business_group_id = p_business_group_id
4879: AND pil.per_in_ler_stat_cd = 'STRTD'
4880: AND ler.ler_id = pil.ler_id