DBA Data[Home] [Help]

APPS.BEN_LSR_BUS dependencies on BEN_LOS_FCTR

Line 214: -- BEN_LOS_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_LOS_FCTR table.
215: --
216: -- Pre Conditions
217: -- None.
218: --

Line 220: -- los_fctr_id FK of pointing to BEN_LOS_FCTR tables.

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

Line 238: from BEN_LOS_FCTR

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: