APPS.BEN_ORG_DELETE dependencies on BEN_BATCH_PROC_INFO

Line 1026: is select 1 from BEN_BATCH_PROC_INFO

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
1027: where business_group_id = p_bg_id;
1028:
1029: cursor c258(p_bg_id NUMBER)
1030: is select 1 from BEN_PRTT_PREM_BY_MO_F

Line 5006: -- Testing for values in BEN_BATCH_PROC_INFO

5002: --
5003: close c256;
5004:
5005: --
5006: -- Testing for values in BEN_BATCH_PROC_INFO
5007: --
5008: open c257(p_bg_id);
5009: --
5010: fetch c257 into l_temp;

Line 5014: fnd_message.set_token('TABLE_NAME','BEN_BATCH_PROC_INFO');

5010: fetch c257 into l_temp;
5011: if c257%found then
5012: close c257;
5013: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5014: fnd_message.set_token('TABLE_NAME','BEN_BATCH_PROC_INFO');
5015: fnd_message.raise_error;
5016: end if;
5017: --
5018: close c257;

Line 6342: delete from BEN_BATCH_PROC_INFO

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;
6344:
6345: delete from BEN_PRTT_PREM_BY_MO_F
6346: where business_group_id = p_bg_id;