DBA Data[Home] [Help]

APPS.PA_WORKPLAN_ATTR_UTILS dependencies on PA_STRUCTURE_TYPES

Line 292: pa_structure_types pst

288: SELECT ppwa.wp_enable_version_flag
289: FROM pa_proj_workplan_attr ppwa,
290: pa_proj_elements ppe,
291: pa_proj_structure_types ppst,
292: pa_structure_types pst
293: WHERE ppwa.project_id = p_project_id
294: AND ppe.project_id = ppwa.project_id
295: AND ppe.proj_element_id = ppwa.proj_element_id
296: AND ppe.proj_element_id = ppst.proj_element_id

Line 332: pa_structure_types pst

328: select ppwa.AUTO_SYNC_TXN_DATE_FLAG
329: from pa_proj_workplan_attr ppwa,
330: pa_proj_elements ppe,
331: pa_proj_structure_types ppst,
332: pa_structure_types pst
333: WHERE ppwa.proj_element_id = p_proj_element_id
334: AND ppe.project_id = ppwa.project_id
335: AND ppe.proj_element_id = ppwa.proj_element_id
336: AND ppe.proj_element_id = ppst.proj_element_id

Line 369: pa_structure_types pst

365: select ppwa.TXN_DATE_SYNC_BUF_DAYS
366: from pa_proj_workplan_attr ppwa,
367: pa_proj_elements ppe,
368: pa_proj_structure_types ppst,
369: pa_structure_types pst
370: WHERE ppwa.proj_element_id = p_proj_element_id
371: AND ppe.project_id = ppwa.project_id
372: AND ppe.proj_element_id = ppwa.proj_element_id
373: AND ppe.proj_element_id = ppst.proj_element_id

Line 551: pa_structure_types pst

547: select ppwa.*
548: from pa_proj_workplan_attr ppwa,
549: pa_proj_elements ppe,
550: pa_proj_structure_types ppst,
551: pa_structure_types pst
552: WHERE ppwa.proj_element_id = p_proj_element_id
553: AND ppe.project_id = ppwa.project_id
554: AND ppe.proj_element_id = ppwa.proj_element_id
555: AND ppe.proj_element_id = ppst.proj_element_id

Line 653: pa_structure_types pst

649: select ppwa.WP_APPROVAL_REQD_FLAG
650: from pa_proj_workplan_attr ppwa,
651: pa_proj_elements ppe,
652: pa_proj_structure_types ppst,
653: pa_structure_types pst
654: WHERE ppwa.project_id = p_project_id
655: AND ppe.project_id = ppwa.project_id
656: AND ppe.proj_element_id = ppwa.proj_element_id
657: AND ppe.proj_element_id = ppst.proj_element_id

Line 684: pa_structure_types pst

680: select ppwa.WP_AUTO_PUBLISH_FLAG
681: from pa_proj_workplan_attr ppwa,
682: pa_proj_elements ppe,
683: pa_proj_structure_types ppst,
684: pa_structure_types pst
685: WHERE ppwa.project_id = p_project_id
686: AND ppe.project_id = ppwa.project_id
687: AND ppe.proj_element_id = ppwa.proj_element_id
688: AND ppe.proj_element_id = ppst.proj_element_id

Line 715: pa_structure_types pst

711: select ppwa.AUTO_PUB_UPON_CREATION_FLAG
712: from pa_proj_workplan_attr ppwa,
713: pa_proj_elements ppe,
714: pa_proj_structure_types ppst,
715: pa_structure_types pst
716: WHERE ppwa.project_id = p_template_id
717: AND ppe.project_id = ppwa.project_id
718: AND ppe.proj_element_id = ppwa.proj_element_id
719: AND ppe.proj_element_id = ppst.proj_element_id