APPS.PA_PROJECT_CORE2 dependencies on PA_PROJECTS

Line 82: from pa_projects old, pa_projects new

78: new.start_date,
79: new.completion_date,
80: old.carrying_out_organization_id,
81: new.carrying_out_organization_id
82: from pa_projects old, pa_projects new
83: where old.project_id = x_orig_project_id
84: and new.project_id = x_new_project_id;
85:
86: -- use min(start_date) as pseudo original project start

Line 161: from pa_projects_all

157:
158: l_versioning_enabled := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(x_orig_project_id);
159:
160: select template_flag into l_template_flag
161: from pa_projects_all
162: where project_id = x_orig_project_id;
163:
164: IF l_shared = 'Y' and
165: l_versioning_enabled = 'Y' and -- Bug 4188514

Line 387: pa_projects P

383:
384: x_err_stage := 'update CC Tax Task Id';
385:
386: UPDATE
387: pa_projects P
388: SET
389: P.cc_tax_task_id = (
390: SELECT new_tsk.task_id
391: FROM pa_tasks old_tsk

Line 845: -- pa_projects new_proj, bug 4189010

841: a.FUNDING_RATE_DATE,
842: a.FUNDING_EXCHANGE_RATE,
843: 1
844: from pa_billing_assignments a,
845: -- pa_projects new_proj, bug 4189010
846: pa_tasks old_tsk,
847: pa_tasks new_tsk
848: where a.project_id = x_orig_project_id
849: and a.top_task_id is not null