APPS.BEN_DISTRIBUTE_RATES dependencies on BEN_PL_TYP_F

Line 2234: from ben_pl_typ_f ptp

2230: --ICM Changes
2231: cursor c_opt_typ_cd(p_pl_typ_id number) is
2232: --
2233: select ptp.opt_typ_cd
2234: from ben_pl_typ_f ptp
2235: where ptp.pl_typ_id = p_pl_typ_id
2236: and p_effective_date between ptp.effective_start_date
2237: and ptp.effective_end_date;
2238: --

Line 2239: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%TYPE;

2235: where ptp.pl_typ_id = p_pl_typ_id
2236: and p_effective_date between ptp.effective_start_date
2237: and ptp.effective_end_date;
2238: --
2239: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%TYPE;
2240: --
2241: --ICM Changes
2242: l_batch_param_rec benutils.g_batch_param_rec;
2243: l_year varchar2(30);