APPS.BEN_ORG_DELETE dependencies on BEN_LEE_RSN_RL_F

Line 906: is select 1 from BEN_LEE_RSN_RL_F

902: is select 1 from BEN_ELIG_DPNT
903: where business_group_id = p_bg_id;
904:
905: cursor c227(p_bg_id NUMBER)
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

Line 4556: -- Testing for values in BEN_LEE_RSN_RL_F

4552: --
4553: close c226;
4554:
4555: --
4556: -- Testing for values in BEN_LEE_RSN_RL_F
4557: --
4558: open c227(p_bg_id);
4559: --
4560: fetch c227 into l_temp;

Line 4564: fnd_message.set_token('TABLE_NAME','BEN_LEE_RSN_RL_F');

4560: fetch c227 into l_temp;
4561: if c227%found then
4562: close c227;
4563: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4564: fnd_message.set_token('TABLE_NAME','BEN_LEE_RSN_RL_F');
4565: fnd_message.raise_error;
4566: end if;
4567: --
4568: close c227;

Line 6252: delete from BEN_LEE_RSN_RL_F

6248:
6249: delete from BEN_ELIG_DPNT
6250: where business_group_id = p_bg_id;
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;