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 1529: FROM pa_projects_all

1525:
1526: --Added for bug 3617393
1527: CURSOR get_template_flag(c_project_id IN NUMBER) IS
1528: SELECT template_flag
1529: FROM pa_projects_all
1530: WHERE project_id = c_project_id;
1531:
1532: cursor cc_task_id_csr(x_taskid number) ---- Bug 6629057
1533: is select cc_tax_task_id from pa_projects_all pj

Line 1533: is select cc_tax_task_id from pa_projects_all pj

1529: FROM pa_projects_all
1530: WHERE project_id = c_project_id;
1531:
1532: cursor cc_task_id_csr(x_taskid number) ---- Bug 6629057
1533: is select cc_tax_task_id from pa_projects_all pj
1534: where pj.project_id = l_project_id;
1535:
1536: l_template_flag VARCHAR2(1) := 'N';
1537: --Added for bug 3617393

Line 1591: update pa_projects_all

1587: if cc_task_id_csr%notfound then
1588: close cc_task_id_csr;
1589: end if;
1590: if(l_cc_tax_task_id = x_task_id) then
1591: update pa_projects_all
1592: set cc_tax_task_id = null
1593: where project_id = l_project_id;
1594: close cc_task_id_csr;
1595: end if;