APPS.BEN_COP_INS dependencies on BEN_PL_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 643: p_parent_table_name6 => 'ben_pl_f',

639: p_parent_key_value4 => p_rec.vrfy_fmly_mmbr_rl,
640: p_parent_table_name5 => 'ben_actl_prem_f',
641: p_parent_key_column5 => 'actl_prem_id',
642: p_parent_key_value5 => p_rec.actl_prem_id,
643: p_parent_table_name6 => 'ben_pl_f',
644: p_parent_key_column6 => 'pl_id',
645: p_parent_key_value6 => p_rec.pl_id,
646: p_parent_table_name7 => 'ben_opt_f',
647: p_parent_key_column7 => 'opt_id',