APPS.HR_WPM_MASS_APR_PUSH dependencies on DUAL

Line 1283: FROM DUAL

1279: p_assessment_type_id IN NUMBER
1280: )
1281: IS
1282: SELECT 'Y'
1283: FROM DUAL
1284: WHERE EXISTS (
1285: SELECT '1'
1286: FROM per_assessments
1287: WHERE appraisal_id = p_appraisal_id

Line 2227: FROM DUAL

2223:
2224: CURSOR csr_pend_trans (p_plan_id IN NUMBER)
2225: IS
2226: SELECT 'x'
2227: FROM DUAL
2228: WHERE EXISTS (
2229: SELECT 'x'
2230: FROM hr_api_transactions t, per_personal_scorecards sc
2231: WHERE t.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'