382:
383: SELECT
384: P1.DISPLAY_SEQUENCE INTO l_curr_sequence
385: FROM
386: PA_PROJ_ELEMENT_VERSIONS P1
387: ,PA_PROJ_ELEMENT_VERSIONS P2
388: WHERE
389: P1.PROJ_ELEMENT_ID = p_curr_phase_id
390: AND P1.PARENT_STRUCTURE_VERSION_ID = P2.ELEMENT_VERSION_ID
383: SELECT
384: P1.DISPLAY_SEQUENCE INTO l_curr_sequence
385: FROM
386: PA_PROJ_ELEMENT_VERSIONS P1
387: ,PA_PROJ_ELEMENT_VERSIONS P2
388: WHERE
389: P1.PROJ_ELEMENT_ID = p_curr_phase_id
390: AND P1.PARENT_STRUCTURE_VERSION_ID = P2.ELEMENT_VERSION_ID
391: AND P2.PROJ_ELEMENT_ID = p_lifecycle_id;
391: AND P2.PROJ_ELEMENT_ID = p_lifecycle_id;
392:
393: SELECT P1.DISPLAY_SEQUENCE INTO l_future_sequence
394: FROM
395: PA_PROJ_ELEMENT_VERSIONS P1
396: ,PA_PROJ_ELEMENT_VERSIONS P2
397: WHERE
398: P1.PROJ_ELEMENT_ID = p_future_phase_id
399: AND P1.PARENT_STRUCTURE_VERSION_ID = P2.ELEMENT_VERSION_ID
392:
393: SELECT P1.DISPLAY_SEQUENCE INTO l_future_sequence
394: FROM
395: PA_PROJ_ELEMENT_VERSIONS P1
396: ,PA_PROJ_ELEMENT_VERSIONS P2
397: WHERE
398: P1.PROJ_ELEMENT_ID = p_future_phase_id
399: AND P1.PARENT_STRUCTURE_VERSION_ID = P2.ELEMENT_VERSION_ID
400: AND P2.PROJ_ELEMENT_ID = p_lifecycle_id;