DBA Data[Home] [Help]

APPS.BEN_OPTION_DEFINITION_API dependencies on BEN_PL_TYP_OPT_TYP_F

Line 397: from ben_pl_typ_opt_typ_f

393: --
394: l_group_opt_id number(15) ;
395: cursor c_ptp (p_opt_id in number) is
396: select count(*)
397: from ben_pl_typ_opt_typ_f
398: where pl_typ_opt_typ_cd = 'CWB'
399: and opt_id = p_opt_id
400: and p_effective_date between effective_start_date and effective_end_date;
401: l_count_cwb_pl_typ number;