APPS.BEN_ORG_DELETE dependencies on BEN_PGM_F

Line 466: is select 1 from BEN_PGM_F

462: is select 1 from BEN_PTNL_LER_FOR_PER
463: where business_group_id = p_bg_id;
464:
465: cursor c116(p_bg_id NUMBER)
466: is select 1 from BEN_PGM_F
467: where business_group_id = p_bg_id;
468:
469: cursor c117(p_bg_id NUMBER)
470: is select 1 from BEN_ELIG_ENRLD_ANTHR_PGM_F

Line 2906: -- Testing for values in BEN_PGM_F

2902: --
2903: close c115;
2904:
2905: --
2906: -- Testing for values in BEN_PGM_F
2907: --
2908: open c116(p_bg_id);
2909: --
2910: fetch c116 into l_temp;

Line 2914: fnd_message.set_token('TABLE_NAME','BEN_PGM_F');

2910: fetch c116 into l_temp;
2911: if c116%found then
2912: close c116;
2913: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2914: fnd_message.set_token('TABLE_NAME','BEN_PGM_F');
2915: fnd_message.raise_error;
2916: end if;
2917: --
2918: close c116;

Line 5922: delete from BEN_PGM_F

5918:
5919: delete from BEN_PTNL_LER_FOR_PER
5920: where business_group_id = p_bg_id;
5921:
5922: delete from BEN_PGM_F
5923: where business_group_id = p_bg_id;
5924:
5925: delete from BEN_ELIG_ENRLD_ANTHR_PGM_F
5926: where business_group_id = p_bg_id;