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

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