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 417: nvl(p_comp_rec.prtn_ovridn_thru_dt,hr_api.g_eot) >= nvl(l_fonm_cvg_strt_dt,

413:
414: --bug 7264617: changed condition to >= in order to include lf_evt_ocrd_dt in ovridn_thru_dt
415: if l_pgm_rec.prtn_elig_ovrid_alwd_flag = 'Y' and
416: p_comp_rec.prtn_ovridn_flag = 'Y' and
417: nvl(p_comp_rec.prtn_ovridn_thru_dt,hr_api.g_eot) >= nvl(l_fonm_cvg_strt_dt,
418: nvl(p_lf_evt_ocrd_dt,p_effective_date)) and
419: (nvl(l_elig_to_prte_rsn_row.ignr_prtn_ovrid_flag,'N') = 'N' or
420: p_ler_id is null) then
421: --

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

457: --
458: --bug 7264617: changed condition to >= in order to include lf_evt_ocrd_dt in ovridn_thru_dt
459: if l_pl_rec.prtn_elig_ovrid_alwd_flag = 'Y' and
460: p_comp_rec.prtn_ovridn_flag = 'Y' and
461: nvl(p_comp_rec.prtn_ovridn_thru_dt,hr_api.g_eot) >= nvl(l_fonm_cvg_strt_dt,
462: nvl(p_lf_evt_ocrd_dt,p_effective_date)) and
463: (nvl(l_elig_to_prte_rsn_row.ignr_prtn_ovrid_flag,'N') = 'N' or
464: p_ler_id is null) then
465: --

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

502: --
503: --bug 7264617: changed condition to >= in order to include lf_evt_ocrd_dt in ovridn_thru_dt
504: if l_plip_rec.prtn_elig_ovrid_alwd_flag = 'Y' and
505: p_comp_rec.prtn_ovridn_flag = 'Y' and
506: nvl(p_comp_rec.prtn_ovridn_thru_dt,hr_api.g_eot) >= nvl(l_fonm_cvg_strt_dt,
507: nvl(p_lf_evt_ocrd_dt,p_effective_date)) and
508: (nvl(l_elig_to_prte_rsn_row.ignr_prtn_ovrid_flag,'N') = 'N' or
509: p_ler_id is null) then
510: --

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

541: --
542: --bug 7264617: changed condition to >= in order to include lf_evt_ocrd_dt in ovridn_thru_dt
543: if l_ptip_rec.prtn_elig_ovrid_alwd_flag = 'Y' and
544: p_comp_rec.prtn_ovridn_flag = 'Y' and
545: nvl(p_comp_rec.prtn_ovridn_thru_dt,hr_api.g_eot) >= nvl(l_fonm_cvg_strt_dt,
546: nvl(p_lf_evt_ocrd_dt,p_effective_date)) and
547: (nvl(l_elig_to_prte_rsn_row.ignr_prtn_ovrid_flag,'N') = 'N' or
548: p_ler_id is null) then
549: --

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

580: --
581: --bug 7264617: changed condition to >= in order to include lf_evt_ocrd_dt in ovridn_thru_dt
582: if l_oipl_rec.prtn_elig_ovrid_alwd_flag = 'Y' and
583: p_comp_rec.prtn_ovridn_flag = 'Y' and
584: nvl(p_comp_rec.prtn_ovridn_thru_dt,hr_api.g_eot) >= nvl(l_fonm_cvg_strt_dt,
585: nvl(p_lf_evt_ocrd_dt,p_effective_date)) and
586: (nvl(l_elig_to_prte_rsn_row.ignr_prtn_ovrid_flag,'N') = 'N' or
587: p_ler_id is null) then
588: --