DBA Data[Home] [Help]

APPS.PA_PROJECT_DATES_UTILS dependencies on PA_PROJ_STRUCTURE_TYPES

Line 40: from pa_proj_workplan_attr ppwa, pa_proj_elements ppe, pa_proj_structure_types ppst, pa_structure_types pst

36: -- Begin fix for Bug # 12940745.
37: CURSOR c_auto_flag_enabled
38: IS
39: select ppwa.AUTO_SYNC_TXN_DATE_FLAG, ppwa.wp_enable_version_flag
40: from pa_proj_workplan_attr ppwa, pa_proj_elements ppe, pa_proj_structure_types ppst, pa_structure_types pst
41: WHERE ppe.project_id = p_project_id
42: AND ppe.project_id = ppwa.project_id
43: AND ppe.proj_element_id = ppwa.proj_element_id
44: AND ppe.proj_element_id = ppst.proj_element_id

Line 1008: pa_proj_structure_types b,

1004: CURSOR get_structure
1005: IS
1006: SELECT a.proj_element_id
1007: FROM pa_proj_elements a,
1008: pa_proj_structure_types b,
1009: pa_structure_types c
1010: WHERE a.proj_element_id = b.proj_element_id
1011: AND a.object_type = 'PA_STRUCTURES'
1012: AND a.project_id = p_project_id