APPS.PA_WORKPLAN_ATTR_UTILS dependencies on PA_PROJ_STRUCTURE_TYPES

Line 291: pa_proj_structure_types ppst,

287: CURSOR get_flag IS
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

Line 331: pa_proj_structure_types ppst,

327: CURSOR get_sync_flag IS
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

Line 368: pa_proj_structure_types ppst,

364: CURSOR get_sync_days IS
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

Line 550: pa_proj_structure_types ppst,

546: IS
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

Line 652: pa_proj_structure_types ppst,

648: CURSOR get_flag IS
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

Line 683: pa_proj_structure_types ppst,

679: CURSOR get_flag IS
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

Line 714: pa_proj_structure_types ppst,

710: CURSOR get_flag IS
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