eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TASK_PVT1 dependencies on PA_PROJECTS_ALL

Line 259: FROM pa_projects_all

255:
256: CURSOR cur_projs
257: IS
258: SELECT carrying_out_organization_id
259: FROM pa_projects_all
260: WHERE project_id = p_project_id;
261:
262: CURSOR cur_struc_type
263: IS

Line 389: FROM pa_projects_all

385: l_template_flag VARCHAR2(1) := 'N';
386: CURSOR cur_proj_tmp
387: IS
388: SELECT template_flag
389: FROM pa_projects_all
390: WHERE project_id = p_project_id;
391: --bug 13551360
392: --bug 13923366 start here
393: l_pm_source_code PA_PROJ_ELEMENTS.PM_SOURCE_CODE%TYPE;

Line 1215: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure

1211: END IF;
1212: end 3459905 */
1213: /*SELECT nvl( wbs_record_version_number, 1 )
1214: INTO l_wbs_record_version_number
1215: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
1216: FROM pa_proj_elem_ver_structure
1217: -- HY FROM pa_projects_all
1218: WHERE project_id = p_project_id
1219: AND element_version_id = p_structure_version_id;*/

Line 1217: -- HY FROM pa_projects_all

1213: /*SELECT nvl( wbs_record_version_number, 1 )
1214: INTO l_wbs_record_version_number
1215: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
1216: FROM pa_proj_elem_ver_structure
1217: -- HY FROM pa_projects_all
1218: WHERE project_id = p_project_id
1219: AND element_version_id = p_structure_version_id;*/
1220: l_wbs_record_version_number := 1; --temporarily
1221:

Line 1832: FROM pa_projects_all

1828: l_template_flag VARCHAR2(1) := 'N';
1829: CURSOR cur_proj_tmp(c_project_id NUMBER )
1830: IS
1831: SELECT template_flag
1832: FROM pa_projects_all
1833: WHERE project_id = c_project_id;
1834: --bug 3010538
1835:
1836: -- Bug 3075609. If a task type is changed to a non progressible

Line 5393: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure

5389:
5390: CURSOR cur_pa_projs( p_project_id NUMBER )
5391: IS
5392: SELECT wbs_record_version_number
5393: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
5394: FROM pa_proj_elem_ver_structure
5395: -- HY FROM pa_projects_all
5396: WHERE project_id = p_project_id;
5397:

Line 5395: -- HY FROM pa_projects_all

5391: IS
5392: SELECT wbs_record_version_number
5393: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
5394: FROM pa_proj_elem_ver_structure
5395: -- HY FROM pa_projects_all
5396: WHERE project_id = p_project_id;
5397:
5398: CURSOR cur_pa_tasks( p_task_id NUMBER )
5399: IS

Line 5605: from pa_projects_all ppa

5601: -- Begin fix for Bug # 4506308.
5602:
5603: cursor l_cur_projects_all(c_project_id NUMBER) is
5604: select ppa.template_flag, ppa.record_version_number
5605: from pa_projects_all ppa
5606: where ppa.project_id = c_project_id;
5607:
5608: l_ver_enabled VARCHAR2(1);
5609: l_template_flag VARCHAR2(1);

Line 6992: from pa_projects_all a, pa_proj_element_versions b

6988: X_Row_id VARCHAR2(255);
6989:
6990: cursor get_cal_id IS
6991: select a.calendar_id
6992: from pa_projects_all a, pa_proj_element_versions b
6993: where a.project_id = b.project_id
6994: and b.element_version_id = p_element_version_id;
6995:
6996: /* Bug 2791413 Begin */

Line 9629: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure

9625:
9626: CURSOR cur_pa_projs( p_project_id NUMBER )
9627: IS
9628: SELECT wbs_record_version_number
9629: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
9630: FROM pa_proj_elem_ver_structure
9631: -- HY FROM pa_projects_all
9632: WHERE project_id = p_project_id;
9633:

Line 9631: -- HY FROM pa_projects_all

9627: IS
9628: SELECT wbs_record_version_number
9629: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
9630: FROM pa_proj_elem_ver_structure
9631: -- HY FROM pa_projects_all
9632: WHERE project_id = p_project_id;
9633:
9634: CURSOR cur_pa_tasks( p_task_id NUMBER )
9635: IS

Line 10472: from pa_proj_elements ele, pa_projects_all proj

10468: l_working_parent_id NUMBER;
10469:
10470: CURSOR get_proj_info IS -- Bug 3083997. Modified the cursor to obtain
10471: select proj.project_id,proj.template_flag -- the project template flag also.
10472: from pa_proj_elements ele, pa_projects_all proj
10473: where ele.proj_element_id = p_task_id
10474: and ele.project_id = proj.project_id;
10475: l_project_id NUMBER;
10476: l_opt NUMBER;

Line 10478: l_template_flag pa_projects_all.template_flag%TYPE;

10474: and ele.project_id = proj.project_id;
10475: l_project_id NUMBER;
10476: l_opt NUMBER;
10477:
10478: l_template_flag pa_projects_all.template_flag%TYPE;
10479:
10480: BEGIN
10481: OPEN get_proj_info;
10482: FETCH get_proj_info INTO l_project_id,l_template_flag; -- Bug 3083997. To reflect the changed cursor.