APPS.BEN_ORG_DELETE dependencies on BEN_APLCN_TO_BNFT_POOL_F

Line 1078: is select 1 from BEN_APLCN_TO_BNFT_POOL_F

1074: is select 1 from BEN_ACTY_VRBL_RT_F
1075: where business_group_id = p_bg_id;
1076:
1077: cursor c270(p_bg_id NUMBER)
1078: is select 1 from BEN_APLCN_TO_BNFT_POOL_F
1079: where business_group_id = p_bg_id;
1080:
1081: cursor c271(p_bg_id NUMBER)
1082: is select 1 from BEN_BNFT_POOL_RLOVR_RQMT_F

Line 5201: -- Testing for values in BEN_APLCN_TO_BNFT_POOL_F

5197: --
5198: close c269;
5199:
5200: --
5201: -- Testing for values in BEN_APLCN_TO_BNFT_POOL_F
5202: --
5203: open c270(p_bg_id);
5204: --
5205: fetch c270 into l_temp;

Line 5209: fnd_message.set_token('TABLE_NAME','BEN_APLCN_TO_BNFT_POOL_F');

5205: fetch c270 into l_temp;
5206: if c270%found then
5207: close c270;
5208: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5209: fnd_message.set_token('TABLE_NAME','BEN_APLCN_TO_BNFT_POOL_F');
5210: fnd_message.raise_error;
5211: end if;
5212: --
5213: close c270;

Line 6381: delete from BEN_APLCN_TO_BNFT_POOL_F

6377:
6378: delete from BEN_ACTY_VRBL_RT_F
6379: where business_group_id = p_bg_id;
6380:
6381: delete from BEN_APLCN_TO_BNFT_POOL_F
6382: where business_group_id = p_bg_id;
6383:
6384: delete from BEN_BNFT_POOL_RLOVR_RQMT_F
6385: where business_group_id = p_bg_id;