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_PROJECT_PUB dependencies on PA_STRUCTURE_TYPES

Line 5812: ,pa_structure_types pst

5808: CURSOR cur_get_str_type_from_str_id( c_structure_version_id IN NUMBER ) IS
5809: SELECT pst.structure_type
5810: FROM pa_proj_element_versions ppev
5811: ,pa_proj_structure_types ppst
5812: ,pa_structure_types pst
5813: WHERE ppev.element_version_id = c_structure_version_id
5814: AND ppev.proj_element_id = ppst.proj_element_id
5815: AND ppst.structure_type_id = pst.structure_type_id ;
5816: -- Added This cursor for Bug No 4689326

Line 10096: CURSOR cur_struc_ver_fin(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)

10092:
10093: -- 3693229 end
10094:
10095: --Cursor to get the current published version when structure type and project id is known
10096: CURSOR cur_struc_ver_fin(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)
10097: IS
10098: SELECT c.element_version_id
10099: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
10100: ,pa_proj_elem_ver_structure d

Line 10099: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b

10095: --Cursor to get the current published version when structure type and project id is known
10096: CURSOR cur_struc_ver_fin(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)
10097: IS
10098: SELECT c.element_version_id
10099: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
10100: ,pa_proj_elem_ver_structure d
10101: WHERE c.project_id = c_project_id
10102: AND a.structure_type_id = b.structure_type_id
10103: AND b.proj_element_id = c.proj_element_id

Line 10111: CURSOR cur_struc_ver_wp(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)

10107: AND d.status_code = 'STRUCTURE_PUBLISHED'
10108: AND d.latest_eff_published_flag = 'Y';
10109:
10110: --Cursor to get the working version when structure type and project id is known
10111: CURSOR cur_struc_ver_wp(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)
10112: IS
10113: SELECT c.element_version_id
10114: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
10115: ,pa_proj_elem_ver_structure d

Line 10114: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b

10110: --Cursor to get the working version when structure type and project id is known
10111: CURSOR cur_struc_ver_wp(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)
10112: IS
10113: SELECT c.element_version_id
10114: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
10115: ,pa_proj_elem_ver_structure d
10116: WHERE c.project_id = c_project_id
10117: AND a.structure_type_id = b.structure_type_id
10118: AND b.proj_element_id = c.proj_element_id

Line 22905: , pa_structure_types a

22901: CURSOR cur_get_working_struc_ver (l_project_id NUMBER,l_structure_type VARCHAR2)
22902: IS
22903: SELECT c.element_version_id
22904: FROM pa_proj_element_versions c
22905: , pa_structure_types a
22906: , pa_proj_structure_types b
22907: , pa_proj_elem_ver_structure d
22908: WHERE c.project_id = l_project_id
22909: AND a.structure_type_id = b.structure_type_id

Line 22921: , pa_structure_types a

22917: CURSOR cursor_get_struc_ver (l_project_id NUMBER,l_structure_type VARCHAR2)
22918: IS
22919: SELECT c.element_version_id
22920: FROM pa_proj_element_versions c
22921: , pa_structure_types a
22922: , pa_proj_structure_types b
22923: , pa_proj_elem_ver_structure d
22924: WHERE c.project_id = l_project_id
22925: AND a.structure_type_id = b.structure_type_id

Line 37037: , pa_proj_structure_types ppst, pa_structure_types pst

37033:
37034: cursor l_cur_task_ver_id(c_task_id NUMBER, c_structure_type VARCHAR2) is
37035: select ppev.element_version_id
37036: from pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
37037: , pa_proj_structure_types ppst, pa_structure_types pst
37038: where ppevs.proj_element_id = ppst.proj_element_id
37039: and ppst.structure_type_id = pst.structure_type_id
37040: and ppev.project_id = ppevs.project_id
37041: and ppev.parent_structure_version_id = ppevs.element_version_id

Line 37620: , pa_proj_structure_types ppst, pa_structure_types pst

37616:
37617: cursor l_cur_task_ver_id(c_task_id NUMBER, c_structure_type VARCHAR2) is
37618: select ppev.element_version_id
37619: from pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
37620: , pa_proj_structure_types ppst, pa_structure_types pst
37621: where ppevs.proj_element_id = ppst.proj_element_id
37622: and ppst.structure_type_id = pst.structure_type_id
37623: and ppev.project_id = ppevs.project_id
37624: and ppev.parent_structure_version_id = ppevs.element_version_id

Line 38210: , pa_proj_structure_types ppst, pa_structure_types pst

38206:
38207: cursor l_cur_task_ver_id(c_task_id NUMBER, c_structure_type VARCHAR2) is
38208: select ppev.element_version_id
38209: from pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
38210: , pa_proj_structure_types ppst, pa_structure_types pst
38211: where ppevs.proj_element_id = ppst.proj_element_id
38212: and ppst.structure_type_id = pst.structure_type_id
38213: and ppev.project_id = ppevs.project_id
38214: and ppev.parent_structure_version_id = ppevs.element_version_id

Line 39653: ,pa_structure_types pst

39649: CURSOR cur_struc_type( c_structure_id NUMBER )
39650: IS
39651: SELECT 'Y'
39652: FROM pa_proj_structure_types ppst
39653: ,pa_structure_types pst
39654: WHERE ppst.proj_element_id = c_structure_id
39655: AND ppst.structure_type_id = pst.structure_type_id
39656: AND pst.structure_type_class_code = 'FINANCIAL' ;
39657:

Line 39951: ,pa_structure_types pst

39947:
39948: CURSOR cur_struc_type( c_structure_id NUMBER ) IS
39949: SELECT 'Y'
39950: FROM pa_proj_structure_types ppst
39951: ,pa_structure_types pst
39952: WHERE ppst.proj_element_id = c_structure_id
39953: AND ppst.structure_type_id = pst.structure_type_id
39954: AND pst.structure_type_class_code IN( 'FINANCIAL' );
39955:

Line 41362: ,pa_structure_types pst

41358:
41359: CURSOR cur_struc_type( c_structure_id NUMBER ) IS
41360: SELECT 'Y'
41361: FROM pa_proj_structure_types ppst
41362: ,pa_structure_types pst
41363: WHERE ppst.proj_element_id = c_structure_id
41364: AND ppst.structure_type_id = pst.structure_type_id
41365: AND pst.structure_type_class_code IN( 'FINANCIAL' );
41366: