DBA Data[Home] [Help]

APPS.BEN_DETERMINE_RATE_CHG dependencies on BEN_PL_F

Line 634: select 'x' from ben_pl_f pl

630: and pay2.period_type<>pay.period_type
631: and asg.assignment_type = asg2.assignment_type ;
632:
633: cursor c_pl(p_pl_id number,p_eff_dt date) is
634: select 'x' from ben_pl_f pl
635: where pl.pl_id = p_pl_id
636: and pl.SUBJ_TO_IMPTD_INCM_TYP_CD is not null
637: and p_eff_dt between
638: pl.effective_start_date and pl.effective_end_date;