APPS.BEN_ORG_DELETE dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 794: is select 1 from BEN_PIL_ELCTBL_CHC_POPL

790: is select 1 from BEN_LER_CHG_PL_NIP_ENRT_F
791: where business_group_id = p_bg_id;
792:
793: cursor c199(p_bg_id NUMBER)
794: is select 1 from BEN_PIL_ELCTBL_CHC_POPL
795: where business_group_id = p_bg_id;
796:
797: cursor c200(p_bg_id NUMBER)
798: is select 1 from BEN_AGE_RT_F

Line 4136: -- Testing for values in BEN_PIL_ELCTBL_CHC_POPL

4132: --
4133: close c198;
4134:
4135: --
4136: -- Testing for values in BEN_PIL_ELCTBL_CHC_POPL
4137: --
4138: open c199(p_bg_id);
4139: --
4140: fetch c199 into l_temp;

Line 4144: fnd_message.set_token('TABLE_NAME','BEN_PIL_ELCTBL_CHC_POPL');

4140: fetch c199 into l_temp;
4141: if c199%found then
4142: close c199;
4143: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4144: fnd_message.set_token('TABLE_NAME','BEN_PIL_ELCTBL_CHC_POPL');
4145: fnd_message.raise_error;
4146: end if;
4147: --
4148: close c199;

Line 6168: delete from BEN_PIL_ELCTBL_CHC_POPL

6164:
6165: delete from BEN_LER_CHG_PL_NIP_ENRT_F
6166: where business_group_id = p_bg_id;
6167:
6168: delete from BEN_PIL_ELCTBL_CHC_POPL
6169: where business_group_id = p_bg_id;
6170:
6171: delete from BEN_AGE_RT_F
6172: where business_group_id = p_bg_id;