APPS.BEN_ORG_DELETE dependencies on BEN_PER_INFO_CHG_CS_LER_F

Line 14: is select 1 from BEN_PER_INFO_CHG_CS_LER_F

10: --is select 1 from BEN_HLTH_CVG_SLCTD_RT_F
11: --where business_group_id = p_bg_id;
12:
13: cursor c3(p_bg_id NUMBER)
14: is select 1 from BEN_PER_INFO_CHG_CS_LER_F
15: where business_group_id = p_bg_id;
16:
17: --cursor c4(p_bg_id NUMBER)
18: --is select 1 from BEN_PRTN_IN_ANTHR_PL_RT_F

Line 1211: -- Testing for values in BEN_PER_INFO_CHG_CS_LER_F

1207: --
1208: --close c2;
1209:
1210: --
1211: -- Testing for values in BEN_PER_INFO_CHG_CS_LER_F
1212: --
1213: open c3(p_bg_id);
1214: --
1215: fetch c3 into l_temp;

Line 1219: fnd_message.set_token('TABLE_NAME','BEN_PER_INFO_CHG_CS_LER_F');

1215: fetch c3 into l_temp;
1216: if c3%found then
1217: close c3;
1218: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1219: fnd_message.set_token('TABLE_NAME','BEN_PER_INFO_CHG_CS_LER_F');
1220: fnd_message.raise_error;
1221: end if;
1222: --
1223: close c3;

Line 5583: delete from BEN_PER_INFO_CHG_CS_LER_F

5579:
5580: --delete from BEN_HLTH_CVG_SLCTD_RT_F
5581: --where business_group_id = p_bg_id;
5582:
5583: delete from BEN_PER_INFO_CHG_CS_LER_F
5584: where business_group_id = p_bg_id;
5585:
5586: --delete from BEN_PRTN_IN_ANTHR_PL_RT_F
5587: --where business_group_id = p_bg_id;