APPS.BEN_ORG_DELETE dependencies on BEN_PLIP_F

Line 478: is select 1 from BEN_PLIP_F

474: is select 1 from BEN_ELIG_PRTT_ANTHR_PGM_F
475: where business_group_id = p_bg_id;
476:
477: cursor c119(p_bg_id NUMBER)
478: is select 1 from BEN_PLIP_F
479: where business_group_id = p_bg_id;
480:
481: cursor c120(p_bg_id NUMBER)
482: is select 1 from BEN_PL_F

Line 2951: -- Testing for values in BEN_PLIP_F

2947: --
2948: close c118;
2949:
2950: --
2951: -- Testing for values in BEN_PLIP_F
2952: --
2953: open c119(p_bg_id);
2954: --
2955: fetch c119 into l_temp;

Line 2959: fnd_message.set_token('TABLE_NAME','BEN_PLIP_F');

2955: fetch c119 into l_temp;
2956: if c119%found then
2957: close c119;
2958: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2959: fnd_message.set_token('TABLE_NAME','BEN_PLIP_F');
2960: fnd_message.raise_error;
2961: end if;
2962: --
2963: close c119;

Line 5931: delete from BEN_PLIP_F

5927:
5928: delete from BEN_ELIG_PRTT_ANTHR_PGM_F
5929: where business_group_id = p_bg_id;
5930:
5931: delete from BEN_PLIP_F
5932: where business_group_id = p_bg_id;
5933:
5934: delete from BEN_PL_F
5935: where business_group_id = p_bg_id;