DBA Data[Home] [Help]

APPS.HR_WPM_MASS_APR_PUSH dependencies on DUAL

Line 1444: FROM DUAL

1440: l_object_version_number number;
1441: l_effective_date date := fnd_date.canonical_to_date(nvl(p_effective_date,trunc(sysdate)));
1442: CURSOR csr_pend_trans(p_plan_id IN NUMBER) IS
1443: SELECT 'x'
1444: FROM DUAL
1445: WHERE EXISTS (SELECT 'x'
1446: FROM hr_api_transactions t
1447: ,per_personal_scorecards sc
1448: WHERE t.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'