DBA Data[Home] [Help]

APPS.GHR_WF_PKG dependencies on HR_ALL_POSITIONS_F

Line 792: hr_all_positions_f hpf

788: --
789: cursor csr_from_org_details is
790: SELECT hru.name
791: FROM hr_organization_units hru,
792: hr_all_positions_f hpf
793: WHERE hpf.position_id = nvl(l_from_position_id,-9999)
794: and nvl(l_effective_date,sysdate)
795: between hpf.effective_start_date
796: and hpf.effective_end_date