DBA Data[Home] [Help]

APPS.EGO_LIFECYCLE_USER_PUB dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 386: PA_PROJ_ELEMENT_VERSIONS P1

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

Line 387: ,PA_PROJ_ELEMENT_VERSIONS P2

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;

Line 395: PA_PROJ_ELEMENT_VERSIONS P1

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

Line 396: ,PA_PROJ_ELEMENT_VERSIONS P2

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;