DBA Data[Home] [Help]

APPS.PA_PROJECT_DATES_UTILS dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 1019: from pa_proj_elem_ver_structure

1015:
1016: CURSOR get_latest_struct_ver(c_structure_id NUMBER)
1017: IS
1018: select element_version_id
1019: from pa_proj_elem_ver_structure
1020: where project_id = p_project_id
1021: and proj_element_id = c_structure_id
1022: and status_code = 'STRUCTURE_PUBLISHED'
1023: and latest_eff_published_flag = 'Y';

Line 1028: from pa_proj_elem_ver_structure

1024:
1025: CURSOR get_work_struct_ver(c_structure_id NUMBER)
1026: IS
1027: SELECT element_version_id
1028: from pa_proj_elem_ver_structure
1029: where project_id = p_project_id
1030: and proj_element_id = c_structure_id
1031: and status_code <> 'STRUCTURE_PUBLISHED';
1032: