APPS.HR_WPM_MASS_APR_PUSH dependencies on PER_OBJECTIVES

Line 861: cursor get_scorecard_objectives(p_scorecard_id per_objectives.scorecard_id%TYPE)

857: IS
858: select DEFAULT_JOB_COMPETENCIES from per_assessment_types
859: where assessment_type_id = p_assessment_type_id;
860:
861: cursor get_scorecard_objectives(p_scorecard_id per_objectives.scorecard_id%TYPE)
862: is
863: select objective_id, scorecard_id, object_version_number, name from per_objectives
864: where scorecard_id = p_scorecard_id
865: and APPRAISE_FLAG = 'Y';

Line 863: select objective_id, scorecard_id, object_version_number, name from per_objectives

859: where assessment_type_id = p_assessment_type_id;
860:
861: cursor get_scorecard_objectives(p_scorecard_id per_objectives.scorecard_id%TYPE)
862: is
863: select objective_id, scorecard_id, object_version_number, name from per_objectives
864: where scorecard_id = p_scorecard_id
865: and APPRAISE_FLAG = 'Y';
866:
867: cursor get_assess_templ_info (p_assess_templ per_appraisal_templates.assessment_type_id%TYPE)

Line 1083: --- of per_objectives records which are populated due to new eligible objectives in scorecards

1079: end if;
1080: close find_appraisal;
1081:
1082: --- added this part of the code to attach appraisal id to objectives
1083: --- of per_objectives records which are populated due to new eligible objectives in scorecards
1084: --- for already created appraisals.If new objectives are added to an existing scorecard
1085: --- that shud also be added to appraisals.Bug no 6015946
1086:
1087: -- if( l_found_appraisal and l_appraisal_status <> 'COMPLETED') then

Line 1553: from per_objectives

1549: /*
1550: -- Scorecard Objectives
1551: CURSOR csr_sc_objectives(p_scorecard_id number) IS
1552: select objective_id, object_version_number
1553: from per_objectives
1554: where scorecard_id = p_scorecard_id;
1555: */
1556: CURSOR csr_plan_appraisals(plan_id per_appraisals.plan_id%TYPE) IS
1557: select appraisal_id, object_version_number from per_appraisals