APPS.PQH_PTX_UTL dependencies on PQH_BUDGETS

Line 3658: from pqh_budget_versions bvr, pqh_budgets bgt

3654: cursor c_bvr(p_budget_version_id number) is
3655: select bgt.budget_style_cd,
3656: budget_version_id, bvr.object_version_number,
3657: budget_unit1_value, budget_unit2_value, budget_unit3_value
3658: from pqh_budget_versions bvr, pqh_budgets bgt
3659: where budget_version_id = p_budget_version_id
3660: and bvr.budget_id = bgt.budget_id;
3661: --
3662: cursor c_total_bdt(p_budget_version_id number) is

Line 3762: from pqh_budgets

3758: select currency_code, budget_unit1_id, budget_unit2_id, budget_unit3_id,
3759: pqh_wks_budget.get_unit_type(budget_unit1_id),
3760: pqh_wks_budget.get_unit_type(budget_unit2_id),
3761: pqh_wks_budget.get_unit_type(budget_unit3_id)
3762: from pqh_budgets
3763: where budget_id = p_budget_id;
3764: --
3765: l_budget_currency_code varchar2(15);
3766: l_budget_unit1_id number;

Line 3906: FROM pqh_budget_versions bvr, pqh_budgets bgt

3902: nvl(BUDGET_UNIT2_VALUE,0) ,
3903: nvl(BUDGET_UNIT3_VALUE,0),
3904: bgt.budget_style_cd,
3905: bgt.dflt_budget_set_id
3906: FROM pqh_budget_versions bvr, pqh_budgets bgt
3907: WHERE budget_version_id = p_budget_version_id
3908: and bvr.budget_id = bgt.budget_id;
3909: --
3910: CURSOR l_object_version_number_cur(p_budget_detail_id number) IS

Line 3921: l_budget_style_cd pqh_budgets.budget_style_cd%type;

3917: FROM pqh_budget_periods
3918: WHERE budget_period_id = p_budget_period_id;
3919: --
3920: l_proc varchar2(72) := g_package||'apply_ptx_budgets';
3921: l_budget_style_cd pqh_budgets.budget_style_cd%type;
3922: l_budget_detail_id number;
3923: l_budget_period_id number;
3924: l_version_unit1_value number;
3925: l_version_unit2_value number;