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 2633: and l_effective_date between nvl(ctr.date_start, hr_api.g_sot)

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

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

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

Line 9751: AND pen.effective_end_date = hr_api.g_eot

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