APPS.BEN_BTR_BUS dependencies on BEN_COMP_LVL_ACTY_RT_F

Line 145: ben_btr_shd.constraint_error('BEN_COMP_LVL_ACTY_RT_FK2');

141: --
142: -- raise error as FK does not relate to PK in ben_comp_lvl_fctr
143: -- table.
144: --
145: ben_btr_shd.constraint_error('BEN_COMP_LVL_ACTY_RT_FK2');
146: --
147: end if;
148: --
149: close c1;

Line 269: from ben_comp_lvl_acty_rt_f a

265: l_dummy varchar2(1);
266: --
267: cursor c1 is
268: select null
269: from ben_comp_lvl_acty_rt_f a
270: where a.business_group_id + 0 = p_business_group_id
271: and a.acty_base_rt_id = p_acty_base_rt_id
272: and a.dflt_flag = 'Y'
273: and p_effective_date

Line 658: ben_comp_lvl_acty_rt_f b

654: --
655: cursor csr_leg_code is
656: select a.legislation_code
657: from per_business_groups a,
658: ben_comp_lvl_acty_rt_f b
659: where b.comp_lvl_acty_rt_id = p_comp_lvl_acty_rt_id
660: and a.business_group_id = b.business_group_id;
661: --
662: -- Declare local variables