DBA Data[Home] [Help]

APPS.GHR_UPD_HR_VALIDATION dependencies on PER_SHARED_TYPES

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'

Line 805: from per_shared_types

801: and pst.shared_type_id = apf.availability_status_id;
802:
803: /*
804: select shared_type_name, shared_type_id
805: from per_shared_types
806: where lookup_type = 'POSITION_AVAILABILITY_STATUS'
807: */
808:
809: BEGIN