APPS.PER_ZA_EQT_UPD dependencies on PER_ZA_QUALIFICATION_TYPES

Line 103: from per_za_qualification_types

99:
100: begin
101: select 1
102: into l_dummy
103: from per_za_qualification_types
104: where qualification_type_id = p_rec.qualification_type_id;
105:
106: -- Record exists, can update.
107: update per_za_qualification_types

Line 107: update per_za_qualification_types

103: from per_za_qualification_types
104: where qualification_type_id = p_rec.qualification_type_id;
105:
106: -- Record exists, can update.
107: update per_za_qualification_types
108: set nqf_qualification_type = p_rec.nqf_qualification_type
109: where qualification_type_id = p_rec.qualification_type_id;
110:
111: exception

Line 114: insert into per_za_qualification_types(qualification_type_id,

110:
111: exception
112: -- Record does not exists, must insert.
113: when no_data_found then
114: insert into per_za_qualification_types(qualification_type_id,
115: nqf_qualification_type)
116: values(p_rec.qualification_type_id,
117: p_rec.nqf_qualification_type);
118: end;