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 1506: ben_elig_cvrd_dpnt_f pdp

1502: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
1503: FROM ben_prtt_enrt_rslt_f pen,
1504: ben_pl_f pl,
1505: ben_oipl_f oipl,
1506: ben_elig_cvrd_dpnt_f pdp
1507: WHERE pdp.dpnt_person_id = p_person_id
1508: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
1509: AND pen.effective_end_date = hr_api.g_eot
1510: AND pdp.effective_end_date = hr_api.g_eot

Line 1656: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp

1652: --
1653: --
1654: CURSOR c_plan_cvg_info IS
1655: SELECT pen.enrt_cvg_strt_dt enrt_cvg_strt_dt
1656: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp
1657: WHERE pdp.dpnt_person_id = p_person_id
1658: AND pen.effective_end_date = hr_api.g_eot
1659: AND pdp.effective_end_date = hr_api.g_eot
1660: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt

Line 2972: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp

2968: --
2969: --
2970: CURSOR c_plan_cvg_info IS
2971: SELECT 'Y'
2972: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp
2973: WHERE pdp.dpnt_person_id = p_person_id
2974: AND pdp.effective_end_date = hr_api.g_eot
2975: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
2976: AND pdp.business_group_id = p_business_group_id

Line 2996: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp

2992: --
2993: --
2994: CURSOR c_oipl_cvg_info IS
2995: SELECT 'Y'
2996: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp
2997: WHERE pdp.dpnt_person_id = p_person_id
2998: AND pdp.effective_end_date = hr_api.g_eot
2999: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
3000: AND pdp.business_group_id = p_business_group_id

Line 3480: ben_elig_cvrd_dpnt_f pdp,

3476: --
3477: CURSOR c_oipl_cvg_in_pl IS
3478: SELECT enrd_oipl.ordr_num
3479: FROM ben_prtt_enrt_rslt_f pen,
3480: ben_elig_cvrd_dpnt_f pdp,
3481: ben_oipl_f enrd_oipl
3482: WHERE pdp.dpnt_person_id = p_person_id
3483: AND pdp.effective_end_date = hr_api.g_eot
3484: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt

Line 9873: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp

9869: --
9870: --
9871: CURSOR c_plan_cvg_info IS
9872: SELECT 'Y'
9873: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp
9874: WHERE pdp.dpnt_person_id = p_person_id
9875: AND pdp.effective_end_date = hr_api.g_eot
9876: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
9877: AND pdp.business_group_id = p_business_group_id

Line 9897: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp

9893: --
9894: --
9895: CURSOR c_oipl_cvg_info IS
9896: SELECT 'Y'
9897: FROM ben_prtt_enrt_rslt_f pen, ben_elig_cvrd_dpnt_f pdp
9898: WHERE pdp.dpnt_person_id = p_person_id
9899: AND pdp.effective_end_date = hr_api.g_eot
9900: AND l_lf_evt_ocrd_dt_1 BETWEEN pdp.cvg_strt_dt AND pdp.cvg_thru_dt
9901: AND pdp.business_group_id = p_business_group_id