APPS.BEN_ORG_DELETE dependencies on BEN_BATCH_ELCTBL_CHC_INFO

Line 998: is select 1 from BEN_BATCH_ELCTBL_CHC_INFO

994: is select 1 from BEN_BATCH_DPNT_INFO
995: where business_group_id = p_bg_id;
996:
997: cursor c250(p_bg_id NUMBER)
998: is select 1 from BEN_BATCH_ELCTBL_CHC_INFO
999: where business_group_id = p_bg_id;
1000:
1001: cursor c251(p_bg_id NUMBER)
1002: is select 1 from BEN_BATCH_ELIG_INFO

Line 4901: -- Testing for values in BEN_BATCH_ELCTBL_CHC_INFO

4897: --
4898: close c249;
4899:
4900: --
4901: -- Testing for values in BEN_BATCH_ELCTBL_CHC_INFO
4902: --
4903: open c250(p_bg_id);
4904: --
4905: fetch c250 into l_temp;

Line 4909: fnd_message.set_token('TABLE_NAME','BEN_BATCH_ELCTBL_CHC_INFO');

4905: fetch c250 into l_temp;
4906: if c250%found then
4907: close c250;
4908: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4909: fnd_message.set_token('TABLE_NAME','BEN_BATCH_ELCTBL_CHC_INFO');
4910: fnd_message.raise_error;
4911: end if;
4912: --
4913: close c250;

Line 6321: delete from BEN_BATCH_ELCTBL_CHC_INFO

6317:
6318: delete from BEN_BATCH_DPNT_INFO
6319: where business_group_id = p_bg_id;
6320:
6321: delete from BEN_BATCH_ELCTBL_CHC_INFO
6322: where business_group_id = p_bg_id;
6323:
6324: delete from BEN_BATCH_ELIG_INFO
6325: where business_group_id = p_bg_id;