DBA Data[Home] [Help]

APPS.GMS_BUDGET_PUB dependencies on DUAL

Line 637: from dual

633: CURSOR l_budgetary_controls_csr(p_project_id IN NUMBER,
634: p_award_id IN NUMBER)
635: IS
636: select 1
637: from dual
638: where exists(
639: select 'x'
640: from gms_budgetary_controls
641: where project_id = p_project_id

Line 2409: from sys.dual;

2405: p_pm_product_code,
2406: p_pm_budget_reference,
2407: NULL,
2408: l_first_budget_period -- Bug 3104308
2409: from sys.dual;
2410:
2411: ----------------------------------------------------------------------------------------------
2412:
2413: -- temporary solution

Line 4867: from sys.dual;

4863: || '>';
4864:
4865: select gms_resource_assignments_s.nextval
4866: into l_resource_assignment_id
4867: from sys.dual;
4868:
4869: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after selecting from sequence');
4870:
4871: -- create a new resource assignment