APPS.BEN_EHC_BUS dependencies on BEN_PL_TYP_OPT_TYP_F

Line 117: from ben_pl_typ_opt_typ_f pto

113: l_dummy varchar2(1);
114: --
115: cursor c1 is
116: select null
117: from ben_pl_typ_opt_typ_f pto
118: where pto.pl_typ_opt_typ_id = p_pl_typ_opt_typ_id
119: and pto.business_group_id = p_business_group_id
120: and p_effective_date
121: between pto.effective_start_date and pto.effective_end_date;

Line 153: -- ben_pl_typ_opt_typ_f table.

149: --
150: close c1;
151: --
152: -- raise error as FK does not relate to PK in
153: -- ben_pl_typ_opt_typ_f table.
154: --
155: ben_ehc_shd.constraint_error('BEN_ELIG_HLTH_CVG_PRTE_F_FK1');
156: --
157: end if;