DBA Data[Home] [Help]

APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PA_PROJ_STRUCTURE_TYPES_S

Line 8512: pa_proj_structure_types_s.nextval

8508: ,LAST_UPDATED_BY
8509: ,LAST_UPDATE_LOGIN
8510: ,RECORD_VERSION_NUMBER )
8511: SELECT
8512: pa_proj_structure_types_s.nextval
8513: ,ppe.proj_element_id
8514: ,ppst.structure_type_id --structure type
8515: ,sysdate
8516: ,l_user_id

Line 10314: pa_proj_structure_types struc,

10310: AND ppev.proj_element_id = ppe.proj_element_id
10311: AND ppev.parent_structure_version_id =
10312: ( SELECT ppevst.element_version_id --Changed the inner query for bug 4215666.
10313: FROM pa_proj_elem_ver_structure ppevst,
10314: pa_proj_structure_types struc,
10315: pa_structure_types stype
10316: WHERE ppevst.project_id = p_dest_project_id
10317: AND ppevst.current_flag = 'Y'
10318: AND ppevst.status_code = 'STRUCTURE_PUBLISHED'

Line 11372: pa_proj_structure_types_s.nextval

11368: ,LAST_UPDATED_BY
11369: ,LAST_UPDATE_LOGIN
11370: ,RECORD_VERSION_NUMBER )
11371: SELECT
11372: pa_proj_structure_types_s.nextval
11373: , ppe.proj_element_id
11374: , ppst.structure_type_id --structure type
11375: , sysdate
11376: , l_user_id