DBA Data[Home] [Help]

APPS.PA_PROJECT_DATES_UTILS dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 979: from pa_proj_elem_ver_structure

975:
976: CURSOR get_latest_struct_ver(c_structure_id NUMBER)
977: IS
978: select element_version_id
979: from pa_proj_elem_ver_structure
980: where project_id = p_project_id
981: and proj_element_id = c_structure_id
982: and status_code = 'STRUCTURE_PUBLISHED'
983: and latest_eff_published_flag = 'Y';

Line 988: from pa_proj_elem_ver_structure

984:
985: CURSOR get_work_struct_ver(c_structure_id NUMBER)
986: IS
987: SELECT element_version_id
988: from pa_proj_elem_ver_structure
989: where project_id = p_project_id
990: and proj_element_id = c_structure_id
991: and status_code <> 'STRUCTURE_PUBLISHED';
992: