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_BENEFITS_EIT dependencies on BEN_PER_IN_LER

Line 106: ben_per_in_ler pil

102: SELECT elig_per_elctbl_chc_id,
103: pil.per_in_ler_id,
104: prtt_enrt_rslt_id
105: FROM ben_elig_per_ELCTBL_chc chc ,
106: ben_per_in_ler pil
107: WHERE chc.pgm_id = c_pgm_id
108: AND chc.pl_typ_id = c_pl_typ_id
109: AND chc.pl_id = c_pl_id
110: AND chc.plip_id = c_plip_id

Line 126: ben_per_in_ler pil

122: select elig_per_elctbl_chc_id,
123: pil.per_in_ler_id,
124: prtt_enrt_rslt_id
125: from ben_elig_per_ELCTBL_chc chc ,
126: ben_per_in_ler pil
127: where chc.pgm_id = c_pgm_id
128: and chc.pl_typ_id = c_pl_typ_id
129: and chc.pl_id = c_pl_id
130: and chc.plip_id = c_plip_id

Line 249: from ben_per_in_ler pil,ben_ler_f lf

245: p_business_group_id in number,
246: p_person_id in number)
247: is
248: select per_in_ler_id
249: from ben_per_in_ler pil,ben_ler_f lf
250: where pil.person_id = p_person_id
251: and pil.business_group_id = p_business_group_id
252: and pil.PER_IN_LER_STAT_CD in ('STRTD')
253: and lf.ler_id = pil.ler_id

Line 694: ben_per_in_ler pil

690: c_person_id per_all_people_f.person_id%type) IS
691: SELECT elig_per_elctbl_chc_id,
692: pil.per_in_ler_id
693: FROM ben_elig_per_ELCTBL_chc chc ,
694: ben_per_in_ler pil
695: WHERE chc.pgm_id = c_pgm_id
696: AND chc.pl_typ_id = c_pl_typ_id
697: AND chc.pl_id = c_pl_id
698: AND chc.plip_id = c_plip_id

Line 1068: ben_per_in_ler pil

1064: c_person_id per_all_people_f.person_id%type) is
1065: SELECT elig_per_elctbl_chc_id,
1066: pil.per_in_ler_id
1067: FROM ben_elig_per_ELCTBL_chc chc ,
1068: ben_per_in_ler pil
1069: WHERE chc.pgm_id = c_pgm_id
1070: AND chc.pl_typ_id = c_pl_typ_id
1071: AND chc.pl_id = c_pl_id
1072: AND chc.plip_id = c_plip_id

Line 1089: ben_per_in_ler pil

1085: c_person_id per_all_people_f.person_id%type) is
1086: SELECT elig_per_elctbl_chc_id,
1087: pil.per_in_ler_id
1088: FROM ben_elig_per_ELCTBL_chc chc ,
1089: ben_per_in_ler pil
1090: WHERE chc.pgm_id = c_pgm_id
1091: AND chc.pl_typ_id = c_pl_typ_id
1092: AND chc.pl_id = c_pl_id
1093: AND chc.plip_id = c_plip_id