APPS.HR_BIS_ORG_PERF dependencies on PER_SHARED_TYPES

Line 769: , per_shared_types pst1

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
771: where bud.budget_id = cp_budget_id
772: and bud.budget_id = bver.budget_id
773: and sysdate between bver.date_from and nvl(bver.date_to, sysdate +1)

Line 789: , per_shared_types pst1

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
791: where bud.budget_id = cp_budget_id
792: and bud.budget_id = bver.budget_id
793: and sysdate between bver.date_from and nvl(bver.date_to, sysdate +1)

Line 812: , per_shared_types pst1

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
814: , per_shared_types pst3
815: , per_time_periods ptp
816: where bud.budget_id = cp_budget_id

Line 813: , per_shared_types pst2

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
814: , per_shared_types pst3
815: , per_time_periods ptp
816: where bud.budget_id = cp_budget_id
817: and bud.budget_unit1_id = pst1.shared_type_id

Line 814: , per_shared_types pst3

810: , pqh_budget_details bdet
811: , pqh_budget_periods bper
812: , per_shared_types pst1
813: , per_shared_types pst2
814: , per_shared_types pst3
815: , per_time_periods ptp
816: where bud.budget_id = cp_budget_id
817: and bud.budget_unit1_id = pst1.shared_type_id
818: and bud.budget_unit2_id = pst2.shared_type_id (+)