APPS.PA_FIN_PLAN_VIEW_GLOBAL dependencies on PA_BUDGET_VERSIONS

Line 17: from pa_budget_versions

13:
14: BEGIN
15: select budget_status_code
16: into x_budget_status_code
17: from pa_budget_versions
18: where budget_version_id = p_budget_version_id;
19:
20:
21: END pa_fp_get_budget_status_code;

Line 50: from pa_budget_versions

46: pa_fin_plan_view_global.G_FP_VIEW_VERSION_ID := p_orgfcst_version_id;
47:
48: select project_id
49: into l_project_id
50: from pa_budget_versions
51: where budget_version_id = p_orgfcst_version_id;
52:
53: select nvl(org_id,-99)
54: into l_org_id

Line 69: pa_budget_versions pbv

65:
66: select pp.plan_period_type
67: into ll_plan_period_type
68: from pa_proj_period_profiles pp,
69: pa_budget_versions pbv
70: where pbv.budget_version_id = p_orgfcst_version_id
71: and pp.period_profile_id = pbv.period_profile_id;
72:
73: pa_fin_plan_view_global.G_FP_PLAN_START_DATE := ll_plan_start_date;

Line 819: pa_budget_versions pbv

815:
816: select pp.number_of_periods
817: into l_number_of_periods
818: from pa_proj_period_profiles pp,
819: pa_budget_versions pbv
820: where pbv.budget_version_id = l_budget_version_id
821: and pp.period_profile_id = pbv.period_profile_id;
822:
823:

Line 7653: /*Begin of update pa_budget_versions*/

7649:
7650:
7651:
7652: /****************************************************************************************/
7653: /*Begin of update pa_budget_versions*/
7654: /***************************************************************************************/
7655:
7656:
7657:

Line 7709: /*End of update pa_budget_versions*/

7705:
7706:
7707:
7708: /****************************************************************************************/
7709: /*End of update pa_budget_versions*/
7710: /***************************************************************************************/
7711:
7712:
7713:

Line 7747: from pa_budget_versions

7743:
7744:
7745: select period_profile_id
7746: into l_period_profile_id
7747: from pa_budget_versions
7748: where budget_version_id = l_budget_version_id;
7749:
7750: select amount_type_id
7751: into l_amount_type_id