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

Line 182: and pen.enrt_cvg_thru_dt = hr_api.g_eot;

178: from ben_prtt_enrt_rslt_f pen
179: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
180: and pen.per_in_ler_id <> p_per_in_ler_id
181: and p_effective_date between pen.effective_start_date and pen.effective_end_date
182: and pen.enrt_cvg_thru_dt = hr_api.g_eot;
183:
184: l_current_epe_pen c_current_epe_pen%rowtype;
185:
186: --

Line 220: and lcnr.enrt_cvg_thru_dt = hr_api.g_eot

216: select lcnr.*
217: from BEN_LE_CLSN_N_RSTR lcnr
218: where lcnr.bkup_tbl_id = l_prtt_enrt_rslt_id
219: and lcnr.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_RSLT_F_CORR'
220: and lcnr.enrt_cvg_thru_dt = hr_api.g_eot
221: and lcnr.Per_in_ler_ended_id = l_per_in_ler_id;
222:
223: l_corr_pen_rec c_corr_result_exist%rowtype;
224: --

Line 318: l_mode := hr_api.g_future_change;

314: p_future_change => l_future_change,
315: p_delete_next_change => l_delete_next_change);
316:
317: if l_future_change then
318: l_mode := hr_api.g_future_change;
319: --
320: elsif l_delete_next_change then
321: --
322: l_mode := hr_api.g_delete_next_change;

Line 322: l_mode := hr_api.g_delete_next_change;

318: l_mode := hr_api.g_future_change;
319: --
320: elsif l_delete_next_change then
321: --
322: l_mode := hr_api.g_delete_next_change;
323:
324: end if;
325: hr_utility.set_location (' l_mode '||l_mode, 5);
326: l_delrec := l_imp_inc_enrt_tab_prior(l_imp_inc_enrt_tab_prior.first);

Line 332: l_mode := hr_api.g_zap;

328:
329: else
330: hr_utility.set_location('Else - no prior imputed enrollment exists ',6685);
331: l_delrec := l_imp_inc_enrt_tab(r);
332: l_mode := hr_api.g_zap;
333: end if;
334: --
335:
336:

Line 348: if l_mode = hr_api.g_zap then

344: --
345: l_object_version_number := l_delrec.object_version_number;
346:
347:
348: if l_mode = hr_api.g_zap then
349: -- check if corr pen rec exists, if yes no zap, just update the corr rec pil_id and ler_id
350: open c_corr_result_exist (l_imp_inc_enrt_tab(r).per_in_ler_id, l_imp_inc_enrt_tab(r).prtt_enrt_rslt_id);
351: fetch c_corr_result_exist into l_corr_pen_rec;
352:

Line 467: AND pen.effective_end_date=hr_api.g_eot

463: and pil.per_in_ler_stat_cd not in ('BCKDT','VOIDD')
464: and p_effective_date between pln.effective_start_date
465: and pln.effective_end_date
466: and prv.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
467: AND pen.effective_end_date=hr_api.g_eot
468: and l_max_le_eff_date >= least(pen.effective_start_date,pen.enrt_cvg_strt_dt )
469: and abr.acty_base_rt_id = prv.acty_base_rt_id
470: and abr.subj_to_imptd_incm_flag = 'Y'
471: and l_max_le_eff_date between abr.effective_start_date and abr.effective_end_date ;

Line 500: AND pen.effective_end_date=hr_api.g_eot

496: -- Bug # - 1675410 - If the coverage start date is after life event occurred date,
497: -- the above condition does not select result row. As much as per_in_ler_id is
498: -- existing in pen, it is better to join pil with pen by per_in_ler_id
499: and pil.per_in_ler_id = pen.per_in_ler_id
500: AND pen.effective_end_date=hr_api.g_eot
501: -- Bug 1884964 to restrict pen records from different set
502: and l_max_le_eff_date >= least(pen.effective_start_date,pen.enrt_cvg_strt_dt )
503: and exists
504: (select 'x'

Line 563: AND pen.effective_end_date=hr_api.g_eot

559: -- Bug # - 1675410 - If the coverage start date is after life event occurred date,
560: -- the above condition does not select result row. As much as per_in_ler_id is
561: -- existing in pen, it is better to join pil with pen by per_in_ler_id
562: and pil.per_in_ler_id = pen.per_in_ler_id
563: AND pen.effective_end_date=hr_api.g_eot
564: -- Bug 1884964 to restrict pen records from different set
565: and l_max_le_eff_date >= least(pen.effective_start_date,pen.enrt_cvg_strt_dt )
566: and p_cvg_strt_dt between pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt
567: and exists

Line 633: AND pen.effective_end_date=hr_api.g_eot;

629: pen.oipl_id is null and
630: pen.person_id = p_person_id
631: AND l_pil_rec.lf_evt_ocrd_dt between
632: pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt
633: AND pen.effective_end_date=hr_api.g_eot;
634: --
635: cursor c_imp_inc_plan2 (p_enrt_cvg_strt_dt date) is -- 8716870
636: select pen.prtt_enrt_rslt_id,
637: pen.object_version_number,

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

652: and pen.pl_id = pln.pl_id
653: and pen.oipl_id is null
654: and pen.person_id = p_person_id
655: /* 8716870 code changes */
656: -- and pen.effective_end_date = hr_api.g_eot
657: -- and pen.enrt_cvg_thru_dt = hr_api.g_eot;
658: and p_enrt_cvg_strt_dt between pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt
659: and pen.effective_end_date = hr_api.g_eot;
660: /* 8716870 code changes */

Line 657: -- and pen.enrt_cvg_thru_dt = hr_api.g_eot;

653: and pen.oipl_id is null
654: and pen.person_id = p_person_id
655: /* 8716870 code changes */
656: -- and pen.effective_end_date = hr_api.g_eot
657: -- and pen.enrt_cvg_thru_dt = hr_api.g_eot;
658: and p_enrt_cvg_strt_dt between pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt
659: and pen.effective_end_date = hr_api.g_eot;
660: /* 8716870 code changes */
661: --

Line 659: and pen.effective_end_date = hr_api.g_eot;

655: /* 8716870 code changes */
656: -- and pen.effective_end_date = hr_api.g_eot
657: -- and pen.enrt_cvg_thru_dt = hr_api.g_eot;
658: and p_enrt_cvg_strt_dt between pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt
659: and pen.effective_end_date = hr_api.g_eot;
660: /* 8716870 code changes */
661: --
662: cursor c_elctbl_chc(p_pl_id in number) is
663: select epe.ELIG_PER_ELCTBL_CHC_ID,

Line 696: and prv.rt_end_dt = hr_api.g_eot;

692: from ben_prtt_rt_val prv
693: where prv.business_group_id = p_business_group_id
694: and prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
695: and prv.prtt_rt_val_stat_cd is null
696: and prv.rt_end_dt = hr_api.g_eot;
697: --
698: cursor c_pgm_enrt_rslt_exists(p_pgm_id in number) is
699: select null
700: from ben_prtt_enrt_rslt_f pen,

Line 706: and pen.enrt_cvg_thru_dt = hr_api.g_eot

702: where pen.business_group_id = p_business_group_id
703: and pen.prtt_enrt_rslt_stat_cd is null
704: and pen.pgm_id = p_pgm_id
705: and pen.person_id = p_person_id
706: and pen.enrt_cvg_thru_dt = hr_api.g_eot
707: and pen.effective_end_date= hr_api.g_eot
708: and pln.pl_id = pen.pl_id
709: and pln.subj_to_imptd_incm_typ_cd =p_subj_to_imptd_incm_typ_cd
710: and pln.pl_stat_cd = 'A'

Line 707: and pen.effective_end_date= hr_api.g_eot

703: and pen.prtt_enrt_rslt_stat_cd is null
704: and pen.pgm_id = p_pgm_id
705: and pen.person_id = p_person_id
706: and pen.enrt_cvg_thru_dt = hr_api.g_eot
707: and pen.effective_end_date= hr_api.g_eot
708: and pln.pl_id = pen.pl_id
709: and pln.subj_to_imptd_incm_typ_cd =p_subj_to_imptd_incm_typ_cd
710: and pln.pl_stat_cd = 'A'
711: and pln.business_group_id = p_business_group_id

Line 1031: open c_post_tax_contrib(hr_api.g_eot) ;

1027:
1028: l_prflvalue := fnd_profile.value('BEN_IMPTD_INCM_POST_TAX');
1029: hr_utility.set_location('Profile:'||l_prflvalue, 99 );
1030: if l_prflvalue = 'Y' then
1031: open c_post_tax_contrib(hr_api.g_eot) ;
1032: Loop
1033: fetch c_post_tax_contrib into l_post_tax_rec ;
1034: exit when c_post_tax_contrib%notfound ;
1035: if l_post_tax_rec.tx_typ_cd = 'AFTERTAX'

Line 1601: p_datetrack_mode => hr_api.g_delete,

1597: p_object_version_number => l_enrt_rslt_rec.object_version_number,
1598: p_effective_start_date => l_effective_start_date,
1599: p_effective_end_date => l_effective_end_date,
1600: p_effective_date => l_eff_date_for_enrt, --8716870
1601: p_datetrack_mode => hr_api.g_delete,
1602: p_business_group_id => p_business_group_id,
1603: p_source => 'bendeimp',
1604: p_multi_row_validate => FALSE);
1605: --

Line 1673: --and pen.enrt_cvg_thru_dt = hr_api.g_eot

1669: and pen.person_id = pil.person_id
1670: and pen.prtt_enrt_rslt_stat_cd is NULL
1671: and p_effective_date between pl.effective_start_date and pl.effective_end_date
1672: /* Bug 13399004 : Commented the below two coniditons*/
1673: --and pen.enrt_cvg_thru_dt = hr_api.g_eot
1674: --and pen.effective_end_date = hr_api.g_eot
1675: -- and p_effective_date between pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt
1676: and pen.person_id = p_person_id
1677: --and pil.person_id = p_person_id

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

1670: and pen.prtt_enrt_rslt_stat_cd is NULL
1671: and p_effective_date between pl.effective_start_date and pl.effective_end_date
1672: /* Bug 13399004 : Commented the below two coniditons*/
1673: --and pen.enrt_cvg_thru_dt = hr_api.g_eot
1674: --and pen.effective_end_date = hr_api.g_eot
1675: -- and p_effective_date between pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt
1676: and pen.person_id = p_person_id
1677: --and pil.person_id = p_person_id
1678: and pil.per_in_ler_id = p_per_in_ler_id

Line 1699: and pen.enrt_cvg_thru_dt = hr_api.g_eot

1695: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
1696: and pen.prtt_enrt_rslt_stat_cd is NULL
1697: and p_effective_date between pl.effective_start_date and pl.effective_end_date
1698: -- and p_effective_date between pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt
1699: and pen.enrt_cvg_thru_dt = hr_api.g_eot
1700: and pen.effective_end_date = hr_api.g_eot
1701: and pen.person_id = pil.person_id
1702: and pen.person_id = p_person_id
1703: and epe.per_in_ler_id = p_per_in_ler_id

Line 1700: and pen.effective_end_date = hr_api.g_eot

1696: and pen.prtt_enrt_rslt_stat_cd is NULL
1697: and p_effective_date between pl.effective_start_date and pl.effective_end_date
1698: -- and p_effective_date between pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt
1699: and pen.enrt_cvg_thru_dt = hr_api.g_eot
1700: and pen.effective_end_date = hr_api.g_eot
1701: and pen.person_id = pil.person_id
1702: and pen.person_id = p_person_id
1703: and epe.per_in_ler_id = p_per_in_ler_id
1704: and pl.subj_to_imptd_incm_typ_cd is not null

Line 1727: and pen.enrt_cvg_thru_dt = hr_api.g_eot

1723: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
1724: and pen.person_id = pil.person_id
1725: and pen.prtt_enrt_rslt_stat_cd is NULL
1726: and p_effective_date between pl.effective_start_date and pl.effective_end_date
1727: and pen.enrt_cvg_thru_dt = hr_api.g_eot
1728: and pen.effective_end_date = hr_api.g_eot
1729: and pen.person_id = p_person_id
1730: and pil.person_id = p_person_id
1731: and pil.per_in_ler_id = p_per_in_ler_id

Line 1728: and pen.effective_end_date = hr_api.g_eot

1724: and pen.person_id = pil.person_id
1725: and pen.prtt_enrt_rslt_stat_cd is NULL
1726: and p_effective_date between pl.effective_start_date and pl.effective_end_date
1727: and pen.enrt_cvg_thru_dt = hr_api.g_eot
1728: and pen.effective_end_date = hr_api.g_eot
1729: and pen.person_id = p_person_id
1730: and pil.person_id = p_person_id
1731: and pil.per_in_ler_id = p_per_in_ler_id
1732: and pl.subj_to_imptd_incm_typ_cd = p_imptd_incm_typ_cd

Line 1772: and pen.effective_end_date = hr_api.g_eot

1768: and pen.prtt_enrt_rslt_stat_cd is null
1769: and pen.pl_id = pln.pl_id
1770: and pen.oipl_id is null
1771: and pen.person_id = p_person_id
1772: and pen.effective_end_date = hr_api.g_eot
1773: and pen.enrt_cvg_thru_dt = hr_api.g_eot;
1774: /*
1775: and p_enrt_cvg_strt_dt between pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt
1776: */

Line 1773: and pen.enrt_cvg_thru_dt = hr_api.g_eot;

1769: and pen.pl_id = pln.pl_id
1770: and pen.oipl_id is null
1771: and pen.person_id = p_person_id
1772: and pen.effective_end_date = hr_api.g_eot
1773: and pen.enrt_cvg_thru_dt = hr_api.g_eot;
1774: /*
1775: and p_enrt_cvg_strt_dt between pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt
1776: */
1777:

Line 1800: and pen.enrt_cvg_thru_dt = hr_api.g_eot

1796: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
1797: and pen.person_id = pil.person_id
1798: and pen.prtt_enrt_rslt_stat_cd is NULL
1799: and p_effective_date between pl.effective_start_date and pl.effective_end_date
1800: and pen.enrt_cvg_thru_dt = hr_api.g_eot
1801: and pen.effective_end_date = hr_api.g_eot
1802: -- and p_effective_date between pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt
1803: and pen.person_id = p_person_id
1804: -- and pil.per_in_ler_id = p_per_in_ler_id

Line 1801: and pen.effective_end_date = hr_api.g_eot

1797: and pen.person_id = pil.person_id
1798: and pen.prtt_enrt_rslt_stat_cd is NULL
1799: and p_effective_date between pl.effective_start_date and pl.effective_end_date
1800: and pen.enrt_cvg_thru_dt = hr_api.g_eot
1801: and pen.effective_end_date = hr_api.g_eot
1802: -- and p_effective_date between pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt
1803: and pen.person_id = p_person_id
1804: -- and pil.per_in_ler_id = p_per_in_ler_id
1805: and subj_to_imptd_incm_typ_cd = c_imp_inc_cd ; /* bug 12354818 */

Line 2003: p_datetrack_mode => hr_api.g_delete,

1999: p_object_version_number => l_imp_shell_enrt.object_version_number,
2000: p_effective_start_date => l_effective_start_date,
2001: p_effective_end_date => l_effective_end_date,
2002: p_effective_date => p_effective_date,
2003: p_datetrack_mode => hr_api.g_delete,
2004: p_business_group_id => p_business_group_id,
2005: p_source => 'bendeimp',
2006: p_multi_row_validate => FALSE);
2007: --

Line 2031: p_datetrack_mode => hr_api.g_delete,

2027: p_object_version_number => l_imp_shell_enrt.object_version_number,
2028: p_effective_start_date => l_effective_start_date,
2029: p_effective_end_date => l_effective_end_date,
2030: p_effective_date => p_effective_date,
2031: p_datetrack_mode => hr_api.g_delete,
2032: p_business_group_id => p_business_group_id,
2033: p_source => 'bendeimp',
2034: p_multi_row_validate => FALSE);
2035:

Line 2059: p_datetrack_mode => hr_api.g_delete,

2055: p_object_version_number => l_imp_shell_enrt.object_version_number,
2056: p_effective_start_date => l_effective_start_date,
2057: p_effective_end_date => l_effective_end_date,
2058: p_effective_date => p_effective_date,
2059: p_datetrack_mode => hr_api.g_delete,
2060: p_business_group_id => p_business_group_id,
2061: p_source => 'bendeimp',
2062: p_multi_row_validate => FALSE);
2063:

Line 2150: and pen.effective_end_date = hr_api.g_eot

2146: select 'Y'
2147: from ben_prtt_enrt_rslt_f pen, ben_pl_f pl
2148: where pen.person_id = p_person_id
2149: and pen.comp_lvl_cd = 'PLANIMP'
2150: and pen.effective_end_date = hr_api.g_eot
2151: and pen.prtt_enrt_rslt_stat_cd is null
2152: and pen.enrt_cvg_thru_dt = hr_api.g_eot
2153: and pen.pl_id = pl.pl_id
2154: and pl.imptd_incm_calc_cd = p_imptd_incm_calc_cd

Line 2152: and pen.enrt_cvg_thru_dt = hr_api.g_eot

2148: where pen.person_id = p_person_id
2149: and pen.comp_lvl_cd = 'PLANIMP'
2150: and pen.effective_end_date = hr_api.g_eot
2151: and pen.prtt_enrt_rslt_stat_cd is null
2152: and pen.enrt_cvg_thru_dt = hr_api.g_eot
2153: and pen.pl_id = pl.pl_id
2154: and pl.imptd_incm_calc_cd = p_imptd_incm_calc_cd
2155: and pl.pl_stat_cd = 'A'
2156: and pen.enrt_cvg_strt_dt between pl.effective_start_date and pl.effective_end_date