APPS.HR_APPRAISALS_API dependencies on HR_QUEST_ANSWERS

Line 1113: from hr_quest_answers

1109: --
1110: cursor c_quest_ans_id
1111: is
1112: select questionnaire_answer_id
1113: from hr_quest_answers
1114: where hr_quest_answers.type = 'APPRAISAL' and
1115: hr_quest_answers.type_object_id = p_appraisal_id; -- Fix for Bug No.1386826
1116:
1117: --

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

1110: cursor c_quest_ans_id
1111: is
1112: select questionnaire_answer_id
1113: from hr_quest_answers
1114: where hr_quest_answers.type = 'APPRAISAL' and
1115: hr_quest_answers.type_object_id = p_appraisal_id; -- Fix for Bug No.1386826
1116:
1117: --
1118: --

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

1111: is
1112: select questionnaire_answer_id
1113: from hr_quest_answers
1114: where hr_quest_answers.type = 'APPRAISAL' and
1115: hr_quest_answers.type_object_id = p_appraisal_id; -- Fix for Bug No.1386826
1116:
1117: --
1118: --
1119: cursor cs_get_participants is

Line 1162: (select questionnaire_answer_id from hr_quest_answers

1158: --
1159: cursor cs_get_apr_quest_answers_rec is
1160: select quest_answer_val_id from
1161: hr_quest_answer_values where questionnaire_answer_id in
1162: (select questionnaire_answer_id from hr_quest_answers
1163: where type = 'APPRAISAL' and type_object_id=p_appraisal_id );
1164: --
1165: cursor cs_get_part_quest_answers_rec is
1166: select quest_answer_val_id from

Line 1168: (select questionnaire_answer_id from hr_quest_answers

1164: --
1165: cursor cs_get_part_quest_answers_rec is
1166: select quest_answer_val_id from
1167: hr_quest_answer_values where questionnaire_answer_id in
1168: (select questionnaire_answer_id from hr_quest_answers
1169: where type = 'PARTICIPANT' and type_object_id in
1170: (select participant_id from per_participants where
1171: participation_in_table='PER_APPRAISALS' and participation_in_column='APPRAISAL_ID' and
1172: participation_in_id=p_appraisal_id

Line 1180: l_quest_ans_id hr_quest_answers.questionnaire_answer_id%type;

1176: */
1177:
1178: --
1179:
1180: l_quest_ans_id hr_quest_answers.questionnaire_answer_id%type;
1181: --
1182: l_proc varchar2(72) := g_package||'delete_appraisal';
1183: l_person_id NUMBER(9,0);
1184: l_training_plan_member_id NUMBER(9,0);

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

1222: -- To delete Appraisal , Participants, Assessments, Comp Elements, Objectives, Perf Ratings
1223:
1224: -- Fix for bug no. 1386826 begins.
1225: --
1226: -- Deleting the related child records in hr_quest_answers and hr_quest_answer_values
1227: -- tables if the entry in "VALUE" column of hr_quest_answer_values has null entry.
1228: --
1229: open c_quest_ans_id;
1230: fetch c_quest_ans_id into l_quest_ans_id;