DBA Data[Home] [Help]

APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_PRTT_ENRT_ACTN_F

Line 264: FROM ben_prtt_enrt_actn_f

260:
261: CURSOR c_pea
262: IS
263: SELECT effective_start_date
264: FROM ben_prtt_enrt_actn_f
265: WHERE prtt_enrt_actn_id = p_prtt_enrt_actn_id;
266: l_pea_esd date;
267: -- added cursor for bug: 5499162
268: CURSOR c_oipl

Line 274: FROM ben_prtt_enrt_actn_f

270: SELECT oipl_id
271: FROM ben_prtt_enrt_rslt_f
272: WHERE prtt_enrt_rslt_id IN (
273: SELECT prtt_enrt_rslt_id
274: FROM ben_prtt_enrt_actn_f
275: WHERE prtt_enrt_actn_id =
276: p_prtt_enrt_actn_id);
277: l_oipl_id ben_prtt_enrt_rslt_f.oipl_id%TYPE;
278: -- end addition