113: l_dummy varchar2(1);
114: --
115: cursor c1 is
116: select null
117: from ben_pl_f pln
118: where pln.pl_id = p_pl_id
119: and pln.business_group_id = p_business_group_id
120: and p_effective_date
121: between pln.effective_start_date and pln.effective_end_date;
135: or not l_api_updating)
136: and p_pl_id is not null then
137: --
138: -- check if pl_id value exists in
139: -- ben_pl_f table
140: --
141: open c1;
142: --
143: fetch c1 into l_dummy;
145: --
146: close c1;
147: --
148: -- raise error as FK does not relate to PK in
149: -- ben_pl_f table.
150: --
151: ben_eop_shd.constraint_error('BEN_ELIG_ANTHR_PL_PRTE_F_FK3');
152: --
153: end if;