eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_LOOKUPS

Line 2468: l_version_type pa_lookups.meaning%TYPE;

2464: l_msg_index_out number;
2465: l_exists varchar2(1) := 'N';
2466: l_project_name pa_projects_all.name%TYPE;
2467: l_plan_name pa_fin_plan_types_tl.name%TYPE;
2468: l_version_type pa_lookups.meaning%TYPE;
2469: l_stage number;
2470: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
2471: l_msg_name fnd_new_messages.message_name%TYPE;
2472: cursor c1 is

Line 2512: from pa_lookups

2508: l_stage := 300;
2509:
2510: select meaning
2511: into l_version_type
2512: from pa_lookups
2513: where lookup_type = 'FIN_PLAN_VER_TYPE'
2514: and lookup_code = p_version_type;
2515:
2516: l_stage := 400;

Line 4449: FROM PA_LOOKUPS

4445: l_pref_code_for_pt_of_ver pa_proj_fp_options.fin_plan_preference_code%TYPE; /* Bug 4038253 */
4446:
4447: CURSOR c_lookup_summary IS
4448: SELECT MEANING,to_number(LOOKUP_CODE)
4449: FROM PA_LOOKUPS
4450: WHERE LOOKUP_TYPE = 'PA_FP_CI_PLAN_SUMMARY'
4451: ORDER BY to_number(LOOKUP_CODE);
4452:
4453: CURSOR c_lookup_reference IS

Line 4455: FROM PA_LOOKUPS

4451: ORDER BY to_number(LOOKUP_CODE);
4452:
4453: CURSOR c_lookup_reference IS
4454: SELECT MEANING
4455: FROM PA_LOOKUPS
4456: WHERE LOOKUP_TYPE = 'PA_FP_CI_PLAN_REFERENCE'
4457: ORDER BY to_number(LOOKUP_CODE);
4458:
4459: CURSOR c_get_approved_details

Line 5374: pa_lookups as follows:

5370: 100 Submitted Change Documents
5371: 110 Projected Total
5372:
5373: Disclaimer: Please note that the actual and latest mapping of the above can be got from
5374: pa_lookups as follows:
5375: select lookup_code, meaning
5376: from pa_lookupus
5377: where lookup_type = 'PA_FP_CI_PLAN_SUMMARY'
5378: order by to_number(lookup_code);

Line 7011: FROM PA_LOOKUPS

7007:
7008:
7009: CURSOR c_lookup_summary IS
7010: SELECT MEANING,to_number(LOOKUP_CODE)
7011: FROM PA_LOOKUPS
7012: WHERE LOOKUP_TYPE = 'PA_FP_CI_NOT_INCLUDED'
7013: ORDER BY to_number(LOOKUP_CODE);
7014:
7015: -- In the cursor c_change_documents_status, all the select column sums have been wrapped up

Line 7238: can be got from pa_lookups as follows:

7234: 40 Rejected Change Documents
7235: 50 Total Change Documents
7236:
7237: Disclaimer: Please note that the actual and latest mapping of the above
7238: can be got from pa_lookups as follows:
7239: select lookup_code, meaning
7240: from pa_lookupus
7241: where lookup_type = 'PA_FP_CI_NOT_INCLUDED'
7242: order by to_number(lookup_code);