APPS.HR_APPRAISALS_API dependencies on PER_PARTICIPANTS

Line 586: l_participant_id_1 per_participants.participant_id%TYPE;

582: l_object_version_number per_appraisals.object_version_number%TYPE;
583: l_asn_object_version_number per_assessments.object_version_number%TYPE;
584: l_assessment_id per_assessments.assessment_id%TYPE;
585: l_old_mainap_id per_appraisals.main_appraiser_id%TYPE;
586: l_participant_id_1 per_participants.participant_id%TYPE;
587: l_participant_id_2 per_participants.participant_id%TYPE;
588: l_part_object_version_number_1 per_participants.object_version_number%TYPE;
589: l_part_object_version_number_2 per_participants.object_version_number%TYPE;
590: --

Line 587: l_participant_id_2 per_participants.participant_id%TYPE;

583: l_asn_object_version_number per_assessments.object_version_number%TYPE;
584: l_assessment_id per_assessments.assessment_id%TYPE;
585: l_old_mainap_id per_appraisals.main_appraiser_id%TYPE;
586: l_participant_id_1 per_participants.participant_id%TYPE;
587: l_participant_id_2 per_participants.participant_id%TYPE;
588: l_part_object_version_number_1 per_participants.object_version_number%TYPE;
589: l_part_object_version_number_2 per_participants.object_version_number%TYPE;
590: --
591: lv_object_version_number number := p_object_version_number ;

Line 588: l_part_object_version_number_1 per_participants.object_version_number%TYPE;

584: l_assessment_id per_assessments.assessment_id%TYPE;
585: l_old_mainap_id per_appraisals.main_appraiser_id%TYPE;
586: l_participant_id_1 per_participants.participant_id%TYPE;
587: l_participant_id_2 per_participants.participant_id%TYPE;
588: l_part_object_version_number_1 per_participants.object_version_number%TYPE;
589: l_part_object_version_number_2 per_participants.object_version_number%TYPE;
590: --
591: lv_object_version_number number := p_object_version_number ;
592: --

Line 589: l_part_object_version_number_2 per_participants.object_version_number%TYPE;

585: l_old_mainap_id per_appraisals.main_appraiser_id%TYPE;
586: l_participant_id_1 per_participants.participant_id%TYPE;
587: l_participant_id_2 per_participants.participant_id%TYPE;
588: l_part_object_version_number_1 per_participants.object_version_number%TYPE;
589: l_part_object_version_number_2 per_participants.object_version_number%TYPE;
590: --
591: lv_object_version_number number := p_object_version_number ;
592: --
593: l_person_id NUMBER(9,0);

Line 690: FROM per_participants par

686: -- check if Participant exists for the Appraisal and the PersonId
687: --
688: CURSOR csr_get_participant IS
689: SELECT par.participant_id, par.object_version_number
690: FROM per_participants par
691: WHERE par.participation_in_id = p_appraisal_id
692: and par.participation_in_table = 'PER_APPRAISALS'
693: and par.participation_in_column = 'APPRAISAL_ID'
694: and par.person_id = p_person_id;

Line 1120: select participant_id,object_version_number from per_participants

1116:
1117: --
1118: --
1119: cursor cs_get_participants is
1120: select participant_id,object_version_number from per_participants
1121: where participation_in_id = p_appraisal_id
1122: and participation_in_table = 'PER_APPRAISALS'
1123: and participation_in_column = 'APPRAISAL_ID';
1124: --

Line 1170: (select participant_id from per_participants where

1166: select quest_answer_val_id from
1167: hr_quest_answer_values where questionnaire_answer_id in
1168: (select questionnaire_answer_id from hr_quest_answers
1169: where type = 'PARTICIPANT' and type_object_id in
1170: (select participant_id from per_participants where
1171: participation_in_table='PER_APPRAISALS' and participation_in_column='APPRAISAL_ID' and
1172: participation_in_id=p_appraisal_id
1173: )
1174: );