APPS.BEN_ORG_DELETE dependencies on BEN_OIPLIP_F

Line 506: is select 1 from BEN_OIPLIP_F

502: is select 1 from BEN_ENRT_ENRLD_ANTHR_PL_F
503: where business_group_id = p_bg_id;
504:
505: cursor c127(p_bg_id NUMBER)
506: is select 1 from BEN_OIPLIP_F
507: where business_group_id = p_bg_id;
508:
509: cursor c128(p_bg_id NUMBER)
510: is select 1 from BEN_OIPL_F

Line 3056: -- Testing for values in BEN_OIPLIP_F

3052: --
3053: close c126;
3054:
3055: --
3056: -- Testing for values in BEN_OIPLIP_F
3057: --
3058: open c127(p_bg_id);
3059: --
3060: fetch c127 into l_temp;

Line 3064: fnd_message.set_token('TABLE_NAME','BEN_OIPLIP_F');

3060: fetch c127 into l_temp;
3061: if c127%found then
3062: close c127;
3063: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3064: fnd_message.set_token('TABLE_NAME','BEN_OIPLIP_F');
3065: fnd_message.raise_error;
3066: end if;
3067: --
3068: close c127;

Line 5952: delete from BEN_OIPLIP_F

5948:
5949: delete from BEN_ENRT_ENRLD_ANTHR_PL_F
5950: where business_group_id = p_bg_id;
5951:
5952: delete from BEN_OIPLIP_F
5953: where business_group_id = p_bg_id;
5954:
5955: delete from BEN_OIPL_F
5956: where business_group_id = p_bg_id;