APPS.PER_AST_DEL dependencies on PER_ASSESSMENT_TYPES

Line 79: -- Delete the per_assessment_types row.

75: WHERE
76: parent_competence_element_id IN (SELECT competence_element_id
77: FROM per_competence_elements cel2
78: WHERE cel2.assessment_type_id = p_rec.assessment_type_id );
79: -- Delete the per_assessment_types row.
80: --
81: delete from per_assessment_types
82: where assessment_type_id = p_rec.assessment_type_id;
83: --

Line 81: delete from per_assessment_types

77: FROM per_competence_elements cel2
78: WHERE cel2.assessment_type_id = p_rec.assessment_type_id );
79: -- Delete the per_assessment_types row.
80: --
81: delete from per_assessment_types
82: where assessment_type_id = p_rec.assessment_type_id;
83: --
84: hr_utility.set_location(' Leaving:'||l_proc, 10);
85: --

Line 230: ( p_module_name => 'PER_ASSESSMENT_TYPES'

226: p_available_flag_o => per_ast_shd.g_old_rec.available_flag);
227: exception
228: when hr_api.cannot_find_prog_unit then
229: hr_api.cannot_find_prog_unit_error
230: ( p_module_name => 'PER_ASSESSMENT_TYPES'
231: ,p_hook_type => 'AD'
232: );
233: end;
234: -- End of API User Hook for post_delete.