APPS.BEN_ORG_DELETE dependencies on BEN_OIPL_F

Line 510: is select 1 from BEN_OIPL_F

506: is select 1 from BEN_OIPLIP_F
507: where business_group_id = p_bg_id;
508:
509: cursor c128(p_bg_id NUMBER)
510: is select 1 from BEN_OIPL_F
511: where business_group_id = p_bg_id;
512:
513: cursor c129(p_bg_id NUMBER)
514: is select 1 from BEN_PGM_DPNT_CVG_CTFN_F

Line 3071: -- Testing for values in BEN_OIPL_F

3067: --
3068: close c127;
3069:
3070: --
3071: -- Testing for values in BEN_OIPL_F
3072: --
3073: open c128(p_bg_id);
3074: --
3075: fetch c128 into l_temp;

Line 3079: fnd_message.set_token('TABLE_NAME','BEN_OIPL_F');

3075: fetch c128 into l_temp;
3076: if c128%found then
3077: close c128;
3078: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3079: fnd_message.set_token('TABLE_NAME','BEN_OIPL_F');
3080: fnd_message.raise_error;
3081: end if;
3082: --
3083: close c128;

Line 5955: delete from BEN_OIPL_F

5951:
5952: delete from BEN_OIPLIP_F
5953: where business_group_id = p_bg_id;
5954:
5955: delete from BEN_OIPL_F
5956: where business_group_id = p_bg_id;
5957:
5958: delete from BEN_PGM_DPNT_CVG_CTFN_F
5959: where business_group_id = p_bg_id;