APPS.BEN_ORG_DELETE dependencies on BEN_VALD_RLSHP_FOR_REIMB_F

Line 618: is select 1 from BEN_VALD_RLSHP_FOR_REIMB_F

614: is select 1 from BEN_PRTN_ELIG_F
615: where business_group_id = p_bg_id;
616:
617: cursor c155(p_bg_id NUMBER)
618: is select 1 from BEN_VALD_RLSHP_FOR_REIMB_F
619: where business_group_id = p_bg_id;
620:
621: cursor c156(p_bg_id NUMBER)
622: is select 1 from BEN_VRBL_RT_PRFL_F

Line 3476: -- Testing for values in BEN_VALD_RLSHP_FOR_REIMB_F

3472: --
3473: close c154;
3474:
3475: --
3476: -- Testing for values in BEN_VALD_RLSHP_FOR_REIMB_F
3477: --
3478: open c155(p_bg_id);
3479: --
3480: fetch c155 into l_temp;

Line 3484: fnd_message.set_token('TABLE_NAME','BEN_VALD_RLSHP_FOR_REIMB_F');

3480: fetch c155 into l_temp;
3481: if c155%found then
3482: close c155;
3483: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3484: fnd_message.set_token('TABLE_NAME','BEN_VALD_RLSHP_FOR_REIMB_F');
3485: fnd_message.raise_error;
3486: end if;
3487: --
3488: close c155;

Line 6036: delete from BEN_VALD_RLSHP_FOR_REIMB_F

6032:
6033: delete from BEN_PRTN_ELIG_F
6034: where business_group_id = p_bg_id;
6035:
6036: delete from BEN_VALD_RLSHP_FOR_REIMB_F
6037: where business_group_id = p_bg_id;
6038:
6039: delete from BEN_VRBL_RT_PRFL_F
6040: where business_group_id = p_bg_id;