210: --
211: -- Description
212: -- This procedure is used to check that the foreign key for the table
213: -- is created properly. a corresponding record should exist in the
214: -- BEN_LOS_FCTR table.
215: --
216: -- Pre Conditions
217: -- None.
218: --
216: -- Pre Conditions
217: -- None.
218: --
219: -- In Parameters
220: -- los_fctr_id FK of pointing to BEN_LOS_FCTR tables.
221: -- business_group_id or record being inserted or updated
222: --
223: -- Post Success
224: -- Processing continues
234: --
235: l_proc varchar2(72) := g_package||'chk_los_fctr_id';
236: l_dummy varchar2(1);
237: cursor c1 is select null
238: from BEN_LOS_FCTR
239: where los_fctr_id = p_los_fctr_id
240: and business_group_id = p_business_group_id;
241: --
242: