APPS.BEN_ORG_DELETE dependencies on BEN_BNFT_PRVDD_LDGR_F

Line 1086: is select 1 from BEN_BNFT_PRVDD_LDGR_F

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
1087: where business_group_id = p_bg_id;
1088:
1089: cursor c273(p_bg_id NUMBER)
1090: is select 1 from BEN_COMP_LVL_ACTY_RT_F

Line 5231: -- Testing for values in BEN_BNFT_PRVDD_LDGR_F

5227: --
5228: close c271;
5229:
5230: --
5231: -- Testing for values in BEN_BNFT_PRVDD_LDGR_F
5232: --
5233: open c272(p_bg_id);
5234: --
5235: fetch c272 into l_temp;

Line 5239: fnd_message.set_token('TABLE_NAME','BEN_BNFT_PRVDD_LDGR_F');

5235: fetch c272 into l_temp;
5236: if c272%found then
5237: close c272;
5238: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5239: fnd_message.set_token('TABLE_NAME','BEN_BNFT_PRVDD_LDGR_F');
5240: fnd_message.raise_error;
5241: end if;
5242: --
5243: close c272;

Line 6387: delete from BEN_BNFT_PRVDD_LDGR_F

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;
6389:
6390: delete from BEN_COMP_LVL_ACTY_RT_F
6391: where business_group_id = p_bg_id;