APPS.HR_WPM_MASS_APR_PUSH dependencies on PER_OBJECTIVES

Line 1162: p_scorecard_id per_objectives.scorecard_id%TYPE

1158: FROM per_assessment_types
1159: WHERE assessment_type_id = p_assessment_type_id;
1160:
1161: CURSOR get_scorecard_objectives (
1162: p_scorecard_id per_objectives.scorecard_id%TYPE
1163: )
1164: IS
1165: SELECT objective_id, scorecard_id, object_version_number, NAME
1166: FROM per_objectives

Line 1166: FROM per_objectives

1162: p_scorecard_id per_objectives.scorecard_id%TYPE
1163: )
1164: IS
1165: SELECT objective_id, scorecard_id, object_version_number, NAME
1166: FROM per_objectives
1167: WHERE scorecard_id = p_scorecard_id
1168: AND appraise_flag = 'Y'
1169: AND appraisal_id IS NULL;
1170:

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

1567:
1568: CLOSE find_appraisal;
1569:
1570: --- added this part of the code to attach appraisal id to objectives
1571: --- of per_objectives records which are populated due to new eligible objectives in scorecards
1572: --- for already created appraisals.If new objectives are added to an existing scorecard
1573: --- that shud also be added to appraisals.Bug no 6015946
1574:
1575: -- if( l_found_appraisal and l_appraisal_status <> 'COMPLETED') then

Line 2393: from per_objectives

2389: /*
2390: -- Scorecard Objectives
2391: CURSOR csr_sc_objectives(p_scorecard_id number) IS
2392: select objective_id, object_version_number
2393: from per_objectives
2394: where scorecard_id = p_scorecard_id;
2395: */
2396: CURSOR csr_plan_appraisals (plan_id per_appraisals.plan_id%TYPE)
2397: IS