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_BACK_OUT_LIFE_EVENT dependencies on BEN_LER_F

Line 1169: from ben_ler_f ler

1165: ;
1166:
1167: cursor c_get_ler_info(v_ler_id number) is
1168: select ler.typ_cd
1169: from ben_ler_f ler
1170: where ler.ler_id = v_ler_id
1171: /* and ler.business_group_id = p_business_group_id*/ -- CWBGLOBAL
1172: and p_effective_date between
1173: ler.effective_start_date and ler.effective_end_date;

Line 1177: from ben_ler_f ler,

1173: ler.effective_start_date and ler.effective_end_date;
1174: --
1175: cursor c_ler_typ is
1176: select ler.typ_cd
1177: from ben_ler_f ler,
1178: ben_per_in_ler pil
1179: where pil.per_in_ler_id = p_per_in_ler_id
1180: and ler.ler_id = pil.ler_id
1181: /*and ler.business_group_id = p_business_group_id*/ --CWBGLOBAL