APPS.BEN_DETERMINE_ELCT_CHC_FLX_IMP dependencies on BEN_PGM_F

Line 113: from ben_elig_per_elctbl_chc epe, ben_pgm_f pgm

109: -- Used for PGM
110: cursor c_epe_pgm is
111: select distinct
112: epe.pgm_id
113: from ben_elig_per_elctbl_chc epe, ben_pgm_f pgm
114: where p_per_in_ler_id = epe.per_in_ler_id
115: and pgm.pgm_id = epe.pgm_id
116: and pgm.pgm_typ_cd in ('COBRAFLX', 'FLEX', 'FPC')
117: and nvl(p_lf_evt_ocrd_dt,p_effective_date)

Line 127: from ben_elig_per_elctbl_chc epe, ben_pgm_f pgm

123: -- Used for PLIP and Combo PLIP
124: cursor c_epe_plip is
125: select distinct epe.pgm_id, epe.plip_id, epe.plip_ordr_num,
126: epe.pl_id, epe.pl_typ_id, epe.ptip_id, epe.ptip_ordr_num
127: from ben_elig_per_elctbl_chc epe, ben_pgm_f pgm
128: where p_per_in_ler_id = epe.per_in_ler_id
129: and epe.plip_id is not null
130: and pgm.pgm_id = epe.pgm_id
131: and pgm.pgm_typ_cd in ('COBRAFLX', 'FLEX', 'FPC')

Line 141: from ben_elig_per_elctbl_chc epe, ben_pgm_f pgm

137:
138: -- Used for PTIP and Combo PTIP
139: cursor c_epe_ptip is
140: select distinct epe.pgm_id, epe.ptip_id,epe.ptip_ordr_num, epe.pl_typ_id
141: from ben_elig_per_elctbl_chc epe, ben_pgm_f pgm
142: where p_per_in_ler_id = epe.per_in_ler_id
143: and epe.ptip_id is not null
144: and pgm.pgm_id = epe.pgm_id
145: and pgm.pgm_typ_cd in ('COBRAFLX', 'FLEX', 'FPC')

Line 156: from ben_elig_per_elctbl_chc epe, ben_pgm_f pgm

152: -- Used for OIPLIP and Combo PTIP Option
153: cursor c_epe_oipl is
154: select distinct epe.pgm_id,epe.plip_id, epe.ptip_id,epe.oipl_id,epe.oipl_ordr_num,
155: epe.oiplip_id, epe.pl_typ_id, epe.pl_id, epe.plip_ordr_num, epe.ptip_ordr_num
156: from ben_elig_per_elctbl_chc epe, ben_pgm_f pgm
157: where p_per_in_ler_id = epe.per_in_ler_id
158: and epe.oiplip_id is not null
159: and pgm.pgm_id = epe.pgm_id
160: and pgm.pgm_typ_cd in ('COBRAFLX', 'FLEX', 'FPC')