145:
146: CURSOR csr_lu_type IS
147: SELECT lookup_type,
148: view_application_id
149: FROM fnd_lookup_types
150: WHERE security_group_id = l_security_group_id;
151:
152: CURSOR csr_lu_code IS
153: SELECT DISTINCT lookup_code
216: END LOOP;
217: CLOSE csr_lu_code;
218:
219: -- now delete the lookup type
220: fnd_lookup_types_pkg.delete_row(
221: X_LOOKUP_TYPE => l_lookup_type,
222: X_SECURITY_GROUP_ID => l_security_group_id,
223: X_VIEW_APPLICATION_ID => l_view_application_id);
224: