DBA Data[Home] [Help]

APPS.GHR_WF_PKG dependencies on HR_ALL_POSITIONS_F

Line 788: hr_all_positions_f hpf

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