DBA Data[Home] [Help]

APPS.BEN_CLA_BUS dependencies on BEN_CMBN_AGE_LOS_FCTR

Line 334: from ben_cmbn_age_los_fctr cla

330: l_dummy varchar2(1);
331: --
332: cursor c1 is
333: select null
334: from ben_cmbn_age_los_fctr cla
335: where cla.business_group_id = p_business_group_id and
336: cla.name = p_name;
337: Begin
338: --

Line 389: -- BEN_CMBN_AGE_LOS_FCTR table.

385: --
386: -- Description
387: -- This procedure is used to check that Combined age and LOS child records do not
388: -- exist when the user deletes the record in the
389: -- BEN_CMBN_AGE_LOS_FCTR table.
390: --
391: -- Pre Conditions
392: -- None.
393: --

Line 561: ben_cmbn_age_los_fctr b

557: --
558: cursor csr_leg_code is
559: select a.legislation_code
560: from per_business_groups a,
561: ben_cmbn_age_los_fctr b
562: where b.cmbn_age_los_fctr_id = p_cmbn_age_los_fctr_id
563: and a.business_group_id = b.business_group_id;
564: --
565: -- Declare local variables