DBA Data[Home] [Help]

APPS.HR_BIS_ORG_PERF dependencies on PER_BUDGET_VALUES

Line 585: from per_budget_values bval

581: and ast.assignment_status_type_id = asg.assignment_status_type_id
582: and ast.per_system_status = 'ACTIVE_ASSIGN'
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

Line 603: from per_budget_values bval

599: ( cp_budget_id NUMBER
600: , cp_report_date DATE )
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

Line 624: from per_budget_values bval

620: , cp_report_date DATE )
621: is
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