APPS.BEN_DISTRIBUTE_RATES dependencies on BEN_PL_TYP_F

Line 2359: from ben_pl_typ_f ptp

2355: --ICM Changes
2356: cursor c_opt_typ_cd(p_pl_typ_id number) is
2357: --
2358: select ptp.opt_typ_cd
2359: from ben_pl_typ_f ptp
2360: where ptp.pl_typ_id = p_pl_typ_id
2361: and p_effective_date between ptp.effective_start_date
2362: and ptp.effective_end_date;
2363: --

Line 2364: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%TYPE;

2360: where ptp.pl_typ_id = p_pl_typ_id
2361: and p_effective_date between ptp.effective_start_date
2362: and ptp.effective_end_date;
2363: --
2364: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%TYPE;
2365: --
2366: --ICM Changes
2367: l_batch_param_rec benutils.g_batch_param_rec;
2368: l_year varchar2(30);