APPS.PER_APT_BUS dependencies on PER_PARTICIPANTS

Line 621: -- according to per_participants.

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'

Line 624: from per_participants par

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

Line 810: -- according to per_participants.

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'

Line 813: from per_participants par

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