DBA Data[Home] [Help]

APPS.HR_BIS_ORG_PERF dependencies on PQH_BUDGETS

Line 765: from pqh_budgets bud

761: and ast.assignment_status_type_id = asg.assignment_status_type_id
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

Line 785: from pqh_budgets bud

781: ( cp_budget_id NUMBER
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

Line 808: from pqh_budgets bud

804: select SUM(bper.budget_unit1_value) budget_value1
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