APPS.HR_DELETE dependencies on FND_LOOKUP_TYPES

Line 1980: from fnd_lookup_types

1976: WHERE business_group_id = c_business_group_id;
1977: --
1978: cursor deltype (p_sec_grp in number) is
1979: select lookup_type
1980: from fnd_lookup_types
1981: where security_group_id = p_sec_grp;
1982: --
1983: begin
1984: hr_utility.set_location('Entering: '||l_proc, 10);

Line 2045: DELETE FROM fnd_lookup_types_tl

2041: DELETE FROM fnd_lookup_values
2042: WHERE security_group_id = l_security_group_id
2043: AND lookup_type = typrec.lookup_type;
2044: --
2045: DELETE FROM fnd_lookup_types_tl
2046: WHERE security_group_id = l_security_group_id
2047: AND lookup_type = typrec.lookup_type;
2048: --
2049: DELETE FROM fnd_lookup_types

Line 2049: DELETE FROM fnd_lookup_types

2045: DELETE FROM fnd_lookup_types_tl
2046: WHERE security_group_id = l_security_group_id
2047: AND lookup_type = typrec.lookup_type;
2048: --
2049: DELETE FROM fnd_lookup_types
2050: WHERE security_group_id = l_security_group_id
2051: AND lookup_type = typrec.lookup_type;
2052: --
2053: end loop;