APPS.HR_DM_DELETE dependencies on FND_LOOKUP_VALUES

Line 154: FROM FND_LOOKUP_VALUES

150: WHERE security_group_id = l_security_group_id;
151:
152: CURSOR csr_lu_code IS
153: SELECT DISTINCT lookup_code
154: FROM FND_LOOKUP_VALUES
155: WHERE security_group_id = l_security_group_id
156: AND lookup_type = l_lookup_type
157: AND view_application_id = l_view_application_id;
158:

Line 210: fnd_lookup_values_pkg.delete_row(

206: FETCH csr_lu_code INTO l_lookup_code;
207: EXIT WHEN csr_lu_code%NOTFOUND;
208:
209: -- call API to delete lookup code / value
210: fnd_lookup_values_pkg.delete_row(
211: X_LOOKUP_TYPE => l_lookup_type,
212: X_SECURITY_GROUP_ID => l_security_group_id,
213: X_VIEW_APPLICATION_ID => l_view_application_id,
214: X_LOOKUP_CODE => l_lookup_code);