APPS.PA_PROJECT_DATES_UTILS dependencies on PA_PROJ_WORKPLAN_ATTR

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 1035: FROM PA_PROJ_WORKPLAN_ATTR

1031: and status_code <> 'STRUCTURE_PUBLISHED';
1032:
1033: CURSOR get_buffer(c_structure_id NUMBER) IS
1034: SELECT NVL(TXN_DATE_SYNC_BUF_DAYS,0)
1035: FROM PA_PROJ_WORKPLAN_ATTR
1036: WHERE PROJ_ELEMENT_ID = c_structure_id;
1037:
1038: BEGIN
1039: