APPS.HR_QSA_BUS dependencies on PER_APPRAISALS

Line 76: -- the PER_APPRAISALS table when type = 'PARTICIPANT'.

72: -- Description:
73: -- Validates that the questionnaire_template_id exists in HR_QUESTIONNAIRES.
74: -- Also, validates that the questionnaire_template_id is valid against the
75: -- PER_APPRAISAL_TEMPLATES table, when type = 'APPRAISAL', or valid against
76: -- the PER_APPRAISALS table when type = 'PARTICIPANT'.
77: --
78: -- Pre-requisites:
79: -- p_type, p_type_object_id and p_business_group_id are all valid.
80: --

Line 130: per_appraisals pa

126: --
127: cursor csr_appraisal_valid is
128: select null
129: from per_appraisal_templates pat,
130: per_appraisals pa
131: where p_questionnaire_template_id = pat.questionnaire_template_id
132: and p_type_object_id = pa.appraisal_id
133: and pa.appraisal_template_id = pat.appraisal_template_id;
134: --

Line 168: -- per_appraisal_templates and per_appraisals.

164: open csr_appraisal_valid;
165: fetch csr_appraisal_valid into l_exists;
166: if csr_appraisal_valid%NOTFOUND then
167: -- Invalid questionnaire_template_id, according to
168: -- per_appraisal_templates and per_appraisals.
169: close csr_appraisal_valid;
170: fnd_message.set_name('PER','PER_52431_QSA_INVAL_TEMP_ID');
171: fnd_message.raise_error;
172: end if;

Line 268: from per_appraisals pa

264: -- type = 'APPRAISAL'
265: --
266: cursor csr_type_appraisal is
267: select business_group_id
268: from per_appraisals pa
269: where p_type_object_id = pa.appraisal_id;
270: --
271: -- Cursor to determine if type_object_id is valid when
272: -- type = 'PARTICIPANT'

Line 360: if (l_part_in_tab <> 'PER_APPRAISALS') and

356: -- bug 1980440 fix ends
357: --
358: hr_utility.set_location(l_proc,70);
359: --
360: if (l_part_in_tab <> 'PER_APPRAISALS') and
361: (l_part_in_col <> 'APPRAISAL_ID') then
362: -- Invalid combination, raise error.
363: fnd_message.set_name('PER','PER_52438_QSA_OBJ_NOT_IN_APR');
364: fnd_message.raise_error;