APPS.BEN_ORG_DELETE dependencies on BEN_BNFT_POOL_RLOVR_RQMT_F

Line 1082: is select 1 from BEN_BNFT_POOL_RLOVR_RQMT_F

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
1083: where business_group_id = p_bg_id;
1084:
1085: cursor c272(p_bg_id NUMBER)
1086: is select 1 from BEN_BNFT_PRVDD_LDGR_F

Line 5216: -- Testing for values in BEN_BNFT_POOL_RLOVR_RQMT_F

5212: --
5213: close c270;
5214:
5215: --
5216: -- Testing for values in BEN_BNFT_POOL_RLOVR_RQMT_F
5217: --
5218: open c271(p_bg_id);
5219: --
5220: fetch c271 into l_temp;

Line 5224: fnd_message.set_token('TABLE_NAME','BEN_BNFT_POOL_RLOVR_RQMT_F');

5220: fetch c271 into l_temp;
5221: if c271%found then
5222: close c271;
5223: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5224: fnd_message.set_token('TABLE_NAME','BEN_BNFT_POOL_RLOVR_RQMT_F');
5225: fnd_message.raise_error;
5226: end if;
5227: --
5228: close c271;

Line 6384: delete from BEN_BNFT_POOL_RLOVR_RQMT_F

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;
6386:
6387: delete from BEN_BNFT_PRVDD_LDGR_F
6388: where business_group_id = p_bg_id;