617: from per_appraisals apr
618: where apr.appraisal_template_id
619: = p_appraisal_template_id);
620: -- Cursor to check if questionnaire template can be updated,
621: -- according to per_participants.
622: cursor csr_question_update2 is
623: select 'Y'
624: from per_participants par
625: where par.participation_in_table = 'PER_APPRAISALS'
620: -- Cursor to check if questionnaire template can be updated,
621: -- according to per_participants.
622: cursor csr_question_update2 is
623: select 'Y'
624: from per_participants par
625: where par.participation_in_table = 'PER_APPRAISALS'
626: and par.participation_in_id in (select appraisal_id
627: from per_appraisals apr
628: where apr.appraisal_template_id
806: from per_appraisals apr
807: where apr.appraisal_template_id
808: = p_appraisal_template_id);
809: -- Cursor to check if questionnaire template can be updated,
810: -- according to per_participants.
811: cursor csr_question_update2 is
812: select 'Y'
813: from per_participants par
814: where par.participation_in_table = 'PER_APPRAISALS'
809: -- Cursor to check if questionnaire template can be updated,
810: -- according to per_participants.
811: cursor csr_question_update2 is
812: select 'Y'
813: from per_participants par
814: where par.participation_in_table = 'PER_APPRAISALS'
815: and par.participation_in_id in (select appraisal_id
816: from per_appraisals apr
817: where apr.appraisal_template_id