APPS.HR_APPRAISALS_API dependencies on PER_ASSESSMENTS

Line 593: l_asn_object_version_number per_assessments.object_version_number%TYPE;

589: --
590:
591: l_proc varchar2(72) := g_package||'update_appraisal';
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;

Line 594: l_assessment_id per_assessments.assessment_id%TYPE;

590:
591: l_proc varchar2(72) := g_package||'update_appraisal';
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;

Line 626: FROM per_assessments

622: IS
623: --
624: CURSOR csr_get_asn_details IS
625: SELECT assessment_id , object_version_number
626: FROM per_assessments
627: WHERE appraisal_id = p_appraisal_id;
628: --
629: BEGIN
630: --

Line 660: FROM per_assessments asn

656: --
657: CURSOR csr_get_period IS
658: SELECT asn.assessment_period_start_date, asn.assessment_period_end_date,
659: asn.assessment_date
660: FROM per_assessments asn
661: WHERE asn.appraisal_id = p_appraisal_id;
662: --
663: l_asn_start_date per_assessments.assessment_period_start_date%TYPE;
664: l_asn_end_date per_assessments.assessment_period_end_date%TYPE;

Line 663: l_asn_start_date per_assessments.assessment_period_start_date%TYPE;

659: asn.assessment_date
660: FROM per_assessments asn
661: WHERE asn.appraisal_id = p_appraisal_id;
662: --
663: l_asn_start_date per_assessments.assessment_period_start_date%TYPE;
664: l_asn_end_date per_assessments.assessment_period_end_date%TYPE;
665: l_asn_date per_assessments.assessment_date%TYPE;
666: --
667: BEGIN

Line 664: l_asn_end_date per_assessments.assessment_period_end_date%TYPE;

660: FROM per_assessments asn
661: WHERE asn.appraisal_id = p_appraisal_id;
662: --
663: l_asn_start_date per_assessments.assessment_period_start_date%TYPE;
664: l_asn_end_date per_assessments.assessment_period_end_date%TYPE;
665: l_asn_date per_assessments.assessment_date%TYPE;
666: --
667: BEGIN
668: --

Line 665: l_asn_date per_assessments.assessment_date%TYPE;

661: WHERE asn.appraisal_id = p_appraisal_id;
662: --
663: l_asn_start_date per_assessments.assessment_period_start_date%TYPE;
664: l_asn_end_date per_assessments.assessment_period_end_date%TYPE;
665: l_asn_date per_assessments.assessment_date%TYPE;
666: --
667: BEGIN
668: --
669: OPEN csr_get_period;

Line 1179: select assessment_id ,object_version_number from per_assessments

1175: select objective_id ,object_version_number from per_objectives
1176: where appraisal_id = p_appraisal_id;
1177: --
1178: cursor cs_get_assessments is
1179: select assessment_id ,object_version_number from per_assessments
1180: where appraisal_id = p_appraisal_id;
1181: --
1182: cursor cs_get_perf_ratings is
1183: select performance_rating_id ,object_version_number from per_performance_ratings

Line 1191: (select assessment_id from per_assessments where appraisal_id = p_appraisal_id);

1187: cursor cs_get_comp_elmnt_rec is
1188: select competence_element_id ,object_version_number
1189: from per_competence_elements
1190: where assessment_id in
1191: (select assessment_id from per_assessments where appraisal_id = p_appraisal_id);
1192:
1193: cursor cs_get_perf_review_rec is
1194: select performance_review_id, object_version_number
1195: from per_performance_reviews