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 1192: and pen.enrt_cvg_thru_dt = hr_api.g_eot

1188: ---
1189: and
1190: ( (
1191: nvl(p_cvrd_today,'N') = 'N'
1192: and pen.enrt_cvg_thru_dt = hr_api.g_eot
1193: and pen.effective_end_date = hr_api.g_eot
1194: and p_effective_date between pen.effective_start_date
1195: and pen.effective_end_date
1196: ) OR

Line 1193: and pen.effective_end_date = hr_api.g_eot

1189: and
1190: ( (
1191: nvl(p_cvrd_today,'N') = 'N'
1192: and pen.enrt_cvg_thru_dt = hr_api.g_eot
1193: and pen.effective_end_date = hr_api.g_eot
1194: and p_effective_date between pen.effective_start_date
1195: and pen.effective_end_date
1196: ) OR
1197: (

Line 1199: AND pen.effective_end_date = hr_api.g_eot

1195: and pen.effective_end_date
1196: ) OR
1197: (
1198: nvl(p_cvrd_today,'N') = 'Y'
1199: AND pen.effective_end_date = hr_api.g_eot
1200: AND p_effective_date BETWEEN pen.enrt_cvg_strt_dt
1201: AND pen.enrt_cvg_thru_dt
1202: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
1203: )

Line 1237: and pdp.cvg_thru_dt = hr_api.g_eot

1233: ---
1234: and
1235: ( (
1236: nvl(p_cvrd_today,'N') = 'N'
1237: and pdp.cvg_thru_dt = hr_api.g_eot
1238: and pdp.cvg_thru_dt <= pdp.effective_end_date
1239: and p_effective_date between pdp.effective_start_date
1240: and pdp.effective_end_date
1241: ) OR

Line 1244: AND pdp.effective_end_date = hr_api.g_eot

1240: and pdp.effective_end_date
1241: ) OR
1242: (
1243: nvl(p_cvrd_today,'N') = 'Y'
1244: AND pdp.effective_end_date = hr_api.g_eot
1245: AND p_effective_date BETWEEN pdp.cvg_strt_dt
1246: AND pdp.cvg_thru_dt
1247: AND pdp.cvg_strt_dt < pdp.effective_end_date
1248: )

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

1246: AND pdp.cvg_thru_dt
1247: AND pdp.cvg_strt_dt < pdp.effective_end_date
1248: )
1249: )
1250: --and pen.effective_end_date = hr_api.g_eot
1251: and p_effective_date between pen.effective_start_date
1252: and pen.effective_end_date
1253: and pen.business_group_id = p_business_group_id
1254: and pdp.business_group_id = pen.business_group_id;

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

1312: -- Bug 3368053: Remove ptip_id
1313: -- and pen.ptip_id = nvl(p_ptip_id,pen.ptip_id)
1314: and pen.prtt_enrt_rslt_stat_cd is null
1315: and nvl(pen.per_in_ler_id,-1) = nvl(p_per_in_ler_id, -1)
1316: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
1317: and pen.effective_end_date = hr_api.g_eot
1318: -- Bug 7116537, Commented the condition p_effective_date between effective_start_date and effective_end_date
1319: /*and p_effective_date between
1320: pen.effective_start_date and pen.effective_end_date*/

Line 1317: and pen.effective_end_date = hr_api.g_eot

1313: -- and pen.ptip_id = nvl(p_ptip_id,pen.ptip_id)
1314: and pen.prtt_enrt_rslt_stat_cd is null
1315: and nvl(pen.per_in_ler_id,-1) = nvl(p_per_in_ler_id, -1)
1316: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
1317: and pen.effective_end_date = hr_api.g_eot
1318: -- Bug 7116537, Commented the condition p_effective_date between effective_start_date and effective_end_date
1319: /*and p_effective_date between
1320: pen.effective_start_date and pen.effective_end_date*/
1321: and pen.business_group_id = p_business_group_id;

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

1333: -- and pen.ptip_id = nvl(p_ptip_id,pen.ptip_id)
1334: and p_effective_date between pen.effective_start_date
1335: and pen.effective_end_date
1336: and pen.business_group_id = p_business_group_id
1337: and pdp.cvg_thru_dt <> hr_api.g_eot
1338: and p_lf_evt_ocrd_dt >= pdp.cvg_strt_dt
1339: and pdp.effective_end_date = hr_api.g_eot
1340: and p_effective_date between pdp.effective_start_date
1341: and pdp.effective_end_date

Line 1339: and pdp.effective_end_date = hr_api.g_eot

1335: and pen.effective_end_date
1336: and pen.business_group_id = p_business_group_id
1337: and pdp.cvg_thru_dt <> hr_api.g_eot
1338: and p_lf_evt_ocrd_dt >= pdp.cvg_strt_dt
1339: and pdp.effective_end_date = hr_api.g_eot
1340: and p_effective_date between pdp.effective_start_date
1341: and pdp.effective_end_date
1342: and pdp.business_group_id = pen.business_group_id
1343: group by pdp.dpnt_person_id;

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

1358: open c_get_dpnt_cvg_thru_dt;
1359: fetch c_get_dpnt_cvg_thru_dt into l_dpnt_cvg_thru_dt;
1360: close c_get_dpnt_cvg_thru_dt;
1361: --
1362: l_cvg_thru_dt := greatest(nvl(l_enrt_cvg_thru_dt, hr_api.g_sot)
1363: ,nvl(l_dpnt_cvg_thru_dt,hr_api.g_sot));
1364: return l_cvg_thru_dt;
1365: --
1366: end get_max_cvg_thru_dt;

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

1359: fetch c_get_dpnt_cvg_thru_dt into l_dpnt_cvg_thru_dt;
1360: close c_get_dpnt_cvg_thru_dt;
1361: --
1362: l_cvg_thru_dt := greatest(nvl(l_enrt_cvg_thru_dt, hr_api.g_sot)
1363: ,nvl(l_dpnt_cvg_thru_dt,hr_api.g_sot));
1364: return l_cvg_thru_dt;
1365: --
1366: end get_max_cvg_thru_dt;
1367: --

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

1658: from per_contact_relationships ctr
1659: where ctr.person_id = p_person_id
1660: and ctr.contact_type = 'S'
1661: and p_lf_evt_ocrd_dt
1662: between nvl(ctr.date_start,hr_api.g_sot) and
1663: nvl(ctr.date_end,hr_api.g_eot)
1664: and ctr.business_group_id = p_business_group_id;
1665: --
1666: begin

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

1659: where ctr.person_id = p_person_id
1660: and ctr.contact_type = 'S'
1661: and p_lf_evt_ocrd_dt
1662: between nvl(ctr.date_start,hr_api.g_sot) and
1663: nvl(ctr.date_end,hr_api.g_eot)
1664: and ctr.business_group_id = p_business_group_id;
1665: --
1666: begin
1667: --

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

2312: from ben_elig_cvrd_dpnt_f pdp
2313: where pdp.per_in_ler_id = p_per_in_ler_id
2314: and p_lf_evt_ocrd_dt
2315: between pdp.effective_start_date and pdp.effective_end_date
2316: and pdp.cvg_thru_dt <> hr_api.g_eot
2317: and pdp.business_group_id = p_business_group_id;
2318: --
2319: cursor c_chk_init_evt is
2320: select crp.*

Line 2397: if l_cbr_elig_perd_end_dt <> hr_api.g_sot then

2393: --
2394: -- Only set the COBRA eligibility end date if the person
2395: -- was previously covered.
2396: --
2397: if l_cbr_elig_perd_end_dt <> hr_api.g_sot then
2398: --
2399: update_cobra_info
2400: (p_per_in_ler_id => p_per_in_ler_id
2401: ,p_person_id => l_cqb_rec.quald_bnf_person_id

Line 2462: if l_cbr_elig_perd_end_dt <> hr_api.g_sot then

2458: ,p_business_group_id => p_business_group_id
2459: ,p_effective_date => p_effective_date
2460: );
2461: --
2462: if l_cbr_elig_perd_end_dt <> hr_api.g_sot then
2463: update_cobra_info
2464: (p_per_in_ler_id => p_per_in_ler_id
2465: ,p_person_id => l_cqb_rec.quald_bnf_person_id
2466: ,p_cbr_quald_bnf_id => l_cqb_rec.cbr_quald_bnf_id

Line 2507: ,p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2

2503: ,p_dsbld_apls in boolean default false
2504: ,p_lf_evt_ocrd_dt in date
2505: ,p_quald_bnf_flag in varchar2 default 'Y'
2506: ,p_cvrd_emp_person_id in number default null
2507: ,p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
2508: ,p_business_group_id in number
2509: ,p_effective_date in date
2510: ,p_pgm_id in number default null
2511: ,p_ptip_id in number default null

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

2545: ,per_person_type_usages_f ptu
2546: ,per_person_types pet
2547: where ctr.contact_person_id = p_person_id
2548: and p_lf_evt_ocrd_dt
2549: between nvl(ctr.date_start,hr_api.g_sot) and
2550: nvl(ctr.date_end,hr_api.g_eot)
2551: and ctr.business_group_id = p_business_group_id
2552: and ctr.person_id = ptu.person_id
2553: and ptu.person_type_id = pet.person_type_id

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

2546: ,per_person_types pet
2547: where ctr.contact_person_id = p_person_id
2548: and p_lf_evt_ocrd_dt
2549: between nvl(ctr.date_start,hr_api.g_sot) and
2550: nvl(ctr.date_end,hr_api.g_eot)
2551: and ctr.business_group_id = p_business_group_id
2552: and ctr.person_id = ptu.person_id
2553: and ptu.person_type_id = pet.person_type_id
2554: and l_effective_date between

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

2691: select ctr.person_id
2692: from per_contact_relationships ctr
2693: where ctr.contact_person_id = p_person_id
2694: and p_lf_evt_ocrd_dt
2695: between nvl(ctr.date_start,hr_api.g_sot) and
2696: nvl(ctr.date_end,hr_api.g_eot)
2697: and ctr.business_group_id = p_business_group_id;
2698: --
2699: -- End 9690964

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

2692: from per_contact_relationships ctr
2693: where ctr.contact_person_id = p_person_id
2694: and p_lf_evt_ocrd_dt
2695: between nvl(ctr.date_start,hr_api.g_sot) and
2696: nvl(ctr.date_end,hr_api.g_eot)
2697: and ctr.business_group_id = p_business_group_id;
2698: --
2699: -- End 9690964
2700: --

Line 2927: if l_cbr_elig_perd_end_dt = hr_api.g_sot then

2923: -- If the cobra eligibility start date is the start of time (01/01/0001), set the
2924: -- qualified beneficiary flag to 'N' instead of updating the eligiblity end date.
2925: -- Bug 4486609
2926: --
2927: if l_cbr_elig_perd_end_dt = hr_api.g_sot then
2928: l_quald_bnf_flag := 'N';
2929: l_cbr_elig_perd_end_dt := p_old_cbr_elig_perd_end_dt;
2930: else
2931: l_quald_bnf_flag := p_quald_bnf_flag;

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

3145: from ben_elig_cvrd_dpnt_f pdp
3146: where pdp.per_in_ler_id = p_per_in_ler_id
3147: and l_lf_evt_ocrd_dt
3148: between pdp.effective_start_date and pdp.effective_end_date
3149: and pdp.cvg_thru_dt <> hr_api.g_eot
3150: and pdp.business_group_id = p_business_group_id;
3151: --
3152: -- end 12386329
3153: --

Line 3227: if l_cbr_elig_perd_end_dt = hr_api.g_sot then

3223: -- period end date is not equal to the cobra eligibility end date
3224: -- on the qualified beneficiary row.
3225: --
3226: if l_cqb_rec.cbr_elig_perd_end_dt <> l_cbr_elig_perd_end_dt then
3227: if l_cbr_elig_perd_end_dt = hr_api.g_sot then
3228: l_cqb_quald_bnf_flag := 'N';
3229: l_cbr_elig_perd_end_dt := l_cqb_rec.cbr_elig_perd_end_dt;
3230: end if;
3231: --

Line 3244: l_cbr_inelg_rsn_cd := hr_api.g_varchar2;

3240: ('DRVDLSELG', 'DRVDNLP','DRVDPOEELG',
3241: 'DRVDPOERT','DRVDVEC') then
3242: l_cbr_inelg_rsn_cd := 'PLE';
3243: else
3244: l_cbr_inelg_rsn_cd := hr_api.g_varchar2;
3245: end if;
3246: hr_utility.set_location('l_ler_typ: '||l_typ_cd, 10);
3247: end if;
3248: close c_get_ler_type;

Line 3297: if l_cbr_elig_perd_end_dt <> hr_api.g_sot then

3293: ,p_business_group_id => p_business_group_id
3294: ,p_effective_date => p_effective_date
3295: );
3296: --
3297: if l_cbr_elig_perd_end_dt <> hr_api.g_sot then
3298: update_cobra_info
3299: (p_per_in_ler_id => p_per_in_ler_id
3300: ,p_person_id => l_dpnt_cqb_rec.quald_bnf_person_id
3301: ,p_cbr_quald_bnf_id => l_dpnt_cqb_rec.cbr_quald_bnf_id

Line 3340: ,p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2

3336: ,p_cqb_object_version_number in number
3337: ,p_quald_bnf_flag in varchar2 default 'Y'
3338: ,p_old_cbr_elig_perd_end_dt in date
3339: ,p_cbr_elig_perd_end_dt in date
3340: ,p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
3341: ,p_business_group_id in number
3342: ,p_effective_date in date
3343: ,p_validate in boolean default false) is
3344: --

Line 3636: AND pen.effective_end_date = hr_api.g_eot

3632: AND pen.pgm_id = c_pgm_id
3633: AND pen.business_group_id = c_business_group_id
3634: AND pen.prtt_enrt_rslt_stat_cd IS NULL
3635: AND pen.sspndd_flag = 'N'
3636: AND pen.effective_end_date = hr_api.g_eot
3637: AND pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
3638: AND pen.business_group_id = prv.business_group_id
3639: AND prv.prtt_rt_val_stat_cd IS NULL
3640: AND prv.acty_base_rt_id = c_acty_base_rt_id

Line 4119: AND pen.effective_end_date = hr_api.g_eot

4115: AND pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
4116: AND prv.business_group_id = pen.business_group_id
4117: AND prv.prtt_rt_val_stat_cd IS NULL
4118: AND prv.acty_typ_cd LIKE 'PBC%'
4119: AND pen.effective_end_date = hr_api.g_eot
4120: AND c_effective_date BETWEEN prv.rt_strt_dt and
4121: prv.rt_end_dt
4122: AND prv.acty_base_rt_id = abr.acty_base_rt_id
4123: AND abr.element_type_id +0 = c_element_type_id -- PERF FIX. Added +0

Line 4159: AND pen.effective_end_date = hr_api.g_eot

4155: AND pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
4156: AND prv.business_group_id = pen.business_group_id
4157: AND prv.prtt_rt_val_stat_cd IS NULL
4158: AND prv.acty_typ_cd LIKE 'PBC%'
4159: AND pen.effective_end_date = hr_api.g_eot
4160: AND c_effective_date BETWEEN prv.rt_strt_dt and
4161: prv.rt_end_dt
4162: AND prv.acty_base_rt_id = abr.acty_base_rt_id
4163: AND ((abr.element_type_id <> c_element_type_id) OR (abr.input_value_id <> c_input_value_id))

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

4219: if l_prev_pymts < l_amt_due then
4220:
4221: if l_pl_id is null or
4222: ((l_pl_id <> r_rates_other.pl_id) or
4223: (NVL(l_oipl_id,hr_api.g_number) <> NVL(r_rates_other.oipl_id,hr_api.g_number))
4224: ) then
4225:
4226:
4227: l_pl_id := r_rates_other.pl_id;

Line 4631: AND pen.effective_end_date = hr_api.g_eot

4627: AND pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
4628: AND prv.business_group_id = pen.business_group_id
4629: AND prv.prtt_rt_val_stat_cd IS NULL
4630: AND prv.acty_typ_cd LIKE 'PBC%'
4631: AND pen.effective_end_date = hr_api.g_eot
4632: AND prv.rt_strt_dt >= c_effective_date
4633: AND prv.acty_base_rt_id = abr.acty_base_rt_id
4634: AND abr.element_type_id +0= c_element_type_id -- PERF FIX. Added +0
4635: AND abr.input_value_id +0= c_input_value_id -- PERF FIX. Added +0

Line 4667: AND pen.effective_end_date = hr_api.g_eot

4663: AND pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
4664: AND prv.business_group_id = pen.business_group_id
4665: AND prv.prtt_rt_val_stat_cd IS NULL
4666: AND prv.acty_typ_cd LIKE 'PBC%'
4667: AND pen.effective_end_date = hr_api.g_eot
4668: AND prv.acty_base_rt_id = abr.acty_base_rt_id
4669: AND abr.element_type_id = c_element_type_id
4670: AND abr.input_value_id = c_input_value_id
4671: AND prv.rt_strt_dt BETWEEN abr.effective_start_date