DBA Data[Home] [Help]

APPS.GHR_UPD_HR_VALIDATION dependencies on HR_ALL_POSITIONS_F

Line 796: from HR_ALL_POSITIONS_F apf, PER_SHARED_TYPES pst

792: IS
793:
794: CURSOR c_posn IS
795: select pst.shared_type_name, apf.effective_start_date
796: from HR_ALL_POSITIONS_F apf, PER_SHARED_TYPES pst
797: where apf.position_id = p_position_id
798: and apf.availability_status_id <> 1
799: and apf.effective_end_date >= p_effective_date
800: and pst.lookup_type = 'POSITION_AVAILABILITY_STATUS'