APPS.BEN_ORG_DELETE dependencies on BEN_LEE_RSN_F

Line 598: is select 1 from BEN_LEE_RSN_F

594: is select 1 from BEN_ENRT_CTFN_F
595: where business_group_id = p_bg_id;
596:
597: cursor c150(p_bg_id NUMBER)
598: is select 1 from BEN_LEE_RSN_F
599: where business_group_id = p_bg_id;
600:
601: cursor c151(p_bg_id NUMBER)
602: is select 1 from BEN_PL_R_OIPL_ASSET_F

Line 3401: -- Testing for values in BEN_LEE_RSN_F

3397: --
3398: close c149;
3399:
3400: --
3401: -- Testing for values in BEN_LEE_RSN_F
3402: --
3403: open c150(p_bg_id);
3404: --
3405: fetch c150 into l_temp;

Line 3409: fnd_message.set_token('TABLE_NAME','BEN_LEE_RSN_F');

3405: fetch c150 into l_temp;
3406: if c150%found then
3407: close c150;
3408: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3409: fnd_message.set_token('TABLE_NAME','BEN_LEE_RSN_F');
3410: fnd_message.raise_error;
3411: end if;
3412: --
3413: close c150;

Line 6021: delete from BEN_LEE_RSN_F

6017:
6018: delete from BEN_ENRT_CTFN_F
6019: where business_group_id = p_bg_id;
6020:
6021: delete from BEN_LEE_RSN_F
6022: where business_group_id = p_bg_id;
6023:
6024: delete from BEN_PL_R_OIPL_ASSET_F
6025: where business_group_id = p_bg_id;