DBA Data[Home] [Help]

APPS.HR_BIS_ORG_PERF dependencies on PQH_BUDGET_VERSIONS

Line 766: , pqh_budget_versions bver

762: and ast.per_system_status = 'ACTIVE_ASSIGN'
763: and asg.organization_id in (
764: select distinct bdet.organization_id
765: from pqh_budgets bud
766: , pqh_budget_versions bver
767: , pqh_budget_details bdet
768: , pqh_budget_periods bper
769: , per_shared_types pst1
770: , per_time_periods ptp

Line 786: , pqh_budget_versions bver

782: , cp_report_date DATE )
783: is
784: select distinct bdet.organization_id
785: from pqh_budgets bud
786: , pqh_budget_versions bver
787: , pqh_budget_details bdet
788: , pqh_budget_periods bper
789: , per_shared_types pst1
790: , per_time_periods ptp

Line 809: , pqh_budget_versions bver

805: , SUM(bper.budget_unit2_value) budget_value2
806: , SUM(bper.budget_unit3_value) budget_value3
807: , bdet.organization_id
808: from pqh_budgets bud
809: , pqh_budget_versions bver
810: , pqh_budget_details bdet
811: , pqh_budget_periods bper
812: , per_shared_types pst1
813: , per_shared_types pst2