APPS.BEN_ORG_DELETE dependencies on BEN_PRTT_PREM_BY_MO_F

Line 1030: is select 1 from BEN_PRTT_PREM_BY_MO_F

1026: is select 1 from BEN_BATCH_PROC_INFO
1027: where business_group_id = p_bg_id;
1028:
1029: cursor c258(p_bg_id NUMBER)
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

Line 5021: -- Testing for values in BEN_PRTT_PREM_BY_MO_F

5017: --
5018: close c257;
5019:
5020: --
5021: -- Testing for values in BEN_PRTT_PREM_BY_MO_F
5022: --
5023: open c258(p_bg_id);
5024: --
5025: fetch c258 into l_temp;

Line 5029: fnd_message.set_token('TABLE_NAME','BEN_PRTT_PREM_BY_MO_F');

5025: fetch c258 into l_temp;
5026: if c258%found then
5027: close c258;
5028: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5029: fnd_message.set_token('TABLE_NAME','BEN_PRTT_PREM_BY_MO_F');
5030: fnd_message.raise_error;
5031: end if;
5032: --
5033: close c258;

Line 6345: delete from BEN_PRTT_PREM_BY_MO_F

6341:
6342: delete from BEN_BATCH_PROC_INFO
6343: where business_group_id = p_bg_id;
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;