APPS.HR_APPRAISALS_API dependencies on PER_PARTICIPANTS

Line 596: l_participant_id_1 per_participants.participant_id%TYPE;

592: l_object_version_number per_appraisals.object_version_number%TYPE;
593: l_asn_object_version_number per_assessments.object_version_number%TYPE;
594: l_assessment_id per_assessments.assessment_id%TYPE;
595: l_old_mainap_id per_appraisals.main_appraiser_id%TYPE;
596: l_participant_id_1 per_participants.participant_id%TYPE;
597: l_participant_id_2 per_participants.participant_id%TYPE;
598: l_part_object_version_number_1 per_participants.object_version_number%TYPE;
599: l_part_object_version_number_2 per_participants.object_version_number%TYPE;
600: l_appraisee_person_id per_appraisals.appraisee_person_id%TYPE;

Line 597: l_participant_id_2 per_participants.participant_id%TYPE;

593: l_asn_object_version_number per_assessments.object_version_number%TYPE;
594: l_assessment_id per_assessments.assessment_id%TYPE;
595: l_old_mainap_id per_appraisals.main_appraiser_id%TYPE;
596: l_participant_id_1 per_participants.participant_id%TYPE;
597: l_participant_id_2 per_participants.participant_id%TYPE;
598: l_part_object_version_number_1 per_participants.object_version_number%TYPE;
599: l_part_object_version_number_2 per_participants.object_version_number%TYPE;
600: l_appraisee_person_id per_appraisals.appraisee_person_id%TYPE;
601: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;

Line 598: l_part_object_version_number_1 per_participants.object_version_number%TYPE;

594: l_assessment_id per_assessments.assessment_id%TYPE;
595: l_old_mainap_id per_appraisals.main_appraiser_id%TYPE;
596: l_participant_id_1 per_participants.participant_id%TYPE;
597: l_participant_id_2 per_participants.participant_id%TYPE;
598: l_part_object_version_number_1 per_participants.object_version_number%TYPE;
599: l_part_object_version_number_2 per_participants.object_version_number%TYPE;
600: l_appraisee_person_id per_appraisals.appraisee_person_id%TYPE;
601: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
602: l_appraisal_sys_status per_appraisals.appraisal_system_status%TYPE;

Line 599: l_part_object_version_number_2 per_participants.object_version_number%TYPE;

595: l_old_mainap_id per_appraisals.main_appraiser_id%TYPE;
596: l_participant_id_1 per_participants.participant_id%TYPE;
597: l_participant_id_2 per_participants.participant_id%TYPE;
598: l_part_object_version_number_1 per_participants.object_version_number%TYPE;
599: l_part_object_version_number_2 per_participants.object_version_number%TYPE;
600: l_appraisee_person_id per_appraisals.appraisee_person_id%TYPE;
601: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
602: l_appraisal_sys_status per_appraisals.appraisal_system_status%TYPE;
603: --

Line 707: FROM per_participants par

703: -- check if Participant exists for the Appraisal and the PersonId
704: --
705: CURSOR csr_get_participant IS
706: SELECT par.participant_id, par.object_version_number
707: FROM per_participants par
708: WHERE par.participation_in_id = p_appraisal_id
709: and par.participation_in_table = 'PER_APPRAISALS'
710: and par.participation_in_column = 'APPRAISAL_ID'
711: and par.person_id = p_person_id;

Line 1168: select participant_id,object_version_number from per_participants

1164:
1165: --
1166: --
1167: cursor cs_get_participants is
1168: select participant_id,object_version_number from per_participants
1169: where participation_in_id = p_appraisal_id
1170: and participation_in_table = 'PER_APPRAISALS'
1171: and participation_in_column = 'APPRAISAL_ID';
1172: --

Line 1218: (select participant_id from per_participants where

1214: select quest_answer_val_id from
1215: hr_quest_answer_values where questionnaire_answer_id in
1216: (select questionnaire_answer_id from hr_quest_answers
1217: where type = 'PARTICIPANT' and type_object_id in
1218: (select participant_id from per_participants where
1219: participation_in_table='PER_APPRAISALS' and participation_in_column='APPRAISAL_ID' and
1220: participation_in_id=p_appraisal_id
1221: )
1222: );