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 410: (pen.enrt_ovridn_flag = 'Y' and nvl(pen.enrt_ovrid_thru_dt,hr_api.g_eot) < l_effective_date ))

406: where pen.prtt_enrt_rslt_id = l_epe.prtt_enrt_rslt_id
407: and pen.person_id = p_person_id
408: and pen.sspndd_flag = 'N'
409: and ( (pen.enrt_ovridn_flag = 'N' ) OR
410: (pen.enrt_ovridn_flag = 'Y' and nvl(pen.enrt_ovrid_thru_dt,hr_api.g_eot) < l_effective_date ))
411: and pen.enrt_cvg_thru_dt = hr_api.g_eot
412: and pen.prtt_enrt_rslt_stat_cd is null
413: and l_effective_date -- Bug 3044116 p_effective_date
414: between pen.effective_start_date and pen.effective_end_date

Line 411: and pen.enrt_cvg_thru_dt = hr_api.g_eot

407: and pen.person_id = p_person_id
408: and pen.sspndd_flag = 'N'
409: and ( (pen.enrt_ovridn_flag = 'N' ) OR
410: (pen.enrt_ovridn_flag = 'Y' and nvl(pen.enrt_ovrid_thru_dt,hr_api.g_eot) < l_effective_date ))
411: and pen.enrt_cvg_thru_dt = hr_api.g_eot
412: and pen.prtt_enrt_rslt_stat_cd is null
413: and l_effective_date -- Bug 3044116 p_effective_date
414: between pen.effective_start_date and pen.effective_end_date
415: --bug#3856424 - check for any deenrollment in future - defensive coding

Line 418: and pen2.enrt_cvg_thru_dt = hr_api.g_eot

414: between pen.effective_start_date and pen.effective_end_date
415: --bug#3856424 - check for any deenrollment in future - defensive coding
416: and exists (select null from ben_prtt_enrt_rslt_f pen2
417: where pen2.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
418: and pen2.enrt_cvg_thru_dt = hr_api.g_eot
419: and pen2.effective_end_date = hr_api.g_eot)
420: and not exists ( select 'x' from ben_prtt_enrt_rslt_f pen3 --Bug 5617091 exclude interim results
421: where pen3.rplcs_sspndd_rslt_id= pen.prtt_enrt_rslt_id
422: and pen3.sspndd_flag = 'Y'

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

415: --bug#3856424 - check for any deenrollment in future - defensive coding
416: and exists (select null from ben_prtt_enrt_rslt_f pen2
417: where pen2.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
418: and pen2.enrt_cvg_thru_dt = hr_api.g_eot
419: and pen2.effective_end_date = hr_api.g_eot)
420: and not exists ( select 'x' from ben_prtt_enrt_rslt_f pen3 --Bug 5617091 exclude interim results
421: where pen3.rplcs_sspndd_rslt_id= pen.prtt_enrt_rslt_id
422: and pen3.sspndd_flag = 'Y'
423: and pen3.prtt_enrt_rslt_stat_cd is null

Line 424: and pen3.enrt_cvg_thru_dt = hr_api.g_eot

420: and not exists ( select 'x' from ben_prtt_enrt_rslt_f pen3 --Bug 5617091 exclude interim results
421: where pen3.rplcs_sspndd_rslt_id= pen.prtt_enrt_rslt_id
422: and pen3.sspndd_flag = 'Y'
423: and pen3.prtt_enrt_rslt_stat_cd is null
424: and pen3.enrt_cvg_thru_dt = hr_api.g_eot
425: and pen3.effective_end_date = hr_api.g_eot)
426: ;
427: --
428: l_pen c_pen%rowtype;

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

421: where pen3.rplcs_sspndd_rslt_id= pen.prtt_enrt_rslt_id
422: and pen3.sspndd_flag = 'Y'
423: and pen3.prtt_enrt_rslt_stat_cd is null
424: and pen3.enrt_cvg_thru_dt = hr_api.g_eot
425: and pen3.effective_end_date = hr_api.g_eot)
426: ;
427: --
428: l_pen c_pen%rowtype;
429: --

Line 579: (prv.rt_end_dt = hr_api.g_eot

575: and prv1.acty_base_rt_id = v_acty_base_rt_id
576: and prv1.prtt_rt_val_stat_cd is null
577: and prv1.rt_strt_dt > v_rt_strt_dt)
578: ) or
579: (prv.rt_end_dt = hr_api.g_eot
580: and prv.rt_strt_dt > v_rt_strt_dt
581: and exists
582: (select '1' from ben_prtt_rt_val prv1
583: where prv1.prtt_enrt_rslt_id = l_pen.prtt_enrt_rslt_id

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

586: and prv1.rt_strt_dt > v_rt_strt_dt))
587: )
588: ) or
589: (v_rt_strt_dt is null and
590: prv.rt_end_dt = hr_api.g_eot))
591: and prv.prtt_rt_val_stat_cd is null;
592: --
593: l_prv c_prv%rowtype;
594: --

Line 1149: p_datetrack_mode => hr_api.g_update,

1145: p_pen_attribute27 => l_pen.pen_attribute27,
1146: p_pen_attribute28 => l_pen.pen_attribute28,
1147: p_pen_attribute29 => l_pen.pen_attribute29,
1148: p_pen_attribute30 => l_pen.pen_attribute30,
1149: p_datetrack_mode => hr_api.g_update,
1150: p_suspend_flag => l_dummy_char,
1151: p_effective_start_date => l_dummy_date,
1152: p_effective_end_date => l_dummy_date,
1153: p_object_version_number => l_pen.object_version_number,

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

1345: --
1346: -- nvl(l_prv.cmcd_rt_val,0) = nvl(l_ecr.cmcd_val,0) /* bug 7414466 */
1347: -- )and
1348: (l_prv.rt_ovridn_flag = 'N' OR
1349: (l_prv.rt_ovridn_flag= 'Y' and nvl(l_prv.rt_ovridn_thru_dt,hr_api.g_eot)< l_rt_strt_dt ))) then
1350: --
1351: -- get old element info
1352: --
1353: l_element_info := null;

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

1533: if ((l_rt_strt_dt >= nvl(l_prv_min_strt_dt,l_rt_strt_dt)) and
1534: ((NOT l_prv_found) OR
1535: (l_prv.rt_ovridn_flag = 'N' OR
1536: (l_prv.rt_ovridn_flag= 'Y' and
1537: nvl(l_prv.rt_ovridn_thru_dt,hr_api.g_eot)< l_rt_strt_dt))))
1538: then
1539: --
1540: /* Bug 3394862 We need to modify this if clause such that
1541: l_entr_val_at_enrt_flag is checked only

Line 1585: ,p_datetrack_mode => hr_api.g_update

1581: ,p_rt_val => l_ecr.val
1582: ,p_ann_rt_val => l_ecr.ann_val
1583: ,p_enrt_cvg_strt_dt => l_pen.enrt_cvg_strt_dt
1584: ,p_acty_ref_perd_cd => l_epe.acty_ref_perd_cd
1585: ,p_datetrack_mode => hr_api.g_update
1586: ,p_business_group_id => p_business_group_id
1587: ,p_bnft_amt_changed => l_bnft_changed
1588: ,p_ele_changed => l_element_changed
1589: ,p_prv_rt_val => l_dummy_number

Line 1875: l_ppe_datetrack_mode := hr_api.g_update_override;

1871: p_update_override => l_update_override,
1872: p_update_change_insert => l_update_change_insert);
1873:
1874: if l_update_override then
1875: l_ppe_datetrack_mode := hr_api.g_update_override;
1876: elsif l_update then
1877: l_ppe_datetrack_mode := hr_api.g_update;
1878: else
1879: l_ppe_datetrack_mode := hr_api.g_correction;

Line 1877: l_ppe_datetrack_mode := hr_api.g_update;

1873:
1874: if l_update_override then
1875: l_ppe_datetrack_mode := hr_api.g_update_override;
1876: elsif l_update then
1877: l_ppe_datetrack_mode := hr_api.g_update;
1878: else
1879: l_ppe_datetrack_mode := hr_api.g_correction;
1880: end if;
1881: /* End of Changes for WWBUG: 1646442 */

Line 1879: l_ppe_datetrack_mode := hr_api.g_correction;

1875: l_ppe_datetrack_mode := hr_api.g_update_override;
1876: elsif l_update then
1877: l_ppe_datetrack_mode := hr_api.g_update;
1878: else
1879: l_ppe_datetrack_mode := hr_api.g_correction;
1880: end if;
1881: /* End of Changes for WWBUG: 1646442 */
1882:
1883: ben_prtt_prem_api.update_prtt_prem

Line 1891: p_datetrack_mode => hr_api.g_update,

1887: p_per_in_ler_id => l_pil.per_in_ler_id,
1888: /*
1889: CODE PRIOR TO WWBUG: 1646442
1890: p_effective_date => l_effective_date, --9999 p_effective_date,
1891: p_datetrack_mode => hr_api.g_update,
1892: */
1893: /* Start of Changes for WWBUG: 1646442 */
1894: p_effective_date => l_ppe_dt_to_use,
1895: p_datetrack_mode => l_ppe_datetrack_mode,

Line 2032: p_datetrack_mode => hr_api.g_update,

2028: p_pen_attribute27 => l_pen.pen_attribute27,
2029: p_pen_attribute28 => l_pen.pen_attribute28,
2030: p_pen_attribute29 => l_pen.pen_attribute29,
2031: p_pen_attribute30 => l_pen.pen_attribute30,
2032: p_datetrack_mode => hr_api.g_update,
2033: p_suspend_flag => l_dummy_char,
2034: p_effective_start_date => l_dummy_date,
2035: p_effective_end_date => l_dummy_date,
2036: p_object_version_number => l_pen.object_version_number,

Line 2650: and bpl.effective_end_date = hr_api.g_eot

2646: from ben_bnft_prvdd_ldgr_f bpl,
2647: ben_per_in_ler pil
2648: where bpl.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2649: and bpl.prvdd_val is not null
2650: and bpl.effective_end_date = hr_api.g_eot
2651: and bpl.per_in_ler_id = pil.per_in_ler_id
2652: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
2653: --
2654: cursor c_new_cr_val (p_acty_base_rt_id number,