DBA Data[Home] [Help]

APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PA_PROJ_STRUCTURE_TYPES_S

Line 8251: pa_proj_structure_types_s.nextval

8247: ,LAST_UPDATED_BY
8248: ,LAST_UPDATE_LOGIN
8249: ,RECORD_VERSION_NUMBER )
8250: SELECT
8251: pa_proj_structure_types_s.nextval
8252: ,ppe.proj_element_id
8253: ,ppst.structure_type_id --structure type
8254: ,sysdate
8255: ,l_user_id

Line 10020: pa_proj_structure_types struc,

10016: AND ppev.proj_element_id = ppe.proj_element_id
10017: AND ppev.parent_structure_version_id =
10018: ( SELECT ppevst.element_version_id --Changed the inner query for bug 4215666.
10019: FROM pa_proj_elem_ver_structure ppevst,
10020: pa_proj_structure_types struc,
10021: pa_structure_types stype
10022: WHERE ppevst.project_id = p_dest_project_id
10023: AND ppevst.current_flag = 'Y'
10024: AND ppevst.status_code = 'STRUCTURE_PUBLISHED'

Line 11057: pa_proj_structure_types_s.nextval

11053: ,LAST_UPDATED_BY
11054: ,LAST_UPDATE_LOGIN
11055: ,RECORD_VERSION_NUMBER )
11056: SELECT
11057: pa_proj_structure_types_s.nextval
11058: , ppe.proj_element_id
11059: , ppst.structure_type_id --structure type
11060: , sysdate
11061: , l_user_id