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

Line 386: (pen.enrt_ovridn_flag = 'Y' and nvl(pen.enrt_ovrid_thru_dt,hr_api.g_eot) < l_effective_date ))

382: where pen.prtt_enrt_rslt_id = l_epe.prtt_enrt_rslt_id
383: and pen.person_id = p_person_id
384: and pen.sspndd_flag = 'N'
385: and ( (pen.enrt_ovridn_flag = 'N' ) OR
386: (pen.enrt_ovridn_flag = 'Y' and nvl(pen.enrt_ovrid_thru_dt,hr_api.g_eot) < l_effective_date ))
387: and pen.enrt_cvg_thru_dt = hr_api.g_eot
388: and pen.prtt_enrt_rslt_stat_cd is null
389: and l_effective_date -- Bug 3044116 p_effective_date
390: between pen.effective_start_date and pen.effective_end_date

Line 387: and pen.enrt_cvg_thru_dt = hr_api.g_eot

383: and pen.person_id = p_person_id
384: and pen.sspndd_flag = 'N'
385: and ( (pen.enrt_ovridn_flag = 'N' ) OR
386: (pen.enrt_ovridn_flag = 'Y' and nvl(pen.enrt_ovrid_thru_dt,hr_api.g_eot) < l_effective_date ))
387: and pen.enrt_cvg_thru_dt = hr_api.g_eot
388: and pen.prtt_enrt_rslt_stat_cd is null
389: and l_effective_date -- Bug 3044116 p_effective_date
390: between pen.effective_start_date and pen.effective_end_date
391: --bug#3856424 - check for any deenrollment in future - defensive coding

Line 394: and pen2.enrt_cvg_thru_dt = hr_api.g_eot

390: between pen.effective_start_date and pen.effective_end_date
391: --bug#3856424 - check for any deenrollment in future - defensive coding
392: and exists (select null from ben_prtt_enrt_rslt_f pen2
393: where pen2.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
394: and pen2.enrt_cvg_thru_dt = hr_api.g_eot
395: and pen2.effective_end_date = hr_api.g_eot)
396: and not exists ( select 'x' from ben_prtt_enrt_rslt_f pen3 --Bug 5617091 exclude interim results
397: where pen3.rplcs_sspndd_rslt_id= pen.prtt_enrt_rslt_id
398: and pen3.sspndd_flag = 'Y'

Line 395: and pen2.effective_end_date = hr_api.g_eot)

391: --bug#3856424 - check for any deenrollment in future - defensive coding
392: and exists (select null from ben_prtt_enrt_rslt_f pen2
393: where pen2.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
394: and pen2.enrt_cvg_thru_dt = hr_api.g_eot
395: and pen2.effective_end_date = hr_api.g_eot)
396: and not exists ( select 'x' from ben_prtt_enrt_rslt_f pen3 --Bug 5617091 exclude interim results
397: where pen3.rplcs_sspndd_rslt_id= pen.prtt_enrt_rslt_id
398: and pen3.sspndd_flag = 'Y'
399: and pen3.prtt_enrt_rslt_stat_cd is null

Line 400: and pen3.enrt_cvg_thru_dt = hr_api.g_eot

396: and not exists ( select 'x' from ben_prtt_enrt_rslt_f pen3 --Bug 5617091 exclude interim results
397: where pen3.rplcs_sspndd_rslt_id= pen.prtt_enrt_rslt_id
398: and pen3.sspndd_flag = 'Y'
399: and pen3.prtt_enrt_rslt_stat_cd is null
400: and pen3.enrt_cvg_thru_dt = hr_api.g_eot
401: and pen3.effective_end_date = hr_api.g_eot)
402: ;
403: --
404: l_pen c_pen%rowtype;

Line 401: and pen3.effective_end_date = hr_api.g_eot)

397: where pen3.rplcs_sspndd_rslt_id= pen.prtt_enrt_rslt_id
398: and pen3.sspndd_flag = 'Y'
399: and pen3.prtt_enrt_rslt_stat_cd is null
400: and pen3.enrt_cvg_thru_dt = hr_api.g_eot
401: and pen3.effective_end_date = hr_api.g_eot)
402: ;
403: --
404: l_pen c_pen%rowtype;
405: --

Line 542: prv.rt_end_dt = hr_api.g_eot))

538: and prv.acty_base_rt_id = v_acty_base_rt_id
539: and ((v_rt_strt_dt is not null and
540: v_rt_strt_dt between prv.rt_strt_dt and prv.rt_end_dt) or
541: (v_rt_strt_dt is null and
542: prv.rt_end_dt = hr_api.g_eot))
543: and prv.prtt_rt_val_stat_cd is null;
544: --
545: l_prv c_prv%rowtype;
546: --

Line 1063: p_datetrack_mode => hr_api.g_update,

1059: p_pen_attribute27 => l_pen.pen_attribute27,
1060: p_pen_attribute28 => l_pen.pen_attribute28,
1061: p_pen_attribute29 => l_pen.pen_attribute29,
1062: p_pen_attribute30 => l_pen.pen_attribute30,
1063: p_datetrack_mode => hr_api.g_update,
1064: p_suspend_flag => l_dummy_char,
1065: p_effective_start_date => l_dummy_date,
1066: p_effective_end_date => l_dummy_date,
1067: p_object_version_number => l_pen.object_version_number,

Line 1223: (l_prv.rt_ovridn_flag= 'Y' and nvl(l_prv.rt_ovridn_thru_dt,hr_api.g_eot)< l_rt_strt_dt ))) then

1219: --don't need to recompute the rates.
1220: --
1221: if (( l_prv_found and nvl(l_prv.rt_val,0) = nvl(l_ecr.val,0)) AND
1222: (l_prv.rt_ovridn_flag = 'N' OR
1223: (l_prv.rt_ovridn_flag= 'Y' and nvl(l_prv.rt_ovridn_thru_dt,hr_api.g_eot)< l_rt_strt_dt ))) then
1224: --
1225: -- get old element info
1226: --
1227: l_element_info := null;

Line 1359: nvl(l_prv.rt_ovridn_thru_dt,hr_api.g_eot)< l_rt_strt_dt))))

1355: if ((l_rt_strt_dt >= nvl(l_prv_min_strt_dt,l_rt_strt_dt)) and
1356: ((NOT l_prv_found) OR
1357: (l_prv.rt_ovridn_flag = 'N' OR
1358: (l_prv.rt_ovridn_flag= 'Y' and
1359: nvl(l_prv.rt_ovridn_thru_dt,hr_api.g_eot)< l_rt_strt_dt))))
1360: then
1361: --
1362: /* Bug 3394862 We need to modify this if clause such that
1363: l_entr_val_at_enrt_flag is checked only

Line 1404: ,p_datetrack_mode => hr_api.g_update

1400: ,p_rt_val => l_ecr.val
1401: ,p_ann_rt_val => l_ecr.ann_val
1402: ,p_enrt_cvg_strt_dt => l_pen.enrt_cvg_strt_dt
1403: ,p_acty_ref_perd_cd => l_epe.acty_ref_perd_cd
1404: ,p_datetrack_mode => hr_api.g_update
1405: ,p_business_group_id => p_business_group_id
1406: ,p_bnft_amt_changed => l_bnft_changed
1407: ,p_ele_changed => l_element_changed
1408: ,p_prv_rt_val => l_dummy_number

Line 1692: l_ppe_datetrack_mode := hr_api.g_update_override;

1688: p_update_override => l_update_override,
1689: p_update_change_insert => l_update_change_insert);
1690:
1691: if l_update_override then
1692: l_ppe_datetrack_mode := hr_api.g_update_override;
1693: elsif l_update then
1694: l_ppe_datetrack_mode := hr_api.g_update;
1695: else
1696: l_ppe_datetrack_mode := hr_api.g_correction;

Line 1694: l_ppe_datetrack_mode := hr_api.g_update;

1690:
1691: if l_update_override then
1692: l_ppe_datetrack_mode := hr_api.g_update_override;
1693: elsif l_update then
1694: l_ppe_datetrack_mode := hr_api.g_update;
1695: else
1696: l_ppe_datetrack_mode := hr_api.g_correction;
1697: end if;
1698: /* End of Changes for WWBUG: 1646442 */

Line 1696: l_ppe_datetrack_mode := hr_api.g_correction;

1692: l_ppe_datetrack_mode := hr_api.g_update_override;
1693: elsif l_update then
1694: l_ppe_datetrack_mode := hr_api.g_update;
1695: else
1696: l_ppe_datetrack_mode := hr_api.g_correction;
1697: end if;
1698: /* End of Changes for WWBUG: 1646442 */
1699:
1700: ben_prtt_prem_api.update_prtt_prem

Line 1708: p_datetrack_mode => hr_api.g_update,

1704: p_per_in_ler_id => l_pil.per_in_ler_id,
1705: /*
1706: CODE PRIOR TO WWBUG: 1646442
1707: p_effective_date => l_effective_date, --9999 p_effective_date,
1708: p_datetrack_mode => hr_api.g_update,
1709: */
1710: /* Start of Changes for WWBUG: 1646442 */
1711: p_effective_date => l_ppe_dt_to_use,
1712: p_datetrack_mode => l_ppe_datetrack_mode,

Line 1849: p_datetrack_mode => hr_api.g_update,

1845: p_pen_attribute27 => l_pen.pen_attribute27,
1846: p_pen_attribute28 => l_pen.pen_attribute28,
1847: p_pen_attribute29 => l_pen.pen_attribute29,
1848: p_pen_attribute30 => l_pen.pen_attribute30,
1849: p_datetrack_mode => hr_api.g_update,
1850: p_suspend_flag => l_dummy_char,
1851: p_effective_start_date => l_dummy_date,
1852: p_effective_end_date => l_dummy_date,
1853: p_object_version_number => l_pen.object_version_number,

Line 2467: and bpl.effective_end_date = hr_api.g_eot

2463: from ben_bnft_prvdd_ldgr_f bpl,
2464: ben_per_in_ler pil
2465: where bpl.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2466: and bpl.prvdd_val is not null
2467: and bpl.effective_end_date = hr_api.g_eot
2468: and bpl.per_in_ler_id = pil.per_in_ler_id
2469: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
2470: --
2471: cursor c_new_cr_val (p_acty_base_rt_id number,