DBA Data[Home] [Help]

APPS.PER_PMS_BUS dependencies on DUAL

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