APPS.PA_PROJ_ELEMENTS_UTILS dependencies on PA_PROJ_ELEM_RELATIONSHIP_T

Line 1522: -- bug 13895419 fetch data from PA_PROJ_ELEM_RELATIONSHIP_T table

1518: AND rel.object_id_to1 = pev.element_version_id
1519: AND pev.parent_structure_version_id = c_parent_structure_ver_id
1520: AND pev.display_sequence < c_display_seq);
1521:
1522: -- bug 13895419 fetch data from PA_PROJ_ELEM_RELATIONSHIP_T table
1523: CURSOR GET_PREV_PEER_TASK_CSR1(c_parent_structure_ver_id NUMBER, c_parent_task_id NUMBER, c_display_seq NUMBER)
1524: IS
1525: SELECT t2.child_ver_id task_id
1526: FROM (SELECT parent_ver_id, MAX (display_sequence) max_ds

Line 1527: FROM PA_PROJ_ELEM_RELATIONSHIP_T

1523: CURSOR GET_PREV_PEER_TASK_CSR1(c_parent_structure_ver_id NUMBER, c_parent_task_id NUMBER, c_display_seq NUMBER)
1524: IS
1525: SELECT t2.child_ver_id task_id
1526: FROM (SELECT parent_ver_id, MAX (display_sequence) max_ds
1527: FROM PA_PROJ_ELEM_RELATIONSHIP_T
1528: where parent_ver_id = c_parent_task_id
1529: and display_sequence < c_display_seq
1530: GROUP BY parent_ver_id) t1,
1531: PA_PROJ_ELEM_RELATIONSHIP_T t2

Line 1531: PA_PROJ_ELEM_RELATIONSHIP_T t2

1527: FROM PA_PROJ_ELEM_RELATIONSHIP_T
1528: where parent_ver_id = c_parent_task_id
1529: and display_sequence < c_display_seq
1530: GROUP BY parent_ver_id) t1,
1531: PA_PROJ_ELEM_RELATIONSHIP_T t2
1532: WHERE t1.parent_ver_id = t2.parent_ver_id AND t1.max_ds = t2.display_sequence;
1533:
1534: CURSOR GET_PREV_TOP_PEER_TASK_CSR(c_parent_structure_ver_id NUMBER, c_display_seq NUMBER)
1535: IS