APPS.BEN_ORG_DELETE dependencies on BEN_PER_CM_USG_F

Line 974: is select 1 from BEN_PER_CM_USG_F

970: is select 1 from BEN_CVRD_DPNT_CTFN_PRVDD_F
971: where business_group_id = p_bg_id;
972:
973: cursor c244(p_bg_id NUMBER)
974: is select 1 from BEN_PER_CM_USG_F
975: where business_group_id = p_bg_id;
976:
977: cursor c245(p_bg_id NUMBER)
978: is select 1 from BEN_POPL_ORG_ROLE_F

Line 4811: -- Testing for values in BEN_PER_CM_USG_F

4807: --
4808: close c243;
4809:
4810: --
4811: -- Testing for values in BEN_PER_CM_USG_F
4812: --
4813: open c244(p_bg_id);
4814: --
4815: fetch c244 into l_temp;

Line 4819: fnd_message.set_token('TABLE_NAME','BEN_PER_CM_USG_F');

4815: fetch c244 into l_temp;
4816: if c244%found then
4817: close c244;
4818: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4819: fnd_message.set_token('TABLE_NAME','BEN_PER_CM_USG_F');
4820: fnd_message.raise_error;
4821: end if;
4822: --
4823: close c244;

Line 6303: delete from BEN_PER_CM_USG_F

6299:
6300: delete from BEN_CVRD_DPNT_CTFN_PRVDD_F
6301: where business_group_id = p_bg_id;
6302:
6303: delete from BEN_PER_CM_USG_F
6304: where business_group_id = p_bg_id;
6305:
6306: delete from BEN_POPL_ORG_ROLE_F
6307: where business_group_id = p_bg_id;