DBA Data[Home] [Help]

APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_PRTT_ENRT_ACTN_F

Line 253: FROM ben_prtt_enrt_actn_f

249:
250: CURSOR c_pea
251: IS
252: SELECT effective_start_date
253: FROM ben_prtt_enrt_actn_f
254: WHERE prtt_enrt_actn_id = p_prtt_enrt_actn_id;
255: l_pea_esd date;
256: -- added cursor for bug: 5499162
257: CURSOR c_oipl

Line 263: FROM ben_prtt_enrt_actn_f

259: SELECT oipl_id
260: FROM ben_prtt_enrt_rslt_f
261: WHERE prtt_enrt_rslt_id IN (
262: SELECT prtt_enrt_rslt_id
263: FROM ben_prtt_enrt_actn_f
264: WHERE prtt_enrt_actn_id =
265: p_prtt_enrt_actn_id);
266: l_oipl_id ben_prtt_enrt_rslt_f.oipl_id%TYPE;
267: -- end addition