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_ENROLMENT_REQUIREMENTS dependencies on BEN_ELIG_CVRD_DPNT_F

Line 1479: ben_elig_cvrd_dpnt_f pdp

1475: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
1476: FROM ben_prtt_enrt_rslt_f pen,
1477: ben_pl_f pl,
1478: ben_oipl_f oipl,
1479: ben_elig_cvrd_dpnt_f pdp
1480: WHERE pdp.dpnt_person_id = p_person_id
1481: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
1482: AND pen.effective_end_date = hr_api.g_eot
1483: AND pdp.effective_end_date = hr_api.g_eot

Line 1629: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp

1625: --
1626: --
1627: CURSOR c_plan_cvg_info IS
1628: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
1629: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp
1630: WHERE pdp.dpnt_person_id = p_person_id
1631: AND pen.effective_end_date = hr_api.g_eot
1632: AND pdp.effective_end_date = hr_api.g_eot
1633: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt

Line 2926: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp

2922: --
2923: --
2924: CURSOR c_plan_cvg_info IS
2925: SELECT 'Y'
2926: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp
2927: WHERE pdp.dpnt_person_id = p_person_id
2928: AND pdp.effective_end_date = hr_api.g_eot
2929: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
2930: AND pdp.business_group_id = p_business_group_id

Line 2950: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp

2946: --
2947: --
2948: CURSOR c_oipl_cvg_info IS
2949: SELECT 'Y'
2950: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp
2951: WHERE pdp.dpnt_person_id = p_person_id
2952: AND pdp.effective_end_date = hr_api.g_eot
2953: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
2954: AND pdp.business_group_id = p_business_group_id

Line 3434: ben_elig_cvrd_dpnt_f pdp,

3430: --
3431: CURSOR c_oipl_cvg_in_pl IS
3432: SELECT enrd_oipl.ordr_num
3433: FROM ben_prtt_enrt_rslt_f pen,
3434: ben_elig_cvrd_dpnt_f pdp,
3435: ben_oipl_f enrd_oipl
3436: WHERE pdp.dpnt_person_id = p_person_id
3437: AND pdp.effective_end_date = hr_api.g_eot
3438: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt

Line 9731: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp

9727: --
9728: --
9729: CURSOR c_plan_cvg_info IS
9730: SELECT 'Y'
9731: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp
9732: WHERE pdp.dpnt_person_id = p_person_id
9733: AND pdp.effective_end_date = hr_api.g_eot
9734: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
9735: AND pdp.business_group_id = p_business_group_id

Line 9755: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp

9751: --
9752: --
9753: CURSOR c_oipl_cvg_info IS
9754: SELECT 'Y'
9755: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp
9756: WHERE pdp.dpnt_person_id = p_person_id
9757: AND pdp.effective_end_date = hr_api.g_eot
9758: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
9759: AND pdp.business_group_id = p_business_group_id