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 294: from ben_elig_per_ELCTBL_chc chc ,

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

Line 309: from ben_elig_per_ELCTBL_chc chc ,

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

Line 801: from ben_elig_per_ELCTBL_chc chc ,

797: -- Cursor to get the elig_chc_id for the plan, Option
798: Cursor c_get_elig_chc_id_opt is
799: select elig_per_elctbl_chc_id,
800: pil.per_in_ler_id
801: from ben_elig_per_ELCTBL_chc chc ,
802: ben_per_in_ler pil
803: where chc.pgm_id = l_pgm_id
804: and chc.pl_typ_id = l_pl_typ_id
805: and chc.pl_id = l_pl_id

Line 1157: from ben_elig_per_ELCTBL_chc chc ,

1153: -- Cursor to get the elig_chc_id for the plan, Option
1154: Cursor c_get_elig_chc_id_opt is
1155: select elig_per_elctbl_chc_id,
1156: pil.per_in_ler_id
1157: from ben_elig_per_ELCTBL_chc chc ,
1158: ben_per_in_ler pil
1159: where chc.pgm_id = l_pgm_id
1160: and chc.pl_typ_id = l_pl_typ_id
1161: and chc.pl_id = l_pl_id