APPS.BEN_ORG_DELETE dependencies on BEN_AGE_RT_F

Line 798: is select 1 from BEN_AGE_RT_F

794: is select 1 from BEN_PIL_ELCTBL_CHC_POPL
795: where business_group_id = p_bg_id;
796:
797: cursor c200(p_bg_id NUMBER)
798: is select 1 from BEN_AGE_RT_F
799: where business_group_id = p_bg_id;
800:
801: cursor c201(p_bg_id NUMBER)
802: is select 1 from BEN_ASNT_SET_RT_F

Line 4151: -- Testing for values in BEN_AGE_RT_F

4147: --
4148: close c199;
4149:
4150: --
4151: -- Testing for values in BEN_AGE_RT_F
4152: --
4153: open c200(p_bg_id);
4154: --
4155: fetch c200 into l_temp;

Line 4159: fnd_message.set_token('TABLE_NAME','BEN_AGE_RT_F');

4155: fetch c200 into l_temp;
4156: if c200%found then
4157: close c200;
4158: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4159: fnd_message.set_token('TABLE_NAME','BEN_AGE_RT_F');
4160: fnd_message.raise_error;
4161: end if;
4162: --
4163: close c200;

Line 6171: delete from BEN_AGE_RT_F

6167:
6168: delete from BEN_PIL_ELCTBL_CHC_POPL
6169: where business_group_id = p_bg_id;
6170:
6171: delete from BEN_AGE_RT_F
6172: where business_group_id = p_bg_id;
6173:
6174: delete from BEN_ASNT_SET_RT_F
6175: where business_group_id = p_bg_id;