APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_LOOKUPS

Line 2502: l_version_type pa_lookups.meaning%TYPE;

2498: l_msg_index_out number;
2499: l_exists varchar2(1) := 'N';
2500: l_project_name pa_projects_all.name%TYPE;
2501: l_plan_name pa_fin_plan_types_tl.name%TYPE;
2502: l_version_type pa_lookups.meaning%TYPE;
2503: l_stage number;
2504: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
2505: l_msg_name fnd_new_messages.message_name%TYPE;
2506: --Bug 5845142. Exclude COST impacts with cost and revenue together setup.

Line 2561: from pa_lookups

2557: l_stage := 300;
2558:
2559: select meaning
2560: into l_version_type
2561: from pa_lookups
2562: where lookup_type = 'FIN_PLAN_VER_TYPE'
2563: and lookup_code = p_version_type;
2564:
2565: l_stage := 400;

Line 4498: FROM PA_LOOKUPS

4494: l_pref_code_for_pt_of_ver pa_proj_fp_options.fin_plan_preference_code%TYPE; /* Bug 4038253 */
4495:
4496: CURSOR c_lookup_summary IS
4497: SELECT MEANING,to_number(LOOKUP_CODE)
4498: FROM PA_LOOKUPS
4499: WHERE LOOKUP_TYPE = 'PA_FP_CI_PLAN_SUMMARY'
4500: ORDER BY to_number(LOOKUP_CODE);
4501:
4502: CURSOR c_lookup_reference IS

Line 4504: FROM PA_LOOKUPS

4500: ORDER BY to_number(LOOKUP_CODE);
4501:
4502: CURSOR c_lookup_reference IS
4503: SELECT MEANING
4504: FROM PA_LOOKUPS
4505: WHERE LOOKUP_TYPE = 'PA_FP_CI_PLAN_REFERENCE'
4506: ORDER BY to_number(LOOKUP_CODE);
4507:
4508: CURSOR c_get_approved_details

Line 5430: pa_lookups as follows:

5426: 100 Submitted Change Documents
5427: 110 Projected Total
5428:
5429: Disclaimer: Please note that the actual and latest mapping of the above can be got from
5430: pa_lookups as follows:
5431: select lookup_code, meaning
5432: from pa_lookupus
5433: where lookup_type = 'PA_FP_CI_PLAN_SUMMARY'
5434: order by to_number(lookup_code);

Line 7083: FROM PA_LOOKUPS

7079:
7080:
7081: CURSOR c_lookup_summary IS
7082: SELECT MEANING,to_number(LOOKUP_CODE)
7083: FROM PA_LOOKUPS
7084: WHERE LOOKUP_TYPE = 'PA_FP_CI_NOT_INCLUDED'
7085: ORDER BY to_number(LOOKUP_CODE);
7086:
7087: -- In the cursor c_change_documents_status, all the select column sums have been wrapped up

Line 7310: can be got from pa_lookups as follows:

7306: 40 Rejected Change Documents
7307: 50 Total Change Documents
7308:
7309: Disclaimer: Please note that the actual and latest mapping of the above
7310: can be got from pa_lookups as follows:
7311: select lookup_code, meaning
7312: from pa_lookupus
7313: where lookup_type = 'PA_FP_CI_NOT_INCLUDED'
7314: order by to_number(lookup_code);