DBA Data[Home] [Help]

APPS.GMS_SUMM_FUNDING_PKG dependencies on DUAL

Line 286: IS SELECT 1 FROM DUAL

282: FUNCTION gms_funding_exists (p_installment_id NUMBER, p_project_id NUMBER, p_task_id NUMBER)
283: RETURN BOOLEAN
284: IS
285: CURSOR c_funding_exists
286: IS SELECT 1 FROM DUAL
287: WHERE EXISTS (SELECT 1
288: FROM gms_project_fundings
289: WHERE installment_id = p_installment_id
290: AND project_id = p_project_id

Line 329: from dual

325: -- Debashis. This does not seem to be correct. Where is task id ? Use the function gms_funding_exists instead. Bug 2270436
326: /*
327: Begin
328: select 'Y' into x_funding_exists
329: from dual
330: where exists ( select 1 from gms_project_fundings
331: where installment_id = x_installment_id
332: and project_id = x_project_id);
333: exception