APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PA_LOOKUPS

Line 303: from pa_lookups

299: l_append := ': ';
300:
301: select meaning
302: into l_suffix
303: from pa_lookups
304: where lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
305: and lookup_code = 'WORKPLAN';
306:
307: l_name := substr(p_dest_project_name||l_append||l_suffix, 1, 240);

Line 4303: from pa_lookups

4299: l_append := ': ';
4300:
4301: select meaning
4302: into l_suffix
4303: from pa_lookups
4304: where lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
4305: and lookup_code = 'WORKPLAN';
4306:
4307: l_name := substr(l_name||l_append||l_suffix, 1, 240);

Line 5007: from pa_lookups

5003: CLOSE c1;
5004:
5005: select meaning
5006: into l_suffix
5007: from pa_lookups
5008: where lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
5009: and lookup_code = 'WORKPLAN';
5010:
5011: l_name := substr(l_name||l_append||l_suffix,1,240);

Line 8484: FROM pa_lookups

8480: --Inner query is necessary rather than a straight join of three tables in the outer query bec in case of shared,
8481: --the same record from source project is returned twice.
8482:
8483: SELECT meaning INTO l_suffix
8484: FROM pa_lookups
8485: WHERE lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
8486: AND lookup_code = 'WORKPLAN';
8487:
8488: --If Split and Workplan enabled

Line 9134: FROM pa_lookups

9130: SELECT pa_proj_element_versions_s.nextval INTO l_new_wp_ver_id
9131: FROM dual;
9132:
9133: SELECT meaning INTO l_prefix
9134: FROM pa_lookups
9135: WHERE lookup_type = 'PA_STRUCTURES_PREFIX'
9136: AND lookup_code = 'PA_PREFIX_COPY';
9137:
9138: IF l_debug_mode = 'Y' THEN

Line 11159: from pa_lookups

11155: l_project_name := p_dest_project_name; --bug 2805602
11156:
11157: select meaning
11158: into l_suffix
11159: from pa_lookups
11160: where lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
11161: and lookup_code = 'WORKPLAN';
11162:
11163: -- Bug 3717026 Begin, commented as the structure name should be same as the project name.