APPS.BEN_ORG_DELETE dependencies on BEN_PCT_FL_TM_RT_F

Line 662: is select 1 from BEN_PCT_FL_TM_RT_F

658: is select 1 from BEN_ORG_UNIT_RT_F
659: where business_group_id = p_bg_id;
660:
661: cursor c166(p_bg_id NUMBER)
662: is select 1 from BEN_PCT_FL_TM_RT_F
663: where business_group_id = p_bg_id;
664:
665: cursor c167(p_bg_id NUMBER)
666: is select 1 from BEN_PER_TYP_RT_F

Line 3641: -- Testing for values in BEN_PCT_FL_TM_RT_F

3637: --
3638: close c165;
3639:
3640: --
3641: -- Testing for values in BEN_PCT_FL_TM_RT_F
3642: --
3643: open c166(p_bg_id);
3644: --
3645: fetch c166 into l_temp;

Line 3649: fnd_message.set_token('TABLE_NAME','BEN_PCT_FL_TM_RT_F');

3645: fetch c166 into l_temp;
3646: if c166%found then
3647: close c166;
3648: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3649: fnd_message.set_token('TABLE_NAME','BEN_PCT_FL_TM_RT_F');
3650: fnd_message.raise_error;
3651: end if;
3652: --
3653: close c166;

Line 6069: delete from BEN_PCT_FL_TM_RT_F

6065:
6066: delete from BEN_ORG_UNIT_RT_F
6067: where business_group_id = p_bg_id;
6068:
6069: delete from BEN_PCT_FL_TM_RT_F
6070: where business_group_id = p_bg_id;
6071:
6072: delete from BEN_PER_TYP_RT_F
6073: where business_group_id = p_bg_id;