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

Line 137: between nvl(ctr.date_start,hr_api.g_sot)

133: and nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date))
134: between ppf.effective_start_date
135: and ppf.effective_end_date
136: and nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date))
137: between nvl(ctr.date_start,hr_api.g_sot)
138: and nvl(ctr.date_end,hr_api.g_eot)
139: and ctr.business_group_id = p_business_group_id;
140: --
141: cursor c_get_no_of_contacts is

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

134: between ppf.effective_start_date
135: and ppf.effective_end_date
136: and nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date))
137: between nvl(ctr.date_start,hr_api.g_sot)
138: and nvl(ctr.date_end,hr_api.g_eot)
139: and ctr.business_group_id = p_business_group_id;
140: --
141: cursor c_get_no_of_contacts is
142: select count(ctr.person_id)

Line 152: between nvl(ctr.date_start,hr_api.g_sot)

148: and nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date))
149: between ppf.effective_start_date
150: and ppf.effective_end_date
151: and nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date))
152: between nvl(ctr.date_start,hr_api.g_sot)
153: and nvl(ctr.date_end,hr_api.g_eot)
154: and ctr.business_group_id = p_business_group_id;
155:
156:

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

149: between ppf.effective_start_date
150: and ppf.effective_end_date
151: and nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date))
152: between nvl(ctr.date_start,hr_api.g_sot)
153: and nvl(ctr.date_end,hr_api.g_eot)
154: and ctr.business_group_id = p_business_group_id;
155:
156:
157: -- bug # 2424041 begins

Line 423: nvl(p_comp_rec.prtn_ovridn_thru_dt,hr_api.g_eot) >= nvl(l_fonm_cvg_strt_dt,

419:
420: --bug 7264617: changed condition to >= in order to include lf_evt_ocrd_dt in ovridn_thru_dt
421: if l_pgm_rec.prtn_elig_ovrid_alwd_flag = 'Y' and
422: p_comp_rec.prtn_ovridn_flag = 'Y' and
423: nvl(p_comp_rec.prtn_ovridn_thru_dt,hr_api.g_eot) >= nvl(l_fonm_cvg_strt_dt,
424: nvl(p_lf_evt_ocrd_dt,p_effective_date)) and
425: (nvl(l_elig_to_prte_rsn_row.ignr_prtn_ovrid_flag,'N') = 'N' or
426: p_ler_id is null) then
427: --

Line 469: nvl(p_comp_rec.prtn_ovridn_thru_dt,hr_api.g_eot) >= nvl(l_fonm_cvg_strt_dt,

465: --
466: --bug 7264617: changed condition to >= in order to include lf_evt_ocrd_dt in ovridn_thru_dt
467: if l_pl_rec.prtn_elig_ovrid_alwd_flag = 'Y' and
468: p_comp_rec.prtn_ovridn_flag = 'Y' and
469: nvl(p_comp_rec.prtn_ovridn_thru_dt,hr_api.g_eot) >= nvl(l_fonm_cvg_strt_dt,
470: nvl(p_lf_evt_ocrd_dt,p_effective_date)) and
471: (nvl(l_elig_to_prte_rsn_row.ignr_prtn_ovrid_flag,'N') = 'N' or
472: p_ler_id is null) then
473: --

Line 517: nvl(p_comp_rec.prtn_ovridn_thru_dt,hr_api.g_eot) >= nvl(l_fonm_cvg_strt_dt,

513: --
514: --bug 7264617: changed condition to >= in order to include lf_evt_ocrd_dt in ovridn_thru_dt
515: if l_plip_rec.prtn_elig_ovrid_alwd_flag = 'Y' and
516: p_comp_rec.prtn_ovridn_flag = 'Y' and
517: nvl(p_comp_rec.prtn_ovridn_thru_dt,hr_api.g_eot) >= nvl(l_fonm_cvg_strt_dt,
518: nvl(p_lf_evt_ocrd_dt,p_effective_date)) and
519: (nvl(l_elig_to_prte_rsn_row.ignr_prtn_ovrid_flag,'N') = 'N' or
520: p_ler_id is null) then
521: --

Line 558: nvl(p_comp_rec.prtn_ovridn_thru_dt,hr_api.g_eot) >= nvl(l_fonm_cvg_strt_dt,

554: --
555: --bug 7264617: changed condition to >= in order to include lf_evt_ocrd_dt in ovridn_thru_dt
556: if l_ptip_rec.prtn_elig_ovrid_alwd_flag = 'Y' and
557: p_comp_rec.prtn_ovridn_flag = 'Y' and
558: nvl(p_comp_rec.prtn_ovridn_thru_dt,hr_api.g_eot) >= nvl(l_fonm_cvg_strt_dt,
559: nvl(p_lf_evt_ocrd_dt,p_effective_date)) and
560: (nvl(l_elig_to_prte_rsn_row.ignr_prtn_ovrid_flag,'N') = 'N' or
561: p_ler_id is null) then
562: --

Line 599: nvl(p_comp_rec.prtn_ovridn_thru_dt,hr_api.g_eot) >= nvl(l_fonm_cvg_strt_dt,

595: --
596: --bug 7264617: changed condition to >= in order to include lf_evt_ocrd_dt in ovridn_thru_dt
597: if l_oipl_rec.prtn_elig_ovrid_alwd_flag = 'Y' and
598: p_comp_rec.prtn_ovridn_flag = 'Y' and
599: nvl(p_comp_rec.prtn_ovridn_thru_dt,hr_api.g_eot) >= nvl(l_fonm_cvg_strt_dt,
600: nvl(p_lf_evt_ocrd_dt,p_effective_date)) and
601: (nvl(l_elig_to_prte_rsn_row.ignr_prtn_ovrid_flag,'N') = 'N' or
602: p_ler_id is null) then
603: --