APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PA_LOOKUPS

Line 87: from pa_lookups

83: l_append := ': ';
84:
85: select meaning
86: into l_suffix
87: from pa_lookups
88: where lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
89: and lookup_code = 'WORKPLAN';
90:
91: l_name := substr(p_dest_project_name||l_append||l_suffix, 1, 240);

Line 4082: from pa_lookups

4078: l_append := ': ';
4079:
4080: select meaning
4081: into l_suffix
4082: from pa_lookups
4083: where lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
4084: and lookup_code = 'WORKPLAN';
4085:
4086: l_name := substr(l_name||l_append||l_suffix, 1, 240);

Line 4786: from pa_lookups

4782: CLOSE c1;
4783:
4784: select meaning
4785: into l_suffix
4786: from pa_lookups
4787: where lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
4788: and lookup_code = 'WORKPLAN';
4789:
4790: l_name := substr(l_name||l_append||l_suffix,1,240);

Line 8223: FROM pa_lookups

8219: --Inner query is necessary rather than a straight join of three tables in the outer query bec in case of shared,
8220: --the same record from source project is returned twice.
8221:
8222: SELECT meaning INTO l_suffix
8223: FROM pa_lookups
8224: WHERE lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
8225: AND lookup_code = 'WORKPLAN';
8226:
8227: --If Split and Workplan enabled

Line 8842: FROM pa_lookups

8838: SELECT pa_proj_element_versions_s.nextval INTO l_new_wp_ver_id
8839: FROM dual;
8840:
8841: SELECT meaning INTO l_prefix
8842: FROM pa_lookups
8843: WHERE lookup_type = 'PA_STRUCTURES_PREFIX'
8844: AND lookup_code = 'PA_PREFIX_COPY';
8845:
8846: IF l_debug_mode = 'Y' THEN

Line 10844: from pa_lookups

10840: l_project_name := p_dest_project_name; --bug 2805602
10841:
10842: select meaning
10843: into l_suffix
10844: from pa_lookups
10845: where lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
10846: and lookup_code = 'WORKPLAN';
10847:
10848: -- Bug 3717026 Begin, commented as the structure name should be same as the project name.