APPS.BEN_ORG_DELETE dependencies on BEN_PL_R_OIPL_ASSET_F

Line 602: is select 1 from BEN_PL_R_OIPL_ASSET_F

598: is select 1 from BEN_LEE_RSN_F
599: where business_group_id = p_bg_id;
600:
601: cursor c151(p_bg_id NUMBER)
602: is select 1 from BEN_PL_R_OIPL_ASSET_F
603: where business_group_id = p_bg_id;
604:
605: cursor c152(p_bg_id NUMBER)
606: is select 1 from BEN_POPL_RPTG_GRP_F

Line 3416: -- Testing for values in BEN_PL_R_OIPL_ASSET_F

3412: --
3413: close c150;
3414:
3415: --
3416: -- Testing for values in BEN_PL_R_OIPL_ASSET_F
3417: --
3418: open c151(p_bg_id);
3419: --
3420: fetch c151 into l_temp;

Line 3424: fnd_message.set_token('TABLE_NAME','BEN_PL_R_OIPL_ASSET_F');

3420: fetch c151 into l_temp;
3421: if c151%found then
3422: close c151;
3423: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3424: fnd_message.set_token('TABLE_NAME','BEN_PL_R_OIPL_ASSET_F');
3425: fnd_message.raise_error;
3426: end if;
3427: --
3428: close c151;

Line 6024: delete from BEN_PL_R_OIPL_ASSET_F

6020:
6021: delete from BEN_LEE_RSN_F
6022: where business_group_id = p_bg_id;
6023:
6024: delete from BEN_PL_R_OIPL_ASSET_F
6025: where business_group_id = p_bg_id;
6026:
6027: delete from BEN_POPL_RPTG_GRP_F
6028: where business_group_id = p_bg_id;