APPS.BEN_ORG_DELETE dependencies on BEN_PCT_FL_TM_FCTR

Line 30: is select 1 from BEN_PCT_FL_TM_FCTR

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
31: where business_group_id = p_bg_id;
32:
33: cursor c8(p_bg_id NUMBER)
34: is select 1 from BEN_AGE_FCTR

Line 1271: -- Testing for values in BEN_PCT_FL_TM_FCTR

1267: --
1268: close c6;
1269:
1270: --
1271: -- Testing for values in BEN_PCT_FL_TM_FCTR
1272: --
1273: open c7(p_bg_id);
1274: --
1275: fetch c7 into l_temp;

Line 1279: fnd_message.set_token('TABLE_NAME','BEN_PCT_FL_TM_FCTR');

1275: fetch c7 into l_temp;
1276: if c7%found then
1277: close c7;
1278: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1279: fnd_message.set_token('TABLE_NAME','BEN_PCT_FL_TM_FCTR');
1280: fnd_message.raise_error;
1281: end if;
1282: --
1283: close c7;

Line 5595: delete from BEN_PCT_FL_TM_FCTR

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;
5597:
5598: delete from BEN_AGE_FCTR
5599: where business_group_id = p_bg_id;