APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_PRTT_RT_VAL

Line 3411: ben_prtt_rt_val prv

3407: ctu.pgm_id,
3408: ctu.pl_typ_id
3409: from ben_cm_typ_usg_f ctu,
3410: ben_prtt_enrt_rslt_f pen,
3411: ben_prtt_rt_val prv
3412: where ctu.business_group_id = p_business_group_id
3413: /* First join comp objects */
3414: and prv.per_in_ler_id = p_per_in_ler_id
3415: and prv.elctns_made_dt = p_effective_date

Line 3457: from ben_prtt_rt_val prv,

3453: and prv.prtt_rt_val_stat_cd is null;
3454: --
3455: cursor c2 is
3456: select null
3457: from ben_prtt_rt_val prv,
3458: ben_prtt_enrt_rslt_f pen
3459: where prv.business_group_id = p_business_group_id
3460: and prv.per_in_ler_id = p_per_in_ler_id
3461: and prv.elctns_made_dt = p_effective_date