APPS.PA_PROJECT_DATES_UTILS dependencies on PA_PROJ_ELEMENTS

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 680: pa_proj_elements_utils.convert_hr_to_days(duration)

676: IS
677: SELECT scheduled_start_date,
678: scheduled_finish_date,
679: last_update_date,
680: pa_proj_elements_utils.convert_hr_to_days(duration)
681: FROM PA_PROJ_ELEM_VER_SCHEDULE
682: WHERE element_version_id = p_structure_version_id;
683:
684: l_scheduled_start_date DATE;

Line 1007: FROM pa_proj_elements a,

1003:
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'