APPS.HR_PARTICIPANTS_API dependencies on HR_QUEST_ANSWERS

Line 523: from hr_quest_answers

519:
520: cursor c_quest_ans_id
521: is
522: select questionnaire_answer_id
523: from hr_quest_answers
524: where hr_quest_answers.type = 'PARTICIPANT' and
525: hr_quest_answers.type_object_id = p_participant_id;
526: -- Update in lines of Bug No.1386826 . Now from Appraisals V5, participant can have a Qnr.
527: l_quest_ans_id hr_quest_answers.questionnaire_answer_id%type;

Line 524: where hr_quest_answers.type = 'PARTICIPANT' and

520: cursor c_quest_ans_id
521: is
522: select questionnaire_answer_id
523: from hr_quest_answers
524: where hr_quest_answers.type = 'PARTICIPANT' and
525: hr_quest_answers.type_object_id = p_participant_id;
526: -- Update in lines of Bug No.1386826 . Now from Appraisals V5, participant can have a Qnr.
527: l_quest_ans_id hr_quest_answers.questionnaire_answer_id%type;
528:

Line 525: hr_quest_answers.type_object_id = p_participant_id;

521: is
522: select questionnaire_answer_id
523: from hr_quest_answers
524: where hr_quest_answers.type = 'PARTICIPANT' and
525: hr_quest_answers.type_object_id = p_participant_id;
526: -- Update in lines of Bug No.1386826 . Now from Appraisals V5, participant can have a Qnr.
527: l_quest_ans_id hr_quest_answers.questionnaire_answer_id%type;
528:
529: --

Line 527: l_quest_ans_id hr_quest_answers.questionnaire_answer_id%type;

523: from hr_quest_answers
524: where hr_quest_answers.type = 'PARTICIPANT' and
525: hr_quest_answers.type_object_id = p_participant_id;
526: -- Update in lines of Bug No.1386826 . Now from Appraisals V5, participant can have a Qnr.
527: l_quest_ans_id hr_quest_answers.questionnaire_answer_id%type;
528:
529: --
530: begin
531: hr_utility.set_location('Entering:'|| l_proc, 5);