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.

APPS.PA_RELATIONSHIP_PUB dependencies on DUAL

Line 1880: select 'DOWN' INVERT_ID from dual union all

1876: pa_proj_structure_types ppst,
1877: pa_proj_elem_ver_structure ppevs,
1878: pa_projects_all ppa,
1879: (
1880: select 'DOWN' INVERT_ID from dual union all
1881: select 'UP' INVERT_ID from dual
1882: ) invert
1883: where
1884: ver.OBJECT_TYPE = 'PA_TASKS' and

Line 1881: select 'UP' INVERT_ID from dual

1877: pa_proj_elem_ver_structure ppevs,
1878: pa_projects_all ppa,
1879: (
1880: select 'DOWN' INVERT_ID from dual union all
1881: select 'UP' INVERT_ID from dual
1882: ) invert
1883: where
1884: ver.OBJECT_TYPE = 'PA_TASKS' and
1885: ver.PRG_GROUP = l_parent_group and

Line 2217: from DUAL;

2213: if (l_parent_group is null and l_child_group is null) then
2214:
2215: select PA_PROJ_ELEMENT_VERSIONS_S1.NEXTVAL
2216: into l_parent_group
2217: from DUAL;
2218:
2219: update PA_PROJ_ELEMENT_VERSIONS
2220: set PRG_GROUP = l_parent_group,
2221: PRG_LEVEL = l_parent_level,

Line 2371: select 'DOWN' INVERT_ID from dual union all

2367: from
2368: PA_PROJ_ELEMENT_VERSIONS ver,
2369: PA_OBJECT_RELATIONSHIPS rel,
2370: (
2371: select 'DOWN' INVERT_ID from dual union all
2372: select 'UP' INVERT_ID from dual
2373: ) invert
2374: where
2375: ver.OBJECT_TYPE = 'PA_TASKS' and

Line 2372: select 'UP' INVERT_ID from dual

2368: PA_PROJ_ELEMENT_VERSIONS ver,
2369: PA_OBJECT_RELATIONSHIPS rel,
2370: (
2371: select 'DOWN' INVERT_ID from dual union all
2372: select 'UP' INVERT_ID from dual
2373: ) invert
2374: where
2375: ver.OBJECT_TYPE = 'PA_TASKS' and
2376: ver.PRG_GROUP = l_parent_group and

Line 2736: from DUAL;

2732: -- group will be divided into two sub-groups.
2733:
2734: select PA_PROJ_ELEMENT_VERSIONS_S1.NEXTVAL
2735: into l_child_group
2736: from DUAL;
2737:
2738: -- stamp the newly created program group
2739: -- Bug 6778370
2740: begin

Line 2742: from dual

2738: -- stamp the newly created program group
2739: -- Bug 6778370
2740: begin
2741: select 'Y' into l_subgrp_exist
2742: from dual
2743: where exists ( select 1 from PA_PROJ_LEVELS_TMP tmp
2744: where
2745: ATTRIBUTE1 = 'DROPPED_ASSOCIATION_DOWN' or
2746: tmp.ATTRIBUTE3 = 'CHILD_SUBGROUP');