APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_PRTT_RT_VAL

Line 3172: ben_prtt_rt_val prv

3168: ctu.pgm_id,
3169: ctu.pl_typ_id
3170: from ben_cm_typ_usg_f ctu,
3171: ben_prtt_enrt_rslt_f pen,
3172: ben_prtt_rt_val prv
3173: where ctu.business_group_id = p_business_group_id
3174: /* First join comp objects */
3175: and prv.per_in_ler_id = p_per_in_ler_id
3176: and prv.elctns_made_dt = p_effective_date

Line 3218: from ben_prtt_rt_val prv,

3214: and prv.prtt_rt_val_stat_cd is null;
3215: --
3216: cursor c2 is
3217: select null
3218: from ben_prtt_rt_val prv,
3219: ben_prtt_enrt_rslt_f pen
3220: where prv.business_group_id = p_business_group_id
3221: and prv.per_in_ler_id = p_per_in_ler_id
3222: and prv.elctns_made_dt = p_effective_date