APPS.PA_PROJECT_PUB dependencies on PA_PROJ_STRUCTURE_TYPES

Line 5811: ,pa_proj_structure_types ppst

5807: --Added for bug 3746912
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 ;

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 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 22906: , pa_proj_structure_types b

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
22910: AND b.proj_element_id = c.proj_element_id

Line 22922: , pa_proj_structure_types b

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
22926: AND b.proj_element_id = c.proj_element_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 38627: pa_proj_structure_types ppst

38623: cursor c_prev_published_version(p_pa_project_id IN NUMBER) is
38624: select element_version_id from (
38625: select element_version_id
38626: from pa_proj_elem_ver_structure ppevs,
38627: pa_proj_structure_types ppst
38628: where ppevs.latest_eff_published_flag = 'N'
38629: and ppst.proj_element_id = ppevs.proj_element_id
38630: and ppst.structure_type_id = 1
38631: and ppevs.status_code = 'STRUCTURE_PUBLISHED'

Line 39652: FROM pa_proj_structure_types ppst

39648:
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' ;

Line 39950: FROM pa_proj_structure_types ppst

39946: ) IS
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' );

Line 41361: FROM pa_proj_structure_types ppst

41357:
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' );