APPS.BEN_CMR_BUS dependencies on BEN_CMBN_AGE_LOS_RT_F

Line 249: from ben_cmbn_age_los_rt_f

245: l_exists varchar2(1);
246: --
247: cursor c_dup is
248: select null
249: from ben_cmbn_age_los_rt_f
250: where cmbn_age_los_fctr_id = p_cmbn_age_los_fctr_id
251: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
252: and cmbn_age_los_rt_id <> nvl(p_cmbn_age_los_rt_id,hr_api.g_number)
253: and business_group_id + 0 = p_business_group_id

Line 329: from ben_cmbn_age_los_rt_f

325: is
326: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
327: l_dummy char(1);
328: cursor c1 is select null
329: from ben_cmbn_age_los_rt_f
330: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
331: -- changed against bug: 5113011
332: and cmbn_age_los_rt_id <> nvl(p_cmbn_age_los_rt_id ,-1)
333: --and cmbn_age_los_fctr_id <> nvl(p_cmbn_age_los_fctr_id ,-1)

Line 719: ben_cmbn_age_los_rt_f b

715: --
716: cursor csr_leg_code is
717: select a.legislation_code
718: from per_business_groups a,
719: ben_cmbn_age_los_rt_f b
720: where b.cmbn_age_los_rt_id = p_cmbn_age_los_rt_id
721: and a.business_group_id = b.business_group_id;
722: --
723: -- Declare local variables