APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on PA_LOOKUPS

Line 3464: --select prefix from pa_lookups

3460: -- If same, add Time-Stamp to working version.
3461: -- error_msg('dummyname before '||l_dummy_name);
3462: -- l_dummy_name := substr(fnd_date.date_to_canonical(sysdate)||' - '||
3463: -- l_dummy_name,0,240);
3464: --select prefix from pa_lookups
3465: select meaning
3466: into l_prefix
3467: from pa_lookups
3468: where lookup_type = 'PA_STRUCTURES_PREFIX'

Line 3467: from pa_lookups

3463: -- l_dummy_name,0,240);
3464: --select prefix from pa_lookups
3465: select meaning
3466: into l_prefix
3467: from pa_lookups
3468: where lookup_type = 'PA_STRUCTURES_PREFIX'
3469: and lookup_code = 'PA_PREFIX_COPY';
3470:
3471: l_dummy_name := substrb(l_prefix||' '||l_dummy_name,0,240);

Line 7441: from pa_lookups

7437: where project_id = p_dest_project_id;
7438:
7439: select meaning
7440: into l_suffix
7441: from pa_lookups
7442: where lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
7443: and lookup_code = 'WORKPLAN';
7444:
7445: --Hsiu start modification

Line 9728: from pa_lookups

9724:
9725: --get suffix
9726: select meaning
9727: into l_suffix
9728: from pa_lookups
9729: where lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
9730: and lookup_code = 'WORKPLAN';
9731:
9732: l_name := substrb(l_name||l_append||l_suffix, 1, 240);

Line 10731: from pa_lookups

10727:
10728: --get suffix
10729: select meaning
10730: into l_suffix
10731: from pa_lookups
10732: where lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
10733: and lookup_code = 'WORKPLAN';
10734:
10735: l_name := substrb(l_name||l_append||l_suffix, 1, 240);

Line 12301: from pa_lookups

12297: l_proj_info_rec get_project_info%ROWTYPE;
12298:
12299: CURSOR get_lookup_meaning(c_lookup_code VARCHAR2) IS
12300: select meaning
12301: from pa_lookups
12302: where lookup_type = 'PA_WORKPLAN_ERROR_NOTIF'
12303: and lookup_code = c_lookup_code;
12304: l_workplan_version_err varchar2(80);
12305: l_err_instruction varchar2(80);

Line 14261: from pa_lookups

14257:
14258: --get suffix
14259: select meaning
14260: into l_suffix
14261: from pa_lookups
14262: where lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
14263: and lookup_code = 'WORKPLAN';
14264: --get workplan name
14265: l_wp_name := substrb(l_name||l_append||l_suffix, 1, 240);

Line 17620: from pa_lookups

17616: --enable deliverable
17617: --get suffix
17618: select meaning
17619: into l_suffix
17620: from pa_lookups
17621: where lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
17622: and lookup_code = 'DELIVERABLE';
17623: --get deliverable name
17624: l_del_name := substrb(l_name||l_append||l_suffix, 1, 240);