APPS.GHR_SF52_POS_UPDATE dependencies on PER_SHARED_TYPES

Line 401: SELECT shared_type_id,shared_type_name from per_shared_types

397: AND nvl(c_effective_date,sysdate)
398: between effective_start_date and effective_end_Date;
399:
400: Cursor c_position_status is
401: SELECT shared_type_id,shared_type_name from per_shared_types
402: WHERE system_type_cd = 'ELIMINATED';
403:
404: l_object_version_number number;
405: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE;