APPS.HR_APPRAISALS_API dependencies on PER_ASSESSMENTS

Line 583: l_asn_object_version_number per_assessments.object_version_number%TYPE;

579: --
580:
581: l_proc varchar2(72) := g_package||'update_appraisal';
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;

Line 584: l_assessment_id per_assessments.assessment_id%TYPE;

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

Line 609: FROM per_assessments

605: IS
606: --
607: CURSOR csr_get_asn_details IS
608: SELECT assessment_id , object_version_number
609: FROM per_assessments
610: WHERE appraisal_id = p_appraisal_id;
611: --
612: BEGIN
613: --

Line 643: FROM per_assessments asn

639: --
640: CURSOR csr_get_period IS
641: SELECT asn.assessment_period_start_date, asn.assessment_period_end_date,
642: asn.assessment_date
643: FROM per_assessments asn
644: WHERE asn.appraisal_id = p_appraisal_id;
645: --
646: l_asn_start_date per_assessments.assessment_period_start_date%TYPE;
647: l_asn_end_date per_assessments.assessment_period_end_date%TYPE;

Line 646: l_asn_start_date per_assessments.assessment_period_start_date%TYPE;

642: asn.assessment_date
643: FROM per_assessments asn
644: WHERE asn.appraisal_id = p_appraisal_id;
645: --
646: l_asn_start_date per_assessments.assessment_period_start_date%TYPE;
647: l_asn_end_date per_assessments.assessment_period_end_date%TYPE;
648: l_asn_date per_assessments.assessment_date%TYPE;
649: --
650: BEGIN

Line 647: l_asn_end_date per_assessments.assessment_period_end_date%TYPE;

643: FROM per_assessments asn
644: WHERE asn.appraisal_id = p_appraisal_id;
645: --
646: l_asn_start_date per_assessments.assessment_period_start_date%TYPE;
647: l_asn_end_date per_assessments.assessment_period_end_date%TYPE;
648: l_asn_date per_assessments.assessment_date%TYPE;
649: --
650: BEGIN
651: --

Line 648: l_asn_date per_assessments.assessment_date%TYPE;

644: WHERE asn.appraisal_id = p_appraisal_id;
645: --
646: l_asn_start_date per_assessments.assessment_period_start_date%TYPE;
647: l_asn_end_date per_assessments.assessment_period_end_date%TYPE;
648: l_asn_date per_assessments.assessment_date%TYPE;
649: --
650: BEGIN
651: --
652: OPEN csr_get_period;

Line 1131: select assessment_id ,object_version_number from per_assessments

1127: select objective_id ,object_version_number from per_objectives
1128: where appraisal_id = p_appraisal_id;
1129: --
1130: cursor cs_get_assessments is
1131: select assessment_id ,object_version_number from per_assessments
1132: where appraisal_id = p_appraisal_id;
1133: --
1134: cursor cs_get_perf_ratings is
1135: select performance_rating_id ,object_version_number from per_performance_ratings

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

1139: cursor cs_get_comp_elmnt_rec is
1140: select competence_element_id ,object_version_number
1141: from per_competence_elements
1142: where assessment_id in
1143: (select assessment_id from per_assessments where appraisal_id = p_appraisal_id);
1144:
1145: cursor cs_get_perf_review_rec is
1146: select performance_review_id, object_version_number
1147: from per_performance_reviews