APPS.BEN_ORG_DELETE dependencies on BEN_PL_REGY_PRP_F

Line 910: is select 1 from BEN_PL_REGY_PRP_F

906: is select 1 from BEN_LEE_RSN_RL_F
907: where business_group_id = p_bg_id;
908:
909: cursor c228(p_bg_id NUMBER)
910: is select 1 from BEN_PL_REGY_PRP_F
911: where business_group_id = p_bg_id;
912:
913: cursor c229(p_bg_id NUMBER)
914: is select 1 from BEN_SCHEDD_ENRT_RL_F

Line 4571: -- Testing for values in BEN_PL_REGY_PRP_F

4567: --
4568: close c227;
4569:
4570: --
4571: -- Testing for values in BEN_PL_REGY_PRP_F
4572: --
4573: open c228(p_bg_id);
4574: --
4575: fetch c228 into l_temp;

Line 4579: fnd_message.set_token('TABLE_NAME','BEN_PL_REGY_PRP_F');

4575: fetch c228 into l_temp;
4576: if c228%found then
4577: close c228;
4578: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4579: fnd_message.set_token('TABLE_NAME','BEN_PL_REGY_PRP_F');
4580: fnd_message.raise_error;
4581: end if;
4582: --
4583: close c228;

Line 6255: delete from BEN_PL_REGY_PRP_F

6251:
6252: delete from BEN_LEE_RSN_RL_F
6253: where business_group_id = p_bg_id;
6254:
6255: delete from BEN_PL_REGY_PRP_F
6256: where business_group_id = p_bg_id;
6257:
6258: delete from BEN_SCHEDD_ENRT_RL_F
6259: where business_group_id = p_bg_id;