APPS.BEN_ORG_DELETE dependencies on BEN_PER_CM_TRGR_F

Line 954: is select 1 from BEN_PER_CM_TRGR_F

950: is select 1 from BEN_PER_CM_F
951: where business_group_id = p_bg_id;
952:
953: cursor c239(p_bg_id NUMBER)
954: is select 1 from BEN_PER_CM_TRGR_F
955: where business_group_id = p_bg_id;
956:
957: cursor c240(p_bg_id NUMBER)
958: is select 1 from BEN_PL_BNF_CTFN_PRVDD_F

Line 4736: -- Testing for values in BEN_PER_CM_TRGR_F

4732: --
4733: close c238;
4734:
4735: --
4736: -- Testing for values in BEN_PER_CM_TRGR_F
4737: --
4738: open c239(p_bg_id);
4739: --
4740: fetch c239 into l_temp;

Line 4744: fnd_message.set_token('TABLE_NAME','BEN_PER_CM_TRGR_F');

4740: fetch c239 into l_temp;
4741: if c239%found then
4742: close c239;
4743: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4744: fnd_message.set_token('TABLE_NAME','BEN_PER_CM_TRGR_F');
4745: fnd_message.raise_error;
4746: end if;
4747: --
4748: close c239;

Line 6288: delete from BEN_PER_CM_TRGR_F

6284:
6285: delete from BEN_PER_CM_F
6286: where business_group_id = p_bg_id;
6287:
6288: delete from BEN_PER_CM_TRGR_F
6289: where business_group_id = p_bg_id;
6290:
6291: delete from BEN_PL_BNF_CTFN_PRVDD_F
6292: where business_group_id = p_bg_id;