DBA Data[Home] [Help]

APPS.BEN_BIS_UTILS dependencies on BEN_PGM_F

Line 92: from ben_pgm_f pgm

88: is
89: --
90: cursor c1 is
91: select name
92: from ben_pgm_f pgm
93: where pgm_id = p_pgm_id
94: and business_group_id = p_business_group_id
95: and p_effective_date between effective_start_date and effective_end_date;
96: --

Line 181: ben_pgm_f pgm,

177: --
178: cursor c1 is
179: select pgm.name|| ' - '|| pln.name
180: from ben_pl_f pln,
181: ben_pgm_f pgm,
182: ben_plip_f plip
183: where plip.plip_id = p_plip_id
184: and pgm.pgm_id = plip.pgm_id
185: and pln.pl_id = plip.pl_id

Line 217: ben_pgm_f pgm,

213: --
214: cursor c1 is
215: select pgm.name|| ' - ' || plt.name
216: from ben_pl_typ_f plt,
217: ben_pgm_f pgm,
218: ben_ptip_f ptip
219: where ptip.ptip_id = p_ptip_id
220: and pgm.pgm_id = ptip.pgm_id
221: and plt.pl_typ_id = ptip.pl_typ_id

Line 326: ben_pgm_f pgm

322: ben_opt_f opt,
323: ben_oipl_f oipl,
324: ben_oiplip_f oiplip,
325: ben_plip_f plip,
326: ben_pgm_f pgm
327: where oiplip.oiplip_id = p_oiplip_id
328: and oipl.oipl_id = oiplip.oipl_id
329: and opt.opt_id = oipl.opt_id
330: and pln.pl_id = oipl.pl_id