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.GHR_GENERAL dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 296: from ben_elig_per_ELCTBL_chc chc ,

292:
293: Cursor get_elig_chc_id_opt is
294: select elig_per_elctbl_chc_id,
295: pil.per_in_ler_id
296: from ben_elig_per_ELCTBL_chc chc ,
297: ben_per_in_ler pil
298: where chc.pgm_id = l_pgm_id
299: and chc.pl_typ_id = l_pl_typ_id
300: and chc.pl_id = l_pl_id

Line 311: from ben_elig_per_ELCTBL_chc chc ,

307:
308: Cursor get_elig_chc_id is
309: select elig_per_elctbl_chc_id,
310: pil.per_in_ler_id
311: from ben_elig_per_ELCTBL_chc chc ,
312: ben_per_in_ler pil
313: where chc.pgm_id = l_pgm_id
314: and chc.pl_typ_id = l_pl_typ_id
315: and chc.pl_id = l_pl_id

Line 815: from ben_elig_per_ELCTBL_chc chc ,

811: -- Cursor to get the elig_chc_id for the plan, Option
812: Cursor c_get_elig_chc_id_opt is
813: select elig_per_elctbl_chc_id,
814: pil.per_in_ler_id
815: from ben_elig_per_ELCTBL_chc chc ,
816: ben_per_in_ler pil
817: where chc.pgm_id = l_pgm_id
818: and chc.pl_typ_id = l_pl_typ_id
819: and chc.pl_id = l_pl_id

Line 1183: from ben_elig_per_ELCTBL_chc chc ,

1179: -- Cursor to get the elig_chc_id for the plan, Option
1180: Cursor c_get_elig_chc_id_opt is
1181: select elig_per_elctbl_chc_id,
1182: pil.per_in_ler_id
1183: from ben_elig_per_ELCTBL_chc chc ,
1184: ben_per_in_ler pil
1185: where chc.pgm_id = l_pgm_id
1186: and chc.pl_typ_id = l_pl_typ_id
1187: and chc.pl_id = l_pl_id