APPS.BEN_ORG_DELETE dependencies on BEN_POPL_YR_PERD

Line 610: is select 1 from BEN_POPL_YR_PERD

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
611: where business_group_id = p_bg_id;
612:
613: cursor c154(p_bg_id NUMBER)
614: is select 1 from BEN_PRTN_ELIG_F

Line 3446: -- Testing for values in BEN_POPL_YR_PERD

3442: --
3443: close c152;
3444:
3445: --
3446: -- Testing for values in BEN_POPL_YR_PERD
3447: --
3448: open c153(p_bg_id);
3449: --
3450: fetch c153 into l_temp;

Line 3454: fnd_message.set_token('TABLE_NAME','BEN_POPL_YR_PERD');

3450: fetch c153 into l_temp;
3451: if c153%found then
3452: close c153;
3453: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3454: fnd_message.set_token('TABLE_NAME','BEN_POPL_YR_PERD');
3455: fnd_message.raise_error;
3456: end if;
3457: --
3458: close c153;

Line 6030: delete from BEN_POPL_YR_PERD

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;
6032:
6033: delete from BEN_PRTN_ELIG_F
6034: where business_group_id = p_bg_id;