APPS.BEN_ORG_DELETE dependencies on BEN_ACRS_PTIP_CVG_F

Line 418: is select 1 from BEN_ACRS_PTIP_CVG_F

414: is select 1 from BEN_PER_IN_ORG_ROLE_F
415: where business_group_id = p_bg_id;
416:
417: cursor c104(p_bg_id NUMBER)
418: is select 1 from BEN_ACRS_PTIP_CVG_F
419: where business_group_id = p_bg_id;
420:
421: cursor c105(p_bg_id NUMBER)
422: is select 1 from BEN_PL_TYP_OPT_TYP_F

Line 2726: -- Testing for values in BEN_ACRS_PTIP_CVG_F

2722: --
2723: close c103;
2724:
2725: --
2726: -- Testing for values in BEN_ACRS_PTIP_CVG_F
2727: --
2728: open c104(p_bg_id);
2729: --
2730: fetch c104 into l_temp;

Line 2734: fnd_message.set_token('TABLE_NAME','BEN_ACRS_PTIP_CVG_F');

2730: fetch c104 into l_temp;
2731: if c104%found then
2732: close c104;
2733: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2734: fnd_message.set_token('TABLE_NAME','BEN_ACRS_PTIP_CVG_F');
2735: fnd_message.raise_error;
2736: end if;
2737: --
2738: close c104;

Line 5886: delete from BEN_ACRS_PTIP_CVG_F

5882:
5883: delete from BEN_PER_IN_ORG_ROLE_F
5884: where business_group_id = p_bg_id;
5885:
5886: delete from BEN_ACRS_PTIP_CVG_F
5887: where business_group_id = p_bg_id;
5888:
5889: delete from BEN_PL_TYP_OPT_TYP_F
5890: where business_group_id = p_bg_id;