APPS.BEN_COP_INS dependencies on BEN_PL_TYP_F

Line 389: from ben_pl_typ_f ptp,ben_pl_f pln

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

Line 396: l_icm_opt_track_flag ben_pl_typ_f.opt_typ_cd%TYPE;

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