APPS.BEN_ORG_DELETE dependencies on BEN_RLTD_PER_CHG_CS_LER_F

Line 26: is select 1 from BEN_RLTD_PER_CHG_CS_LER_F

22: --is select 1 from BEN_PRTT_PREM_BY_MO_CR_F
23: --where business_group_id = p_bg_id;
24:
25: cursor c6(p_bg_id NUMBER)
26: is select 1 from BEN_RLTD_PER_CHG_CS_LER_F
27: where business_group_id = p_bg_id;
28:
29: cursor c7(p_bg_id NUMBER)
30: is select 1 from BEN_PCT_FL_TM_FCTR

Line 1256: -- Testing for values in BEN_RLTD_PER_CHG_CS_LER_F

1252: --
1253: --close c5;
1254:
1255: --
1256: -- Testing for values in BEN_RLTD_PER_CHG_CS_LER_F
1257: --
1258: open c6(p_bg_id);
1259: --
1260: fetch c6 into l_temp;

Line 1264: fnd_message.set_token('TABLE_NAME','BEN_RLTD_PER_CHG_CS_LER_F');

1260: fetch c6 into l_temp;
1261: if c6%found then
1262: close c6;
1263: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1264: fnd_message.set_token('TABLE_NAME','BEN_RLTD_PER_CHG_CS_LER_F');
1265: fnd_message.raise_error;
1266: end if;
1267: --
1268: close c6;

Line 5592: delete from BEN_RLTD_PER_CHG_CS_LER_F

5588:
5589: --delete from BEN_PRTT_PREM_BY_MO_CR_F
5590: --where business_group_id = p_bg_id;
5591:
5592: delete from BEN_RLTD_PER_CHG_CS_LER_F
5593: where business_group_id = p_bg_id;
5594:
5595: delete from BEN_PCT_FL_TM_FCTR
5596: where business_group_id = p_bg_id;