APPS.BEN_ORG_DELETE dependencies on BEN_POPL_RPTG_GRP_F

Line 606: is select 1 from BEN_POPL_RPTG_GRP_F

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
607: where business_group_id = p_bg_id;
608:
609: cursor c153(p_bg_id NUMBER)
610: is select 1 from BEN_POPL_YR_PERD

Line 3431: -- Testing for values in BEN_POPL_RPTG_GRP_F

3427: --
3428: close c151;
3429:
3430: --
3431: -- Testing for values in BEN_POPL_RPTG_GRP_F
3432: --
3433: open c152(p_bg_id);
3434: --
3435: fetch c152 into l_temp;

Line 3439: fnd_message.set_token('TABLE_NAME','BEN_POPL_RPTG_GRP_F');

3435: fetch c152 into l_temp;
3436: if c152%found then
3437: close c152;
3438: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3439: fnd_message.set_token('TABLE_NAME','BEN_POPL_RPTG_GRP_F');
3440: fnd_message.raise_error;
3441: end if;
3442: --
3443: close c152;

Line 6027: delete from BEN_POPL_RPTG_GRP_F

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;
6029:
6030: delete from BEN_POPL_YR_PERD
6031: where business_group_id = p_bg_id;