APPS.BEN_ORG_DELETE dependencies on BEN_PRTN_ELIG_F

Line 614: is select 1 from BEN_PRTN_ELIG_F

610: is select 1 from BEN_POPL_YR_PERD
611: where business_group_id = p_bg_id;
612:
613: cursor c154(p_bg_id NUMBER)
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

Line 3461: -- Testing for values in BEN_PRTN_ELIG_F

3457: --
3458: close c153;
3459:
3460: --
3461: -- Testing for values in BEN_PRTN_ELIG_F
3462: --
3463: open c154(p_bg_id);
3464: --
3465: fetch c154 into l_temp;

Line 3469: fnd_message.set_token('TABLE_NAME','BEN_PRTN_ELIG_F');

3465: fetch c154 into l_temp;
3466: if c154%found then
3467: close c154;
3468: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3469: fnd_message.set_token('TABLE_NAME','BEN_PRTN_ELIG_F');
3470: fnd_message.raise_error;
3471: end if;
3472: --
3473: close c154;

Line 6033: delete from BEN_PRTN_ELIG_F

6029:
6030: delete from BEN_POPL_YR_PERD
6031: where business_group_id = p_bg_id;
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;