DBA Data[Home] [Help]

APPS.BEN_DETERMINE_RATE_CHG dependencies on BEN_PL_F

Line 682: select 'x' from ben_pl_f pl

678: and pay2.period_type<>pay.period_type
679: and asg.assignment_type = asg2.assignment_type ;
680:
681: cursor c_pl(p_pl_id number,p_eff_dt date) is
682: select 'x' from ben_pl_f pl
683: where pl.pl_id = p_pl_id
684: and pl.SUBJ_TO_IMPTD_INCM_TYP_CD is not null
685: and p_eff_dt between
686: pl.effective_start_date and pl.effective_end_date;