eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.EGO_ITEM_PVT dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 4032: FROM PA_PROJ_ELEMENT_VERSIONS P1

4028: AND rev.revision_id = cp_revision_id; --changed =rev.revision_id to cp_revision_id bug 7324207
4029:
4030: CURSOR c_get_phase_seq (cp_phase_id IN NUMBER ) IS
4031: SELECT p1.display_sequence
4032: FROM PA_PROJ_ELEMENT_VERSIONS P1
4033: WHERE P1.PROJ_ELEMENT_ID = cp_phase_id;
4034:
4035: CURSOR c_get_next_phase (cp_lifecycle_id IN NUMBER
4036: ,cp_phase_id IN NUMBER ) IS

Line 4038: FROM PA_PROJ_ELEMENT_VERSIONS P1, PA_PROJ_ELEMENT_VERSIONS P2

4034:
4035: CURSOR c_get_next_phase (cp_lifecycle_id IN NUMBER
4036: ,cp_phase_id IN NUMBER ) IS
4037: SELECT p1.proj_element_id, p1.display_sequence
4038: FROM PA_PROJ_ELEMENT_VERSIONS P1, PA_PROJ_ELEMENT_VERSIONS P2
4039: WHERE P1.PARENT_STRUCTURE_VERSION_ID = P2.ELEMENT_VERSION_ID
4040: AND P2.PROJ_ELEMENT_ID = cp_lifecycle_id
4041: AND P1.display_sequence >
4042: (SELECT P3.display_sequence

Line 4043: FROM PA_PROJ_ELEMENT_VERSIONS P3

4039: WHERE P1.PARENT_STRUCTURE_VERSION_ID = P2.ELEMENT_VERSION_ID
4040: AND P2.PROJ_ELEMENT_ID = cp_lifecycle_id
4041: AND P1.display_sequence >
4042: (SELECT P3.display_sequence
4043: FROM PA_PROJ_ELEMENT_VERSIONS P3
4044: WHERE P3.PROJ_ELEMENT_ID = cp_phase_id
4045: AND P3.PARENT_STRUCTURE_VERSION_ID = P1.parent_structure_version_id
4046: )
4047: ORDER BY p1.DISPLAY_SEQUENCE ASC;

Line 4052: FROM PA_PROJ_ELEMENT_VERSIONS P1, PA_PROJ_ELEMENT_VERSIONS P2

4048:
4049: CURSOR c_get_priv_phase (cp_lifecycle_id IN NUMBER
4050: ,cp_phase_id IN NUMBER ) IS
4051: SELECT p1.proj_element_id, p1.display_sequence
4052: FROM PA_PROJ_ELEMENT_VERSIONS P1, PA_PROJ_ELEMENT_VERSIONS P2
4053: WHERE P1.PARENT_STRUCTURE_VERSION_ID = P2.ELEMENT_VERSION_ID
4054: AND P2.PROJ_ELEMENT_ID = cp_lifecycle_id
4055: AND P1.display_sequence <
4056: (SELECT P3.display_sequence

Line 4057: FROM PA_PROJ_ELEMENT_VERSIONS P3

4053: WHERE P1.PARENT_STRUCTURE_VERSION_ID = P2.ELEMENT_VERSION_ID
4054: AND P2.PROJ_ELEMENT_ID = cp_lifecycle_id
4055: AND P1.display_sequence <
4056: (SELECT P3.display_sequence
4057: FROM PA_PROJ_ELEMENT_VERSIONS P3
4058: WHERE P3.PROJ_ELEMENT_ID = cp_phase_id
4059: AND P3.PARENT_STRUCTURE_VERSION_ID = P1.parent_structure_version_id
4060: )
4061: ORDER BY p1.DISPLAY_SEQUENCE DESC;

Line 4068: FROM PA_PROJ_ELEMENT_VERSIONS LC

4064: CURSOR c_chk_phase_against_lc ( cp_lifecycle_id IN NUMBER
4065: ,cp_phase_id IN NUMBER
4066: ) IS
4067: SELECT 1
4068: FROM PA_PROJ_ELEMENT_VERSIONS LC
4069: WHERE LC.proj_element_id = cp_lifecycle_id
4070: AND EXISTS
4071: (
4072: SELECT 1

Line 4073: FROM PA_PROJ_ELEMENT_VERSIONS PHASES

4069: WHERE LC.proj_element_id = cp_lifecycle_id
4070: AND EXISTS
4071: (
4072: SELECT 1
4073: FROM PA_PROJ_ELEMENT_VERSIONS PHASES
4074: WHERE PHASES.parent_structure_version_id = LC.element_version_id
4075: AND PHASES.proj_element_id = cp_phase_id
4076: );
4077: