APPS.BEN_ORG_DELETE dependencies on BEN_PER_CM_PRVDD_F

Line 1034: is select 1 from BEN_PER_CM_PRVDD_F

1030: is select 1 from BEN_PRTT_PREM_BY_MO_F
1031: where business_group_id = p_bg_id;
1032:
1033: cursor c259(p_bg_id NUMBER)
1034: is select 1 from BEN_PER_CM_PRVDD_F
1035: where business_group_id = p_bg_id;
1036:
1037: cursor c260(p_bg_id NUMBER)
1038: is select 1 from BEN_PRTT_REIMBMT_RQST_F

Line 5036: -- Testing for values in BEN_PER_CM_PRVDD_F

5032: --
5033: close c258;
5034:
5035: --
5036: -- Testing for values in BEN_PER_CM_PRVDD_F
5037: --
5038: open c259(p_bg_id);
5039: --
5040: fetch c259 into l_temp;

Line 5044: fnd_message.set_token('TABLE_NAME','BEN_PER_CM_PRVDD_F');

5040: fetch c259 into l_temp;
5041: if c259%found then
5042: close c259;
5043: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5044: fnd_message.set_token('TABLE_NAME','BEN_PER_CM_PRVDD_F');
5045: fnd_message.raise_error;
5046: end if;
5047: --
5048: close c259;

Line 6348: delete from BEN_PER_CM_PRVDD_F

6344:
6345: delete from BEN_PRTT_PREM_BY_MO_F
6346: where business_group_id = p_bg_id;
6347:
6348: delete from BEN_PER_CM_PRVDD_F
6349: where business_group_id = p_bg_id;
6350:
6351: delete from BEN_PRTT_REIMBMT_RQST_F
6352: where business_group_id = p_bg_id;