DBA Data[Home] [Help]

APPS.PA_HR_TRANSACTIONS dependencies on DUAL

Line 176: FROM DUAL

172:
173: /*
174: cursor expenditure( p_job_id varchar ) is
175: SELECT 'Y'
176: FROM DUAL
177: WHERE EXISTS (
178: select null
179: from pa_expenditure_items_all pa
180: where (pa.job_id is not null

Line 192: DUAL WHERE EXISTS

188: --Bug 8242639 / 8370836
189: cursor expenditure( p_job_id varchar ) is
190: SELECT 'Y'
191: FROM
192: DUAL WHERE EXISTS
193: (( SELECT NULL FROM PA_EXPENDITURE_ITEMS_ALL PA WHERE
194: PA.JOB_ID IS NOT NULL AND PA.JOB_ID = P_JOB_ID )
195: UNION
196: (SELECT NULL FROM PA_EXPENDITURE_ITEMS_ALL PA WHERE