DBA Data[Home] [Help]

APPS.GMS_BUDGET_CORE dependencies on DUAL

Line 622: from sys.dual;

618:
619: -- get the dest version id
620: select gms_budget_versions_s.nextval
621: into x_dest_version_id
622: from sys.dual;
623:
624: -- populate gms_budget_versions
625: x_err_stage := 'create baselined version <' || to_char(x_dest_version_id)
626: || '><' || to_char(max_version)

Line 1264: from sys.dual;

1260: || '><' || x_dest_budget_type_code || '>' ;
1261:
1262: select gms_budget_versions_s.nextval
1263: into x_dest_version_id
1264: from sys.dual;
1265:
1266: insert into gms_budget_versions(
1267: budget_version_id,
1268: project_id,

Line 1945: FROM DUAL

1941: -- Bug 4908109 : Performance Fix
1942: begin
1943: SELECT 1
1944: INTO dummy
1945: FROM DUAL
1946: WHERE EXISTS (
1947: SELECT 1
1948: FROM pa_tasks
1949: WHERE project_id = x_project_id

Line 1967: FROM DUAL

1963: -- Bug 4908109 : Performance Fix
1964: begin
1965: SELECT 1
1966: INTO dummy
1967: FROM DUAL
1968: WHERE EXISTS (
1969: SELECT 1
1970: FROM pa_resource_list_members prl
1971: WHERE prl.resource_list_member_id = x_rlmid