APPS.PA_HR_TRANSACTIONS dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 179: from pa_expenditure_items_all pa

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
181: AND pa.job_id = P_JOB_ID)
182: OR
183: (pa.bill_job_id is not null

Line 193: (( SELECT NULL FROM PA_EXPENDITURE_ITEMS_ALL PA WHERE

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
197: PA.BILL_JOB_ID IS NOT NULL AND PA.BILL_JOB_ID = P_JOB_ID )

Line 196: (SELECT NULL FROM PA_EXPENDITURE_ITEMS_ALL PA WHERE

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
197: PA.BILL_JOB_ID IS NOT NULL AND PA.BILL_JOB_ID = P_JOB_ID )
198: );
199:
200: /* Commented for Bug#3211124