APPS.PQH_PTX_UTL dependencies on PQH_BUDGET_VERSIONS

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 3687: pqh_budget_versions_api.update_budget_version

3683: close c_total_bdt;
3684: --
3685: if r_bvr.budget_style_cd = 'BOTTOM' then
3686: --
3687: pqh_budget_versions_api.update_budget_version
3688: (
3689: p_validate => false
3690: ,p_budget_version_id => r_bvr.budget_version_id
3691: ,p_object_version_number => r_bvr.object_version_number

Line 3718: pqh_budget_versions_api.update_budget_version

3714: else
3715: l_budget_unit3_available := null;
3716: end if;
3717: --
3718: pqh_budget_versions_api.update_budget_version
3719: (
3720: p_validate => false
3721: ,p_budget_version_id => r_bvr.budget_version_id
3722: ,p_object_version_number => r_bvr.object_version_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