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

249:
250: CURSOR cur_projs
251: IS
252: SELECT carrying_out_organization_id
253: FROM pa_projects_all
254: WHERE project_id = p_project_id;
255:
256: CURSOR cur_struc_type
257: IS

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

1103: END IF;
1104: end 3459905 */
1105: /*SELECT nvl( wbs_record_version_number, 1 )
1106: INTO l_wbs_record_version_number
1107: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
1108: FROM pa_proj_elem_ver_structure
1109: -- HY FROM pa_projects_all
1110: WHERE project_id = p_project_id
1111: AND element_version_id = p_structure_version_id;*/

Line 1109: -- HY FROM pa_projects_all

1105: /*SELECT nvl( wbs_record_version_number, 1 )
1106: INTO l_wbs_record_version_number
1107: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
1108: FROM pa_proj_elem_ver_structure
1109: -- HY FROM pa_projects_all
1110: WHERE project_id = p_project_id
1111: AND element_version_id = p_structure_version_id;*/
1112: l_wbs_record_version_number := 1; --temporarily
1113:

Line 1718: FROM pa_projects_all

1714: l_template_flag VARCHAR2(1) := 'N';
1715: CURSOR cur_proj_tmp(c_project_id NUMBER )
1716: IS
1717: SELECT template_flag
1718: FROM pa_projects_all
1719: WHERE project_id = c_project_id;
1720: --bug 3010538
1721:
1722: -- Bug 3075609. If a task type is changed to a non progressible

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

4889:
4890: CURSOR cur_pa_projs( p_project_id NUMBER )
4891: IS
4892: SELECT wbs_record_version_number
4893: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
4894: FROM pa_proj_elem_ver_structure
4895: -- HY FROM pa_projects_all
4896: WHERE project_id = p_project_id;
4897:

Line 4895: -- HY FROM pa_projects_all

4891: IS
4892: SELECT wbs_record_version_number
4893: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
4894: FROM pa_proj_elem_ver_structure
4895: -- HY FROM pa_projects_all
4896: WHERE project_id = p_project_id;
4897:
4898: CURSOR cur_pa_tasks( p_task_id NUMBER )
4899: IS

Line 5105: from pa_projects_all ppa

5101: -- Begin fix for Bug # 4506308.
5102:
5103: cursor l_cur_projects_all(c_project_id NUMBER) is
5104: select ppa.template_flag, ppa.record_version_number
5105: from pa_projects_all ppa
5106: where ppa.project_id = c_project_id;
5107:
5108: l_ver_enabled VARCHAR2(1);
5109: l_template_flag VARCHAR2(1);

Line 6389: from pa_projects_all a, pa_proj_element_versions b

6385: X_Row_id VARCHAR2(255);
6386:
6387: cursor get_cal_id IS
6388: select a.calendar_id
6389: from pa_projects_all a, pa_proj_element_versions b
6390: where a.project_id = b.project_id
6391: and b.element_version_id = p_element_version_id;
6392:
6393: /* Bug 2791413 Begin */

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

8879:
8880: CURSOR cur_pa_projs( p_project_id NUMBER )
8881: IS
8882: SELECT wbs_record_version_number
8883: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
8884: FROM pa_proj_elem_ver_structure
8885: -- HY FROM pa_projects_all
8886: WHERE project_id = p_project_id;
8887:

Line 8885: -- HY FROM pa_projects_all

8881: IS
8882: SELECT wbs_record_version_number
8883: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
8884: FROM pa_proj_elem_ver_structure
8885: -- HY FROM pa_projects_all
8886: WHERE project_id = p_project_id;
8887:
8888: CURSOR cur_pa_tasks( p_task_id NUMBER )
8889: IS

Line 9715: from pa_proj_elements ele, pa_projects_all proj

9711: l_working_parent_id NUMBER;
9712:
9713: CURSOR get_proj_info IS -- Bug 3083997. Modified the cursor to obtain
9714: select proj.project_id,proj.template_flag -- the project template flag also.
9715: from pa_proj_elements ele, pa_projects_all proj
9716: where ele.proj_element_id = p_task_id
9717: and ele.project_id = proj.project_id;
9718: l_project_id NUMBER;
9719: l_opt NUMBER;

Line 9721: l_template_flag pa_projects_all.template_flag%TYPE;

9717: and ele.project_id = proj.project_id;
9718: l_project_id NUMBER;
9719: l_opt NUMBER;
9720:
9721: l_template_flag pa_projects_all.template_flag%TYPE;
9722:
9723: BEGIN
9724: OPEN get_proj_info;
9725: FETCH get_proj_info INTO l_project_id,l_template_flag; -- Bug 3083997. To reflect the changed cursor.