APPS.BEN_ORG_DELETE dependencies on BEN_PREM_CSTG_BY_SGMT_F

Line 1022: is select 1 from BEN_PREM_CSTG_BY_SGMT_F

1018: is select 1 from BEN_CLPSE_LF_EVT_F
1019: where business_group_id = p_bg_id;
1020:
1021: cursor c256(p_bg_id NUMBER)
1022: is select 1 from BEN_PREM_CSTG_BY_SGMT_F
1023: where business_group_id = p_bg_id;
1024:
1025: cursor c257(p_bg_id NUMBER)
1026: is select 1 from BEN_BATCH_PROC_INFO

Line 4991: -- Testing for values in BEN_PREM_CSTG_BY_SGMT_F

4987: --
4988: close c255;
4989:
4990: --
4991: -- Testing for values in BEN_PREM_CSTG_BY_SGMT_F
4992: --
4993: open c256(p_bg_id);
4994: --
4995: fetch c256 into l_temp;

Line 4999: fnd_message.set_token('TABLE_NAME','BEN_PREM_CSTG_BY_SGMT_F');

4995: fetch c256 into l_temp;
4996: if c256%found then
4997: close c256;
4998: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4999: fnd_message.set_token('TABLE_NAME','BEN_PREM_CSTG_BY_SGMT_F');
5000: fnd_message.raise_error;
5001: end if;
5002: --
5003: close c256;

Line 6339: delete from BEN_PREM_CSTG_BY_SGMT_F

6335:
6336: delete from BEN_CLPSE_LF_EVT_F
6337: where business_group_id = p_bg_id;
6338:
6339: delete from BEN_PREM_CSTG_BY_SGMT_F
6340: where business_group_id = p_bg_id;
6341:
6342: delete from BEN_BATCH_PROC_INFO
6343: where business_group_id = p_bg_id;