APPS.PER_PMS_BUS dependencies on PER_APPRAISAL_PERIODS
Line 1176: , per_appraisal_periods pap
1172: CURSOR csr_appr_exists (p_scorecard_id IN number)
1173: IS
1174: SELECT 'Y' from dual where exists( select null
1175: FROM per_personal_scorecards pps 1176: , per_appraisal_periods pap 1177: WHERE scorecard_id = p_scorecard_id
1178: AND pap.plan_id = pps.plan_id
1179: AND NVL(p_obj_setting_deadline, hr_api.g_sot) >= pap.task_start_date
1180: );