APPS.GMS_BUDGET_UTILS dependencies on DUAL

Line 458: from sys.dual

454:
455: if (x_budget_status_code = 'A') then
456: select 1
457: into dummy
458: from sys.dual
459: where exists
460: (select 1
461: from gms_budget_versions
462: where project_id = x_project_id

Line 471: from sys.dual

467:
468: elsif (x_budget_status_code = 'B') then
469: select 1
470: into dummy
471: from sys.dual
472: where exists
473: (select 1
474: from gms_budget_versions
475: where project_id = x_project_id

Line 510: from sys.dual

506:
507: if (x_budget_status_code = 'A') then
508: select 1
509: into dummy
510: from sys.dual
511: where exists
512: (select 1
513: from gms_budget_versions v,
514: gms_resource_assignments a

Line 525: from sys.dual

521:
522: elsif (x_budget_status_code = 'B') then
523: select 1
524: into dummy
525: from sys.dual
526: where exists
527: (select 1
528: from gms_budget_versions v,
529: pa_tasks t,

Line 569: from sys.dual

565: if (x_parent_member_id = 0) then
566:
567: select 1
568: into dummy
569: from sys.dual
570: where exists
571: (select 1
572: from pa_resource_list_members m,
573: gms_resource_assignments a

Line 582: from sys.dual

578:
579: else
580: select 1
581: into dummy
582: from sys.dual
583: where exists
584: (select 1
585: from gms_resource_assignments a
586: where a.budget_version_id = x_budget_version_id

Line 941: from sys.dual

937:
938: BEGIN
939: select 1
940: into l_dummy
941: from sys.dual
942: where exists
943: (select 1
944: from gms_resource_assignments
945: where budget_version_id = p_draft_version_id);

Line 1095: from dual

1091: old_stack varchar2(630);
1092:
1093: cursor get_rollup_level is
1094: select 'P'
1095: from dual
1096: where x_task_id is null
1097: union
1098: select 'T'
1099: from pa_tasks

Line 1114: from dual

1110: from pa_tasks
1111: where parent_task_id = x_task_id)
1112: union
1113: select 'L'
1114: from dual
1115: where x_task_id is not null
1116: and not exists (select 'X'
1117: from pa_tasks
1118: where parent_task_id = x_task_id);