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

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

2630: WHERE ctr.person_id = p_person_id
2631: AND per.person_id = ctr.contact_person_id
2632: AND ctr.personal_flag = 'Y'
2633: AND ctr.contact_type = 'S'
2634: and l_effective_date between nvl(ctr.date_start, hr_api.g_sot)
2635: and nvl(ctr.date_end, hr_api.g_eot)
2636: AND l_effective_date BETWEEN per.effective_start_date
2637: AND per.effective_end_date;
2638: --

Line 2635: and nvl(ctr.date_end, hr_api.g_eot)

2631: AND per.person_id = ctr.contact_person_id
2632: AND ctr.personal_flag = 'Y'
2633: AND ctr.contact_type = 'S'
2634: and l_effective_date between nvl(ctr.date_start, hr_api.g_sot)
2635: and nvl(ctr.date_end, hr_api.g_eot)
2636: AND l_effective_date BETWEEN per.effective_start_date
2637: AND per.effective_end_date;
2638: --
2639: CURSOR c_per_depen_first IS

Line 9752: AND pen.effective_end_date = hr_api.g_eot

9748: AND pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
9749: AND prv.business_group_id = pen.business_group_id
9750: AND prv.prtt_rt_val_stat_cd IS NULL
9751: AND prv.acty_typ_cd LIKE 'PBC%'
9752: AND pen.effective_end_date = hr_api.g_eot
9753: ORDER BY prv.rt_strt_dt;
9754:
9755: --
9756: CURSOR c_get_elcns_made_dt IS