APPS.BEN_COP_INS dependencies on BEN_PL_TYP_F

Line 391: from ben_pl_typ_f ptp,ben_pl_f pln

387: Cursor c1 is select ben_oipl_f_s.nextval from sys.dual;
388: --
389: cursor c_icm_opt_track_flag is
390: select ptp.opt_typ_cd
391: from ben_pl_typ_f ptp,ben_pl_f pln
392: where pln.pl_id = p_rec.pl_id
393: and pln.pl_typ_id = ptp.pl_typ_id
394: and pln.business_group_id = p_rec.business_group_id
395: and p_effective_date between pln.effective_start_date and pln.effective_end_date

Line 398: l_icm_opt_track_flag ben_pl_typ_f.opt_typ_cd%TYPE;

394: and pln.business_group_id = p_rec.business_group_id
395: and p_effective_date between pln.effective_start_date and pln.effective_end_date
396: and p_effective_date between ptp.effective_start_date and ptp.effective_end_date;
397: --
398: l_icm_opt_track_flag ben_pl_typ_f.opt_typ_cd%TYPE;
399: --
400: Begin
401: hr_utility.set_location('Entering:'||l_proc, 5);
402: --