APPS.PA_RELATIONSHIP_PUB dependencies on DUAL

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

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

Line 1877: select 'UP' INVERT_ID from dual

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

Line 2213: from DUAL;

2209: if (l_parent_group is null and l_child_group is null) then
2210:
2211: select PA_PROJ_ELEMENT_VERSIONS_S1.NEXTVAL
2212: into l_parent_group
2213: from DUAL;
2214:
2215: update PA_PROJ_ELEMENT_VERSIONS
2216: set PRG_GROUP = l_parent_group,
2217: PRG_LEVEL = l_parent_level,

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

2363: from
2364: PA_PROJ_ELEMENT_VERSIONS ver,
2365: PA_OBJECT_RELATIONSHIPS rel,
2366: (
2367: select 'DOWN' INVERT_ID from dual union all
2368: select 'UP' INVERT_ID from dual
2369: ) invert
2370: where
2371: ver.OBJECT_TYPE = 'PA_TASKS' and

Line 2368: select 'UP' INVERT_ID from dual

2364: PA_PROJ_ELEMENT_VERSIONS ver,
2365: PA_OBJECT_RELATIONSHIPS rel,
2366: (
2367: select 'DOWN' INVERT_ID from dual union all
2368: select 'UP' INVERT_ID from dual
2369: ) invert
2370: where
2371: ver.OBJECT_TYPE = 'PA_TASKS' and
2372: ver.PRG_GROUP = l_parent_group and

Line 2678: from DUAL;

2674: -- group will be divided into two sub-groups.
2675:
2676: select PA_PROJ_ELEMENT_VERSIONS_S1.NEXTVAL
2677: into l_child_group
2678: from DUAL;
2679:
2680: -- stamp the newly created program group
2681:
2682: update PA_PROJ_ELEMENT_VERSIONS ver