DBA Data[Home] [Help]

APPS.HR_BIS_ORG_PERF dependencies on PER_BUDGETS

Line 589: , per_budgets_v bud

585: from per_budget_values bval
586: , per_budget_elements be
587: , per_budget_versions bver
588: , per_time_periods tp
589: , per_budgets_v bud
590: where bud.budget_id = cp_budget_id
591: and bud.budget_id = bver.budget_id
592: and sysdate between bver.date_from and nvl(bver.date_to, sysdate+1)
593: and be.budget_version_id = bver.budget_version_id

Line 607: , per_budgets_v bud

603: from per_budget_values bval
604: , per_budget_elements be
605: , per_budget_versions bver
606: , per_time_periods tp
607: , per_budgets_v bud
608: where bud.budget_id = cp_budget_id
609: and bud.budget_id = bver.budget_id
610: and sysdate between bver.date_from and nvl(bver.date_to, sysdate+1)
611: and be.budget_version_id = bver.budget_version_id

Line 628: , per_budgets_v bud

624: from per_budget_values bval
625: , per_budget_elements be
626: , per_budget_versions bver
627: , per_time_periods tp
628: , per_budgets_v bud
629: where bud.budget_id = cp_budget_id
630: and bud.budget_id = bver.budget_id
631: and sysdate between bver.date_from and nvl(bver.date_to, sysdate+1)
632: and be.budget_version_id = bver.budget_version_id

Line 675: from per_budgets

671: end loop;
672:
673: select unit
674: into l_budget_metric
675: from per_budgets
676: where budget_id = p_budget_id;
677:
678: -- Look for the budget formula
679: open c_get_bgt_formula (p_business_group_id, l_budget_metric);