APPS.BEN_ORG_DELETE dependencies on BEN_POPL_ACTN_TYP_F

Line 570: is select 1 from BEN_POPL_ACTN_TYP_F

566: is select 1 from BEN_PL_REGY_BOD_F
567: where business_group_id = p_bg_id;
568:
569: cursor c143(p_bg_id NUMBER)
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

Line 3296: -- Testing for values in BEN_POPL_ACTN_TYP_F

3292: --
3293: close c142;
3294:
3295: --
3296: -- Testing for values in BEN_POPL_ACTN_TYP_F
3297: --
3298: open c143(p_bg_id);
3299: --
3300: fetch c143 into l_temp;

Line 3304: fnd_message.set_token('TABLE_NAME','BEN_POPL_ACTN_TYP_F');

3300: fetch c143 into l_temp;
3301: if c143%found then
3302: close c143;
3303: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3304: fnd_message.set_token('TABLE_NAME','BEN_POPL_ACTN_TYP_F');
3305: fnd_message.raise_error;
3306: end if;
3307: --
3308: close c143;

Line 6000: delete from BEN_POPL_ACTN_TYP_F

5996:
5997: delete from BEN_PL_REGY_BOD_F
5998: where business_group_id = p_bg_id;
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;