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_COBRA_REQUIREMENTS dependencies on HR_API

Line 1174: and pen.enrt_cvg_thru_dt = hr_api.g_eot

1170: ---
1171: and
1172: ( (
1173: nvl(p_cvrd_today,'N') = 'N'
1174: and pen.enrt_cvg_thru_dt = hr_api.g_eot
1175: and pen.effective_end_date = hr_api.g_eot
1176: and p_effective_date between pen.effective_start_date
1177: and pen.effective_end_date
1178: ) OR

Line 1175: and pen.effective_end_date = hr_api.g_eot

1171: and
1172: ( (
1173: nvl(p_cvrd_today,'N') = 'N'
1174: and pen.enrt_cvg_thru_dt = hr_api.g_eot
1175: and pen.effective_end_date = hr_api.g_eot
1176: and p_effective_date between pen.effective_start_date
1177: and pen.effective_end_date
1178: ) OR
1179: (

Line 1181: AND pen.effective_end_date = hr_api.g_eot

1177: and pen.effective_end_date
1178: ) OR
1179: (
1180: nvl(p_cvrd_today,'N') = 'Y'
1181: AND pen.effective_end_date = hr_api.g_eot
1182: AND p_effective_date BETWEEN pen.enrt_cvg_strt_dt
1183: AND pen.enrt_cvg_thru_dt
1184: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
1185: )

Line 1219: and pdp.cvg_thru_dt = hr_api.g_eot

1215: ---
1216: and
1217: ( (
1218: nvl(p_cvrd_today,'N') = 'N'
1219: and pdp.cvg_thru_dt = hr_api.g_eot
1220: and pdp.cvg_thru_dt <= pdp.effective_end_date
1221: and p_effective_date between pdp.effective_start_date
1222: and pdp.effective_end_date
1223: ) OR

Line 1226: AND pdp.effective_end_date = hr_api.g_eot

1222: and pdp.effective_end_date
1223: ) OR
1224: (
1225: nvl(p_cvrd_today,'N') = 'Y'
1226: AND pdp.effective_end_date = hr_api.g_eot
1227: AND p_effective_date BETWEEN pdp.cvg_strt_dt
1228: AND pdp.cvg_thru_dt
1229: AND pdp.cvg_strt_dt < pdp.effective_end_date
1230: )

Line 1232: --and pen.effective_end_date = hr_api.g_eot

1228: AND pdp.cvg_thru_dt
1229: AND pdp.cvg_strt_dt < pdp.effective_end_date
1230: )
1231: )
1232: --and pen.effective_end_date = hr_api.g_eot
1233: and p_effective_date between pen.effective_start_date
1234: and pen.effective_end_date
1235: and pen.business_group_id = p_business_group_id
1236: and pdp.business_group_id = pen.business_group_id;

Line 1298: and pen.enrt_cvg_thru_dt <> hr_api.g_eot

1294: -- Bug 3368053: Remove ptip_id
1295: -- and pen.ptip_id = nvl(p_ptip_id,pen.ptip_id)
1296: and pen.prtt_enrt_rslt_stat_cd is null
1297: and nvl(pen.per_in_ler_id,-1) = nvl(p_per_in_ler_id, -1)
1298: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
1299: and pen.effective_end_date = hr_api.g_eot
1300: -- Bug 7116537, Commented the condition p_effective_date between effective_start_date and effective_end_date
1301: /*and p_effective_date between
1302: pen.effective_start_date and pen.effective_end_date*/

Line 1299: and pen.effective_end_date = hr_api.g_eot

1295: -- and pen.ptip_id = nvl(p_ptip_id,pen.ptip_id)
1296: and pen.prtt_enrt_rslt_stat_cd is null
1297: and nvl(pen.per_in_ler_id,-1) = nvl(p_per_in_ler_id, -1)
1298: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
1299: and pen.effective_end_date = hr_api.g_eot
1300: -- Bug 7116537, Commented the condition p_effective_date between effective_start_date and effective_end_date
1301: /*and p_effective_date between
1302: pen.effective_start_date and pen.effective_end_date*/
1303: and pen.business_group_id = p_business_group_id;

Line 1319: and pdp.cvg_thru_dt <> hr_api.g_eot

1315: -- and pen.ptip_id = nvl(p_ptip_id,pen.ptip_id)
1316: and p_effective_date between pen.effective_start_date
1317: and pen.effective_end_date
1318: and pen.business_group_id = p_business_group_id
1319: and pdp.cvg_thru_dt <> hr_api.g_eot
1320: and p_lf_evt_ocrd_dt >= pdp.cvg_strt_dt
1321: and pdp.effective_end_date = hr_api.g_eot
1322: and p_effective_date between pdp.effective_start_date
1323: and pdp.effective_end_date

Line 1321: and pdp.effective_end_date = hr_api.g_eot

1317: and pen.effective_end_date
1318: and pen.business_group_id = p_business_group_id
1319: and pdp.cvg_thru_dt <> hr_api.g_eot
1320: and p_lf_evt_ocrd_dt >= pdp.cvg_strt_dt
1321: and pdp.effective_end_date = hr_api.g_eot
1322: and p_effective_date between pdp.effective_start_date
1323: and pdp.effective_end_date
1324: and pdp.business_group_id = pen.business_group_id
1325: group by pdp.dpnt_person_id;

Line 1344: l_cvg_thru_dt := greatest(nvl(l_enrt_cvg_thru_dt, hr_api.g_sot)

1340: open c_get_dpnt_cvg_thru_dt;
1341: fetch c_get_dpnt_cvg_thru_dt into l_dpnt_cvg_thru_dt;
1342: close c_get_dpnt_cvg_thru_dt;
1343: --
1344: l_cvg_thru_dt := greatest(nvl(l_enrt_cvg_thru_dt, hr_api.g_sot)
1345: ,nvl(l_dpnt_cvg_thru_dt,hr_api.g_sot));
1346: return l_cvg_thru_dt;
1347: --
1348: end get_max_cvg_thru_dt;

Line 1345: ,nvl(l_dpnt_cvg_thru_dt,hr_api.g_sot));

1341: fetch c_get_dpnt_cvg_thru_dt into l_dpnt_cvg_thru_dt;
1342: close c_get_dpnt_cvg_thru_dt;
1343: --
1344: l_cvg_thru_dt := greatest(nvl(l_enrt_cvg_thru_dt, hr_api.g_sot)
1345: ,nvl(l_dpnt_cvg_thru_dt,hr_api.g_sot));
1346: return l_cvg_thru_dt;
1347: --
1348: end get_max_cvg_thru_dt;
1349: --

Line 1576: between nvl(ctr.date_start,hr_api.g_sot) and

1572: from per_contact_relationships ctr
1573: where ctr.person_id = p_person_id
1574: and ctr.contact_type = 'S'
1575: and p_lf_evt_ocrd_dt
1576: between nvl(ctr.date_start,hr_api.g_sot) and
1577: nvl(ctr.date_end,hr_api.g_eot)
1578: and ctr.business_group_id = p_business_group_id;
1579: --
1580: begin

Line 1577: nvl(ctr.date_end,hr_api.g_eot)

1573: where ctr.person_id = p_person_id
1574: and ctr.contact_type = 'S'
1575: and p_lf_evt_ocrd_dt
1576: between nvl(ctr.date_start,hr_api.g_sot) and
1577: nvl(ctr.date_end,hr_api.g_eot)
1578: and ctr.business_group_id = p_business_group_id;
1579: --
1580: begin
1581: --

Line 2160: and pdp.cvg_thru_dt <> hr_api.g_eot

2156: from ben_elig_cvrd_dpnt_f pdp
2157: where pdp.per_in_ler_id = p_per_in_ler_id
2158: and p_lf_evt_ocrd_dt
2159: between pdp.effective_start_date and pdp.effective_end_date
2160: and pdp.cvg_thru_dt <> hr_api.g_eot
2161: and pdp.business_group_id = p_business_group_id;
2162: --
2163: cursor c_chk_init_evt is
2164: select crp.*

Line 2230: if l_cbr_elig_perd_end_dt <> hr_api.g_sot then

2226: --
2227: -- Only set the COBRA eligibility end date if the person
2228: -- was previously covered.
2229: --
2230: if l_cbr_elig_perd_end_dt <> hr_api.g_sot then
2231: --
2232: update_cobra_info
2233: (p_per_in_ler_id => p_per_in_ler_id
2234: ,p_person_id => l_cqb_rec.quald_bnf_person_id

Line 2286: if l_cbr_elig_perd_end_dt <> hr_api.g_sot then

2282: ,p_business_group_id => p_business_group_id
2283: ,p_effective_date => p_effective_date
2284: );
2285: --
2286: if l_cbr_elig_perd_end_dt <> hr_api.g_sot then
2287: update_cobra_info
2288: (p_per_in_ler_id => p_per_in_ler_id
2289: ,p_person_id => l_cqb_rec.quald_bnf_person_id
2290: ,p_cbr_quald_bnf_id => l_cqb_rec.cbr_quald_bnf_id

Line 2327: ,p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2

2323: ,p_dsbld_apls in boolean default false
2324: ,p_lf_evt_ocrd_dt in date
2325: ,p_quald_bnf_flag in varchar2 default 'Y'
2326: ,p_cvrd_emp_person_id in number default null
2327: ,p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
2328: ,p_business_group_id in number
2329: ,p_effective_date in date
2330: ,p_pgm_id in number default null
2331: ,p_ptip_id in number default null

Line 2369: between nvl(ctr.date_start,hr_api.g_sot) and

2365: ,per_person_type_usages_f ptu
2366: ,per_person_types pet
2367: where ctr.contact_person_id = p_person_id
2368: and p_lf_evt_ocrd_dt
2369: between nvl(ctr.date_start,hr_api.g_sot) and
2370: nvl(ctr.date_end,hr_api.g_eot)
2371: and ctr.business_group_id = p_business_group_id
2372: and ctr.person_id = ptu.person_id
2373: and ptu.person_type_id = pet.person_type_id

Line 2370: nvl(ctr.date_end,hr_api.g_eot)

2366: ,per_person_types pet
2367: where ctr.contact_person_id = p_person_id
2368: and p_lf_evt_ocrd_dt
2369: between nvl(ctr.date_start,hr_api.g_sot) and
2370: nvl(ctr.date_end,hr_api.g_eot)
2371: and ctr.business_group_id = p_business_group_id
2372: and ctr.person_id = ptu.person_id
2373: and ptu.person_type_id = pet.person_type_id
2374: and l_effective_date between

Line 2658: if l_cbr_elig_perd_end_dt = hr_api.g_sot then

2654: -- If the cobra eligibility start date is the start of time (01/01/0001), set the
2655: -- qualified beneficiary flag to 'N' instead of updating the eligiblity end date.
2656: -- Bug 4486609
2657: --
2658: if l_cbr_elig_perd_end_dt = hr_api.g_sot then
2659: l_quald_bnf_flag := 'N';
2660: l_cbr_elig_perd_end_dt := p_old_cbr_elig_perd_end_dt;
2661: else
2662: l_quald_bnf_flag := p_quald_bnf_flag;

Line 2924: if l_cbr_elig_perd_end_dt = hr_api.g_sot then

2920: -- period end date is not equal to the cobra eligibility end date
2921: -- on the qualified beneficiary row.
2922: --
2923: if l_cqb_rec.cbr_elig_perd_end_dt <> l_cbr_elig_perd_end_dt then
2924: if l_cbr_elig_perd_end_dt = hr_api.g_sot then
2925: l_cqb_quald_bnf_flag := 'N';
2926: l_cbr_elig_perd_end_dt := l_cqb_rec.cbr_elig_perd_end_dt;
2927: end if;
2928: --

Line 2941: l_cbr_inelg_rsn_cd := hr_api.g_varchar2;

2937: ('DRVDLSELG', 'DRVDNLP','DRVDPOEELG',
2938: 'DRVDPOERT','DRVDVEC') then
2939: l_cbr_inelg_rsn_cd := 'PLE';
2940: else
2941: l_cbr_inelg_rsn_cd := hr_api.g_varchar2;
2942: end if;
2943: hr_utility.set_location('l_ler_typ: '||l_typ_cd, 10);
2944: end if;
2945: close c_get_ler_type;

Line 2981: ,p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2

2977: ,p_cqb_object_version_number in number
2978: ,p_quald_bnf_flag in varchar2 default 'Y'
2979: ,p_old_cbr_elig_perd_end_dt in date
2980: ,p_cbr_elig_perd_end_dt in date
2981: ,p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
2982: ,p_business_group_id in number
2983: ,p_effective_date in date
2984: ,p_validate in boolean default false) is
2985: --

Line 3277: AND pen.effective_end_date = hr_api.g_eot

3273: AND pen.pgm_id = c_pgm_id
3274: AND pen.business_group_id = c_business_group_id
3275: AND pen.prtt_enrt_rslt_stat_cd IS NULL
3276: AND pen.sspndd_flag = 'N'
3277: AND pen.effective_end_date = hr_api.g_eot
3278: AND pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
3279: AND pen.business_group_id = prv.business_group_id
3280: AND prv.prtt_rt_val_stat_cd IS NULL
3281: AND prv.acty_base_rt_id = c_acty_base_rt_id

Line 3760: AND pen.effective_end_date = hr_api.g_eot

3756: AND pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
3757: AND prv.business_group_id = pen.business_group_id
3758: AND prv.prtt_rt_val_stat_cd IS NULL
3759: AND prv.acty_typ_cd LIKE 'PBC%'
3760: AND pen.effective_end_date = hr_api.g_eot
3761: AND c_effective_date BETWEEN prv.rt_strt_dt and
3762: prv.rt_end_dt
3763: AND prv.acty_base_rt_id = abr.acty_base_rt_id
3764: AND abr.element_type_id +0 = c_element_type_id -- PERF FIX. Added +0

Line 3800: AND pen.effective_end_date = hr_api.g_eot

3796: AND pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
3797: AND prv.business_group_id = pen.business_group_id
3798: AND prv.prtt_rt_val_stat_cd IS NULL
3799: AND prv.acty_typ_cd LIKE 'PBC%'
3800: AND pen.effective_end_date = hr_api.g_eot
3801: AND c_effective_date BETWEEN prv.rt_strt_dt and
3802: prv.rt_end_dt
3803: AND prv.acty_base_rt_id = abr.acty_base_rt_id
3804: AND ((abr.element_type_id <> c_element_type_id) OR (abr.input_value_id <> c_input_value_id))

Line 3864: (NVL(l_oipl_id,hr_api.g_number) <> NVL(r_rates_other.oipl_id,hr_api.g_number))

3860: if l_prev_pymts < l_amt_due then
3861:
3862: if l_pl_id is null or
3863: ((l_pl_id <> r_rates_other.pl_id) or
3864: (NVL(l_oipl_id,hr_api.g_number) <> NVL(r_rates_other.oipl_id,hr_api.g_number))
3865: ) then
3866:
3867:
3868: l_pl_id := r_rates_other.pl_id;

Line 4272: AND pen.effective_end_date = hr_api.g_eot

4268: AND pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
4269: AND prv.business_group_id = pen.business_group_id
4270: AND prv.prtt_rt_val_stat_cd IS NULL
4271: AND prv.acty_typ_cd LIKE 'PBC%'
4272: AND pen.effective_end_date = hr_api.g_eot
4273: AND prv.rt_strt_dt >= c_effective_date
4274: AND prv.acty_base_rt_id = abr.acty_base_rt_id
4275: AND abr.element_type_id +0= c_element_type_id -- PERF FIX. Added +0
4276: AND abr.input_value_id +0= c_input_value_id -- PERF FIX. Added +0

Line 4308: AND pen.effective_end_date = hr_api.g_eot

4304: AND pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
4305: AND prv.business_group_id = pen.business_group_id
4306: AND prv.prtt_rt_val_stat_cd IS NULL
4307: AND prv.acty_typ_cd LIKE 'PBC%'
4308: AND pen.effective_end_date = hr_api.g_eot
4309: AND prv.acty_base_rt_id = abr.acty_base_rt_id
4310: AND abr.element_type_id = c_element_type_id
4311: AND abr.input_value_id = c_input_value_id
4312: AND prv.rt_strt_dt BETWEEN abr.effective_start_date