DBA Data[Home] [Help]

APPS.BEN_CVG_CACHE dependencies on BEN_CVG_AMT_CALC_MTHD_F

Line 110: from ben_cvg_amt_calc_mthd_f cvg,

106: pln.cvg_incr_r_decr_only_cd,
107: pln.bnft_or_option_rstrctn_cd,
108: pln.mx_cvg_rl,
109: pln.mn_cvg_rl
110: from ben_cvg_amt_calc_mthd_f cvg,
111: ben_pl_f pln
112: where pln.pl_id = c_pln_id
113: and cvg.pl_id = pln.pl_id
114: and c_effective_date

Line 183: from ben_cvg_amt_calc_mthd_f cvg,

179: pln.cvg_incr_r_decr_only_cd,
180: pln.bnft_or_option_rstrctn_cd,
181: pln.mx_cvg_rl,
182: pln.mn_cvg_rl
183: from ben_cvg_amt_calc_mthd_f cvg,
184: ben_plip_f cpp,
185: ben_pl_f pln
186: where cpp.plip_id = c_plip_id
187: and cvg.plip_id = cpp.plip_id

Line 262: from ben_cvg_amt_calc_mthd_f cvg,

258: pln.cvg_incr_r_decr_only_cd,
259: pln.bnft_or_option_rstrctn_cd,
260: pln.mx_cvg_rl,
261: pln.mn_cvg_rl
262: from ben_cvg_amt_calc_mthd_f cvg,
263: ben_oipl_f cop,
264: ben_pl_f pln
265: where cop.oipl_id = c_oipl_id
266: and cvg.oipl_id = cop.oipl_id