APPS.HR_APPRAISALS_API dependencies on HR_QUEST_ANSWERS

Line 1161: from hr_quest_answers

1157: --
1158: cursor c_quest_ans_id
1159: is
1160: select questionnaire_answer_id
1161: from hr_quest_answers
1162: where hr_quest_answers.type = 'APPRAISAL' and
1163: hr_quest_answers.type_object_id = p_appraisal_id; -- Fix for Bug No.1386826
1164:
1165: --

Line 1162: where hr_quest_answers.type = 'APPRAISAL' and

1158: cursor c_quest_ans_id
1159: is
1160: select questionnaire_answer_id
1161: from hr_quest_answers
1162: where hr_quest_answers.type = 'APPRAISAL' and
1163: hr_quest_answers.type_object_id = p_appraisal_id; -- Fix for Bug No.1386826
1164:
1165: --
1166: --

Line 1163: hr_quest_answers.type_object_id = p_appraisal_id; -- Fix for Bug No.1386826

1159: is
1160: select questionnaire_answer_id
1161: from hr_quest_answers
1162: where hr_quest_answers.type = 'APPRAISAL' and
1163: hr_quest_answers.type_object_id = p_appraisal_id; -- Fix for Bug No.1386826
1164:
1165: --
1166: --
1167: cursor cs_get_participants is

Line 1210: (select questionnaire_answer_id from hr_quest_answers

1206: --
1207: cursor cs_get_apr_quest_answers_rec is
1208: select quest_answer_val_id from
1209: hr_quest_answer_values where questionnaire_answer_id in
1210: (select questionnaire_answer_id from hr_quest_answers
1211: where type = 'APPRAISAL' and type_object_id=p_appraisal_id );
1212: --
1213: cursor cs_get_part_quest_answers_rec is
1214: select quest_answer_val_id from

Line 1216: (select questionnaire_answer_id from hr_quest_answers

1212: --
1213: cursor cs_get_part_quest_answers_rec is
1214: select quest_answer_val_id from
1215: hr_quest_answer_values where questionnaire_answer_id in
1216: (select questionnaire_answer_id from hr_quest_answers
1217: where type = 'PARTICIPANT' and type_object_id in
1218: (select participant_id from per_participants where
1219: participation_in_table='PER_APPRAISALS' and participation_in_column='APPRAISAL_ID' and
1220: participation_in_id=p_appraisal_id

Line 1228: l_quest_ans_id hr_quest_answers.questionnaire_answer_id%type;

1224: */
1225:
1226: --
1227:
1228: l_quest_ans_id hr_quest_answers.questionnaire_answer_id%type;
1229: --
1230: l_proc varchar2(72) := g_package||'delete_appraisal';
1231: l_person_id NUMBER(9,0);
1232: l_training_plan_member_id NUMBER(9,0);

Line 1274: -- Deleting the related child records in hr_quest_answers and hr_quest_answer_values

1270: -- To delete Appraisal , Participants, Assessments, Comp Elements, Objectives, Perf Ratings
1271:
1272: -- Fix for bug no. 1386826 begins.
1273: --
1274: -- Deleting the related child records in hr_quest_answers and hr_quest_answer_values
1275: -- tables if the entry in "VALUE" column of hr_quest_answer_values has null entry.
1276: --
1277: open c_quest_ans_id;
1278: fetch c_quest_ans_id into l_quest_ans_id;