APPS.BEN_ORG_DELETE dependencies on BEN_PRTT_VSTG_F

Line 1134: is select 1 from BEN_PRTT_VSTG_F

1130: is select 1 from BEN_PRTT_RT_VAL
1131: where business_group_id = p_bg_id;
1132:
1133: cursor c284(p_bg_id NUMBER)
1134: is select 1 from BEN_PRTT_VSTG_F
1135: where business_group_id = p_bg_id;
1136:
1137: cursor c285(p_bg_id NUMBER)
1138: is select 1 from BEN_ENRT_RT

Line 5411: -- Testing for values in BEN_PRTT_VSTG_F

5407: --
5408: close c283;
5409:
5410: --
5411: -- Testing for values in BEN_PRTT_VSTG_F
5412: --
5413: open c284(p_bg_id);
5414: --
5415: fetch c284 into l_temp;

Line 5419: fnd_message.set_token('TABLE_NAME','BEN_PRTT_VSTG_F');

5415: fetch c284 into l_temp;
5416: if c284%found then
5417: close c284;
5418: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5419: fnd_message.set_token('TABLE_NAME','BEN_PRTT_VSTG_F');
5420: fnd_message.raise_error;
5421: end if;
5422: --
5423: close c284;

Line 6423: delete from BEN_PRTT_VSTG_F

6419:
6420: delete from BEN_PRTT_RT_VAL
6421: where business_group_id = p_bg_id;
6422:
6423: delete from BEN_PRTT_VSTG_F
6424: where business_group_id = p_bg_id;
6425:
6426: delete from BEN_ENRT_RT
6427: where business_group_id = p_bg_id;