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 395: pa_projects P

391:
392: x_err_stage := 'update CC Tax Task Id';
393:
394: UPDATE
395: pa_projects P
396: SET
397: P.cc_tax_task_id = (
398: SELECT new_tsk.task_id
399: FROM pa_tasks old_tsk

Line 902: -- pa_projects new_proj, bug 4189010

898: a.FUNDING_RATE_DATE,
899: a.FUNDING_EXCHANGE_RATE,
900: 1
901: from pa_billing_assignments a,
902: -- pa_projects new_proj, bug 4189010
903: pa_tasks old_tsk,
904: pa_tasks new_tsk
905: where a.project_id = x_orig_project_id
906: and a.top_task_id is not null