eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_BIS_ORG_PERF dependencies on PER_TIME_PERIODS

Line 588: , per_time_periods tp

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
592: and sysdate between bver.date_from and nvl(bver.date_to, sysdate+1)

Line 606: , per_time_periods tp

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
610: and sysdate between bver.date_from and nvl(bver.date_to, sysdate+1)

Line 627: , per_time_periods tp

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
631: and sysdate between bver.date_from and nvl(bver.date_to, sysdate+1)

Line 770: , per_time_periods ptp

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)
774: and bver.budget_version_id = bdet.budget_version_id

Line 790: , per_time_periods ptp

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)
794: and bver.budget_version_id = bdet.budget_version_id

Line 815: , per_time_periods ptp

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 (+)
819: and bud.budget_unit3_id = pst3.shared_type_id (+)