APPS.PA_PROJECT_CORE dependencies on PA_PROJECTS_ALL

Line 114: FROM PA_PROJECTS_ALL

110: and object_type = 'PA_PROJECTS');
111:
112: CURSOR get_template_flag IS
113: SELECT template_flag
114: FROM PA_PROJECTS_ALL
115: WHERE project_id = x_project_id;
116:
117: -- added for bug#3693197
118: CURSOR get_all_tasks IS

Line 1545: FROM pa_projects_all

1541:
1542: --Added for bug 3617393
1543: CURSOR get_template_flag(c_project_id IN NUMBER) IS
1544: SELECT template_flag
1545: FROM pa_projects_all
1546: WHERE project_id = c_project_id;
1547:
1548: cursor cc_task_id_csr(x_taskid number) ---- Bug 6629057
1549: is select cc_tax_task_id from pa_projects_all pj

Line 1549: is select cc_tax_task_id from pa_projects_all pj

1545: FROM pa_projects_all
1546: WHERE project_id = c_project_id;
1547:
1548: cursor cc_task_id_csr(x_taskid number) ---- Bug 6629057
1549: is select cc_tax_task_id from pa_projects_all pj
1550: where pj.project_id = l_project_id;
1551:
1552: l_template_flag VARCHAR2(1) := 'N';
1553: --Added for bug 3617393

Line 1607: update pa_projects_all

1603: if cc_task_id_csr%notfound then
1604: close cc_task_id_csr;
1605: end if;
1606: if(l_cc_tax_task_id = x_task_id) then
1607: update pa_projects_all
1608: set cc_tax_task_id = null
1609: where project_id = l_project_id;
1610: close cc_task_id_csr;
1611: end if;