DBA Data[Home] [Help]

APPS.HR_BIS_ORG_PERF dependencies on PER_BUDGET_VERSIONS

Line 587: , per_budget_versions bver

583: and asg.organization_id in (
584: select be.organization_id
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

Line 605: , per_budget_versions bver

601: is
602: select distinct be.organization_id
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

Line 626: , per_budget_versions bver

622: select sum(bval.value) budget_value
623: , be.organization_id
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