APPS.HR_QSV_BUS dependencies on HR_QUEST_ANSWERS

Line 89: from hr_quest_answers qsa

85: -- Cursor to check if questionnaire_answer_id exists
86: --
87: cursor csr_id_exists is
88: select qsa.questionnaire_template_id
89: from hr_quest_answers qsa
90: where qsa.questionnaire_answer_id = p_questionnaire_answer_id;
91: --
92: begin
93: --

Line 101: -- Check that id exists in HR_QUEST_ANSWERS table

97: -- error, as this cannot be null
98: fnd_message.set_name('PER','PER_52446_QSV_MAND_ANS_ID');
99: fnd_message.raise_error;
100: else
101: -- Check that id exists in HR_QUEST_ANSWERS table
102: open csr_id_exists;
103: -- Fetch questionnaire_template_id for later use.
104: fetch csr_id_exists into g_questionnaire_template_id;
105: if csr_id_exists%NOTFOUND then

Line 130: l_qsa_qu_temp_id hr_quest_answers.questionnaire_template_id%TYPE;

126: is
127: --
128: l_proc varchar2(72) := g_package || 'chk_field_id';
129: l_exists varchar2(1);
130: l_qsa_qu_temp_id hr_quest_answers.questionnaire_template_id%TYPE;
131: l_questionnaire_template_id hr_quest_fields.questionnaire_template_id%TYPE;
132: --
133: -- Cursor to check that field_id exists in HR_QUEST_FIELDS
134: --

Line 316: , hr_quest_answers qsa

312: --
313: cursor csr_leg_code is
314: select pbg.legislation_code
315: from per_business_groups pbg
316: , hr_quest_answers qsa
317: , hr_quest_answer_values qsv
318: where p_quest_answer_val_id = qsv.quest_answer_val_id
319: and qsv.questionnaire_answer_id = qsa.questionnaire_answer_id
320: and qsa.business_group_id = pbg.business_group_id;