APPS.BEN_ORG_DELETE dependencies on BEN_EXT_CRIT_TYP

Line 214: is select 1 from BEN_EXT_CRIT_TYP

210: is select 1 from BEN_ELIG_WK_LOC_PRTE_F
211: where business_group_id = p_bg_id;
212:
213: cursor c53(p_bg_id NUMBER)
214: is select 1 from BEN_EXT_CRIT_TYP
215: where business_group_id = p_bg_id;
216:
217: cursor c54(p_bg_id NUMBER)
218: is select 1 from BEN_EXT_DFN

Line 1961: -- Testing for values in BEN_EXT_CRIT_TYP

1957: --
1958: close c52;
1959:
1960: --
1961: -- Testing for values in BEN_EXT_CRIT_TYP
1962: --
1963: open c53(p_bg_id);
1964: --
1965: fetch c53 into l_temp;

Line 1969: fnd_message.set_token('TABLE_NAME','BEN_EXT_CRIT_TYP');

1965: fetch c53 into l_temp;
1966: if c53%found then
1967: close c53;
1968: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1969: fnd_message.set_token('TABLE_NAME','BEN_EXT_CRIT_TYP');
1970: fnd_message.raise_error;
1971: end if;
1972: --
1973: close c53;

Line 5733: delete from BEN_EXT_CRIT_TYP

5729:
5730: delete from BEN_ELIG_WK_LOC_PRTE_F
5731: where business_group_id = p_bg_id;
5732:
5733: delete from BEN_EXT_CRIT_TYP
5734: where business_group_id = p_bg_id;
5735:
5736: delete from BEN_EXT_DFN
5737: where business_group_id = p_bg_id;