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_LER_CHG_DPNT_CVG_F

Line 8633: FROM ben_ler_chg_dpnt_cvg_f ldc

8629: CURSOR c_ler_chg_dep IS
8630: SELECT '1',
8631: ldc.ler_chg_dpnt_cvg_cd,
8632: ldc.ler_chg_dpnt_cvg_rl
8633: FROM ben_ler_chg_dpnt_cvg_f ldc
8634: WHERE ldc.ler_id = p_ler_id
8635: AND ldc.business_group_id = p_business_group_id
8636: AND ldc.pl_id = p_pl_id
8637: AND l_lf_evt_ocrd_dt BETWEEN ldc.effective_start_date

Line 8644: FROM ben_ler_chg_dpnt_cvg_f ldc

8640: UNION ALL
8641: SELECT '2',
8642: ldc.ler_chg_dpnt_cvg_cd,
8643: ldc.ler_chg_dpnt_cvg_rl
8644: FROM ben_ler_chg_dpnt_cvg_f ldc
8645: WHERE ldc.ler_id = p_ler_id
8646: AND ldc.business_group_id = p_business_group_id
8647: AND ldc.ptip_id = p_ptip_id
8648: AND l_lf_evt_ocrd_dt BETWEEN ldc.effective_start_date

Line 8655: FROM ben_ler_chg_dpnt_cvg_f ldc

8651: UNION ALL
8652: SELECT '3',
8653: ldc.ler_chg_dpnt_cvg_cd,
8654: ldc.ler_chg_dpnt_cvg_rl
8655: FROM ben_ler_chg_dpnt_cvg_f ldc
8656: WHERE ldc.ler_id = p_ler_id
8657: AND ldc.business_group_id = p_business_group_id
8658: AND ldc.pgm_id = p_pgm_id
8659: AND l_lf_evt_ocrd_dt BETWEEN ldc.effective_start_date