APPS.GHR_BENEFITS_EIT dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 105: FROM ben_elig_per_ELCTBL_chc chc ,

101: c_ler_id ben_ler_f.ler_id%type, c_person_id per_all_people_f.person_id%type) IS
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

Line 125: from ben_elig_per_ELCTBL_chc chc ,

121: c_ler_id ben_ler_f.ler_id%type, c_person_id per_all_people_f.person_id%type) is
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

Line 693: FROM ben_elig_per_ELCTBL_chc chc ,

689: c_ptip_id ben_ptip_f.ptip_id%type, c_oipl_id ben_oipl_f.oipl_id%type,
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

Line 1067: FROM ben_elig_per_ELCTBL_chc chc ,

1063: c_ler_id ben_ler_f.ler_id%type,
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

Line 1088: FROM ben_elig_per_ELCTBL_chc chc ,

1084: c_ler_id ben_ler_f.ler_id%type,
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