APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on PA_LOOKUPS

Line 3524: --select prefix from pa_lookups

3520: -- If same, add Time-Stamp to working version.
3521: -- error_msg('dummyname before '||l_dummy_name);
3522: -- l_dummy_name := substr(fnd_date.date_to_canonical(sysdate)||' - '||
3523: -- l_dummy_name,0,240);
3524: --select prefix from pa_lookups
3525: select meaning
3526: into l_prefix
3527: from pa_lookups
3528: where lookup_type = 'PA_STRUCTURES_PREFIX'

Line 3527: from pa_lookups

3523: -- l_dummy_name,0,240);
3524: --select prefix from pa_lookups
3525: select meaning
3526: into l_prefix
3527: from pa_lookups
3528: where lookup_type = 'PA_STRUCTURES_PREFIX'
3529: and lookup_code = 'PA_PREFIX_COPY';
3530:
3531: l_dummy_name := substrb(l_prefix||' '||l_dummy_name,0,240);

Line 7501: from pa_lookups

7497: where project_id = p_dest_project_id;
7498:
7499: select meaning
7500: into l_suffix
7501: from pa_lookups
7502: where lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
7503: and lookup_code = 'WORKPLAN';
7504:
7505: --Hsiu start modification

Line 10100: from pa_lookups

10096:
10097: --get suffix
10098: select meaning
10099: into l_suffix
10100: from pa_lookups
10101: where lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
10102: and lookup_code = 'WORKPLAN';
10103:
10104: l_name := substrb(l_name||l_append||l_suffix, 1, 240);

Line 11103: from pa_lookups

11099:
11100: --get suffix
11101: select meaning
11102: into l_suffix
11103: from pa_lookups
11104: where lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
11105: and lookup_code = 'WORKPLAN';
11106:
11107: l_name := substrb(l_name||l_append||l_suffix, 1, 240);

Line 12673: from pa_lookups

12669: l_proj_info_rec get_project_info%ROWTYPE;
12670:
12671: CURSOR get_lookup_meaning(c_lookup_code VARCHAR2) IS
12672: select meaning
12673: from pa_lookups
12674: where lookup_type = 'PA_WORKPLAN_ERROR_NOTIF'
12675: and lookup_code = c_lookup_code;
12676: l_workplan_version_err varchar2(80);
12677: l_err_instruction varchar2(80);

Line 14637: from pa_lookups

14633:
14634: --get suffix
14635: select meaning
14636: into l_suffix
14637: from pa_lookups
14638: where lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
14639: and lookup_code = 'WORKPLAN';
14640: --get workplan name
14641: l_wp_name := substrb(l_name||l_append||l_suffix, 1, 240);

Line 17996: from pa_lookups

17992: --enable deliverable
17993: --get suffix
17994: select meaning
17995: into l_suffix
17996: from pa_lookups
17997: where lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
17998: and lookup_code = 'DELIVERABLE';
17999: --get deliverable name
18000: l_del_name := substrb(l_name||l_append||l_suffix, 1, 240);