APPS.BEN_ORG_DELETE dependencies on BEN_PL_PCP_TYP

Line 1170: is select 1 from BEN_PL_PCP_TYP

1166: is select 1 from BEN_PL_PCP
1167: where business_group_id = p_bg_id;
1168:
1169: cursor c293(p_bg_id NUMBER)
1170: is select 1 from BEN_PL_PCP_TYP
1171: where business_group_id = p_bg_id;
1172:
1173: cursor c294(p_bg_id NUMBER)
1174: is select 1 from BEN_OPTIP_F

Line 5544: -- Testing for values in BEN_PL_PCP_TYP

5540: end if;
5541: --
5542: close c292;
5543: --
5544: -- Testing for values in BEN_PL_PCP_TYP
5545: --
5546: open c293(p_bg_id);
5547: --
5548: fetch c293 into l_temp;

Line 5552: fnd_message.set_token('TABLE_NAME','BEN_PL_PCP_TYP');

5548: fetch c293 into l_temp;
5549: if c293%found then
5550: close c293;
5551: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5552: fnd_message.set_token('TABLE_NAME','BEN_PL_PCP_TYP');
5553: fnd_message.raise_error;
5554: end if;
5555: --
5556: close c293;

Line 6450: delete from BEN_PL_PCP_TYP

6446:
6447: delete from BEN_PL_PCP
6448: where business_group_id = p_bg_id;
6449:
6450: delete from BEN_PL_PCP_TYP
6451: where business_group_id = p_bg_id;
6452:
6453: delete from BEN_OPTIP_F
6454: where business_group_id = p_bg_id;