APPS.BEN_ORG_DELETE dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 574: is select 1 from BEN_POPL_ENRT_TYP_CYCL_F

570: is select 1 from BEN_POPL_ACTN_TYP_F
571: where business_group_id = p_bg_id;
572:
573: cursor c144(p_bg_id NUMBER)
574: is select 1 from BEN_POPL_ENRT_TYP_CYCL_F
575: where business_group_id = p_bg_id;
576:
577: cursor c145(p_bg_id NUMBER)
578: is select 1 from BEN_POPL_ORG_F

Line 3311: -- Testing for values in BEN_POPL_ENRT_TYP_CYCL_F

3307: --
3308: close c143;
3309:
3310: --
3311: -- Testing for values in BEN_POPL_ENRT_TYP_CYCL_F
3312: --
3313: open c144(p_bg_id);
3314: --
3315: fetch c144 into l_temp;

Line 3319: fnd_message.set_token('TABLE_NAME','BEN_POPL_ENRT_TYP_CYCL_F');

3315: fetch c144 into l_temp;
3316: if c144%found then
3317: close c144;
3318: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3319: fnd_message.set_token('TABLE_NAME','BEN_POPL_ENRT_TYP_CYCL_F');
3320: fnd_message.raise_error;
3321: end if;
3322: --
3323: close c144;

Line 6003: delete from BEN_POPL_ENRT_TYP_CYCL_F

5999:
6000: delete from BEN_POPL_ACTN_TYP_F
6001: where business_group_id = p_bg_id;
6002:
6003: delete from BEN_POPL_ENRT_TYP_CYCL_F
6004: where business_group_id = p_bg_id;
6005:
6006: delete from BEN_POPL_ORG_F
6007: where business_group_id = p_bg_id;