APPS.PA_BUDGET_CORE dependencies on DUAL

Line 633: from sys.dual;

629:
630: -- get the dest version id
631: select pa_budget_versions_s.nextval
632: into x_dest_version_id
633: from sys.dual;
634:
635: -- populate pa_budget_versions
636: x_err_stage := 'create baselined version <' || to_char(x_dest_version_id)
637: || '><' || to_char(max_version)

Line 1051: from sys.dual;

1047: else
1048: --insert into pa_budget_versions
1049: select pa_budget_versions_s.nextval
1050: into l_dest_version_id
1051: from sys.dual;
1052:
1053: insert into pa_budget_versions(
1054: budget_version_id,
1055: project_id,

Line 1799: from sys.dual;

1795: || '><' || x_dest_budget_type_code || '>' ;
1796:
1797: select pa_budget_versions_s.nextval
1798: into x_dest_version_id
1799: from sys.dual;
1800: insert into pa_budget_versions(
1801: budget_version_id,
1802: project_id,
1803: budget_type_code,

Line 2575: -- individual processing block due to performance reason so that

2571:
2572: end if; */
2573:
2574: -- bug 4772773: Splitted the above select and insert as following
2575: -- individual processing block due to performance reason so that
2576: -- we can make use of bulk processing logic wherever possible and required.
2577: --Bug 5151476
2578: if Nvl(x_shift_days, 0) = 0 OR (nvl(x_periods,0)=0 AND
2579: (x_time_phased_type_code='P' OR x_time_phased_type_code='G')) then