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 424: FROM PA_LOOKUPS

420:
421: CURSOR l_get_change_reason_csr(l_budget_change_reason_code VARCHAR2)
422: IS
423: SELECT MEANING
424: FROM PA_LOOKUPS
425: WHERE LOOKUP_CODE = l_budget_change_reason_code
426: AND LOOKUP_TYPE = 'BUDGET CHANGE REASON'; -- Bug #14623649
427:
428:

Line 445: l_budget_change_reason_meaning pa_lookups.meaning%TYPE;

441:
442: l_pm_budget_reference pa_budget_versions.pm_budget_reference%TYPE;
443: l_budget_description pa_budget_versions.description%TYPE;
444: l_budget_change_reason_code pa_budget_versions.change_reason_code%TYPE;
445: l_budget_change_reason_meaning pa_lookups.meaning%TYPE;
446: l_budget_entry_method_code pa_budget_versions.budget_entry_method_code%TYPE;
447: l_budget_entry_method pa_budget_entry_methods.budget_entry_method%TYPE;
448: l_pm_budget_product_code pa_budget_versions.pm_product_code%TYPE;
449: l_mark_as_original pa_budget_versions.original_flag%TYPE;

Line 456: l_fin_plan_level pa_lookups.meaning%TYPE;

452:
453: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
454: l_version_type pa_budget_versions.version_type%TYPE;
455: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
456: l_fin_plan_level pa_lookups.meaning%TYPE;
457: l_fin_plan_time_phase pa_lookups.meaning%TYPE;
458:
459:
460: l_total_labor_hours NUMBER;

Line 457: l_fin_plan_time_phase pa_lookups.meaning%TYPE;

453: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
454: l_version_type pa_budget_versions.version_type%TYPE;
455: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
456: l_fin_plan_level pa_lookups.meaning%TYPE;
457: l_fin_plan_time_phase pa_lookups.meaning%TYPE;
458:
459:
460: l_total_labor_hours NUMBER;
461: l_total_raw_cost NUMBER;