Line 1174: SELECT 'Y' from dual where exists( select null
1170: ) IS
1171:
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