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_COMP_LVL_FCTR table.
215: --
216: -- Pre Conditions
217: -- None.
218: --
216: -- Pre Conditions
217: -- None.
218: --
219: -- In Parameters
220: -- comp_lvl_fctr_id FK of pointing to BEN_COMP_LVL_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_comp_lvl_fctr_id';
236: l_dummy varchar2(1);
237: cursor c1 is select null
238: from BEN_COMP_LVL_FCTR
239: where comp_lvl_fctr_id = p_comp_lvl_fctr_id
240: and business_group_id = p_business_group_id;
241: --
242: