APPS.BEN_ORG_DELETE dependencies on BEN_CBR_PER_IN_LER

Line 442: is select 1 from BEN_CBR_PER_IN_LER

438: is select 1 from BEN_LER_RLTD_PER_CS_LER_F
439: where business_group_id = p_bg_id;
440:
441: cursor c110(p_bg_id NUMBER)
442: is select 1 from BEN_CBR_PER_IN_LER
443: where business_group_id = p_bg_id;
444:
445: cursor c111(p_bg_id NUMBER)
446: is select 1 from BEN_CSS_RLTD_PER_PER_IN_LER_F

Line 2816: -- Testing for values in BEN_CBR_PER_IN_LER

2812: --
2813: close c109;
2814:
2815: --
2816: -- Testing for values in BEN_CBR_PER_IN_LER
2817: --
2818: open c110(p_bg_id);
2819: --
2820: fetch c110 into l_temp;

Line 2824: fnd_message.set_token('TABLE_NAME','BEN_CBR_PER_IN_LER');

2820: fetch c110 into l_temp;
2821: if c110%found then
2822: close c110;
2823: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2824: fnd_message.set_token('TABLE_NAME','BEN_CBR_PER_IN_LER');
2825: fnd_message.raise_error;
2826: end if;
2827: --
2828: close c110;

Line 5904: delete from BEN_CBR_PER_IN_LER

5900:
5901: delete from BEN_LER_RLTD_PER_CS_LER_F
5902: where business_group_id = p_bg_id;
5903:
5904: delete from BEN_CBR_PER_IN_LER
5905: where business_group_id = p_bg_id;
5906:
5907: delete from BEN_CSS_RLTD_PER_PER_IN_LER_F
5908: where business_group_id = p_bg_id;