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_CLIENT_EXTN_BUDGET_WF dependencies on PA_LOOKUPS

Line 403: , pa_lookups l1

399: IS
400: SELECT l1.meaning
401: , l2.meaning
402: FROM pa_proj_fp_options fo
403: , pa_lookups l1
404: , pa_lookups l2
405: WHERE fo.fin_plan_version_id = p_draft_version_id
406: AND l1.lookup_code = decode(l_version_type, 'COST', fo.cost_fin_plan_level_code
407: ,'REVENUE', fo.revenue_fin_plan_level_code

Line 404: , pa_lookups l2

400: SELECT l1.meaning
401: , l2.meaning
402: FROM pa_proj_fp_options fo
403: , pa_lookups l1
404: , pa_lookups l2
405: WHERE fo.fin_plan_version_id = p_draft_version_id
406: AND l1.lookup_code = decode(l_version_type, 'COST', fo.cost_fin_plan_level_code
407: ,'REVENUE', fo.revenue_fin_plan_level_code
408: ,'ALL', fo.all_fin_plan_level_code, NULL)

Line 449: l_fin_plan_level pa_lookups.meaning%TYPE;

445:
446: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
447: l_version_type pa_budget_versions.version_type%TYPE;
448: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
449: l_fin_plan_level pa_lookups.meaning%TYPE;
450: l_fin_plan_time_phase pa_lookups.meaning%TYPE;
451:
452:
453: l_total_labor_hours NUMBER;

Line 450: l_fin_plan_time_phase pa_lookups.meaning%TYPE;

446: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
447: l_version_type pa_budget_versions.version_type%TYPE;
448: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
449: l_fin_plan_level pa_lookups.meaning%TYPE;
450: l_fin_plan_time_phase pa_lookups.meaning%TYPE;
451:
452:
453: l_total_labor_hours NUMBER;
454: l_total_raw_cost NUMBER;