DBA Data[Home] [Help]

APPS.GHR_UPD_HR_VALIDATION dependencies on HR_ALL_POSITIONS_F

Line 791: from HR_ALL_POSITIONS_F apf, PER_SHARED_TYPES pst

787: IS
788:
789: CURSOR c_posn IS
790: select pst.shared_type_name, apf.effective_start_date
791: from HR_ALL_POSITIONS_F apf, PER_SHARED_TYPES pst
792: where apf.position_id = p_position_id
793: and apf.availability_status_id <> 1
794: and apf.effective_end_date >= p_effective_date
795: and pst.lookup_type = 'POSITION_AVAILABILITY_STATUS'