DBA Data[Home] [Help]

APPS.BEN_CLR_BUS dependencies on BEN_COMP_LVL_FCTR

Line 214: -- BEN_COMP_LVL_FCTR table.

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: --

Line 220: -- comp_lvl_fctr_id FK of pointing to BEN_COMP_LVL_FCTR tables.

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

Line 238: from BEN_COMP_LVL_FCTR

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: