APPS.PER_AST_DEL dependencies on PER_COMPETENCE_ELEMENTS

Line 52: -- Delete the rows in per_competence_elements

48: --
49: Begin
50: hr_utility.set_location('Entering:'||l_proc, 5);
51: --
52: -- Delete the rows in per_competence_elements
53: -- which relate to this assesment_type.
54: -- This will allow a cascade delete from the api
55: -- There is a pigs ear relationship so this will find all the necessary rows
56: /*

Line 58: delete from per_competence_elements

54: -- This will allow a cascade delete from the api
55: -- There is a pigs ear relationship so this will find all the necessary rows
56: /*
57: Changes for Bug#6522890. Broken this into 2 sql's for improving performance.
58: delete from per_competence_elements
59: where competence_element_id in
60: (select competence_element_id from per_competence_elements cel1
61: where cel1.assessment_type_id = p_rec.assessment_type_id
62: Or parent_competence_element_id in

Line 60: (select competence_element_id from per_competence_elements cel1

56: /*
57: Changes for Bug#6522890. Broken this into 2 sql's for improving performance.
58: delete from per_competence_elements
59: where competence_element_id in
60: (select competence_element_id from per_competence_elements cel1
61: where cel1.assessment_type_id = p_rec.assessment_type_id
62: Or parent_competence_element_id in
63: (select competence_element_id
64: from per_competence_elements cel2

Line 64: from per_competence_elements cel2

60: (select competence_element_id from per_competence_elements cel1
61: where cel1.assessment_type_id = p_rec.assessment_type_id
62: Or parent_competence_element_id in
63: (select competence_element_id
64: from per_competence_elements cel2
65: where cel2.assessment_type_id = p_rec.assessment_type_id)
66: );
67: */
68: DELETE FROM per_competence_elements

Line 68: DELETE FROM per_competence_elements

64: from per_competence_elements cel2
65: where cel2.assessment_type_id = p_rec.assessment_type_id)
66: );
67: */
68: DELETE FROM per_competence_elements
69: WHERE
70: competence_element_id IN (SELECT competence_element_id
71: FROM per_competence_elements cel1
72: WHERE cel1.assessment_type_id = p_rec.assessment_type_id);

Line 71: FROM per_competence_elements cel1

67: */
68: DELETE FROM per_competence_elements
69: WHERE
70: competence_element_id IN (SELECT competence_element_id
71: FROM per_competence_elements cel1
72: WHERE cel1.assessment_type_id = p_rec.assessment_type_id);
73:
74: DELETE FROM per_competence_elements
75: WHERE

Line 74: DELETE FROM per_competence_elements

70: competence_element_id IN (SELECT competence_element_id
71: FROM per_competence_elements cel1
72: WHERE cel1.assessment_type_id = p_rec.assessment_type_id);
73:
74: DELETE FROM per_competence_elements
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 );

Line 77: FROM per_competence_elements cel2

73:
74: DELETE FROM per_competence_elements
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