VIEW: APPS.PQH_FR_STAT_SITUATIONS_V

Source

View Text - Preformatted

SELECT statutory_situation_id , situation_name , Type_of_PS , hr_general.decode_shared_type( to_number(Type_of_PS)) Type_of_PS_Name, situation_type , hr_general.decode_lookup('FR_PQH_STAT_SIT_TYPE', situation_type) situation_type_name, sub_type , hr_general.decode_lookup('FR_PQH_STAT_SIT_SUB_TYPE', sub_type) sub_type_name, source , hr_general.decode_lookup('FR_PQH_STAT_SIT_SOURCE', source) source_name, location , hr_general.decode_lookup('FR_PQH_STAT_SIT_PLCMENT', location) location_name, reason , hr_general.decode_lookup('FR_PQH_STAT_SIT_REASON', reason) reason_name, Date_From, Date_to, request_type , hr_general.decode_lookup('FR_PQH_STAT_SIT_RQST_TYPE', request_type) request_type_name, employee_agreement_needed , manager_agreement_needed , print_arrette , reserve_position , remuneration_paid , pay_share , pay_periods , frequency , hr_general.decode_lookup('PROC_PERIOD_TYPE', frequency) frequency_name, first_period_max_duration , min_duration_per_request , max_duration_per_request , max_duration_whole_career , Renewable_allowed , max_no_of_renewals , Max_Duration_Per_Renewal , max_tot_continuous_duration , business_group_id , pqh_fr_stat_sit_util.rules_exist(statutory_situation_id ) RulesExist , created_by , creation_date , last_update_date , last_updated_by , last_update_login , object_version_number, default_flag, allow_progression_flag, extend_probation_period_flag, remunerate_assign_status_id, HR_GENERAL.get_user_status(remunerate_assign_status_id) remunerate_assign_status_name from pqh_fr_stat_situations

View Text - HTML Formatted

SELECT STATUTORY_SITUATION_ID
, SITUATION_NAME
, TYPE_OF_PS
, HR_GENERAL.DECODE_SHARED_TYPE( TO_NUMBER(TYPE_OF_PS)) TYPE_OF_PS_NAME
, SITUATION_TYPE
, HR_GENERAL.DECODE_LOOKUP('FR_PQH_STAT_SIT_TYPE'
, SITUATION_TYPE) SITUATION_TYPE_NAME
, SUB_TYPE
, HR_GENERAL.DECODE_LOOKUP('FR_PQH_STAT_SIT_SUB_TYPE'
, SUB_TYPE) SUB_TYPE_NAME
, SOURCE
, HR_GENERAL.DECODE_LOOKUP('FR_PQH_STAT_SIT_SOURCE'
, SOURCE) SOURCE_NAME
, LOCATION
, HR_GENERAL.DECODE_LOOKUP('FR_PQH_STAT_SIT_PLCMENT'
, LOCATION) LOCATION_NAME
, REASON
, HR_GENERAL.DECODE_LOOKUP('FR_PQH_STAT_SIT_REASON'
, REASON) REASON_NAME
, DATE_FROM
, DATE_TO
, REQUEST_TYPE
, HR_GENERAL.DECODE_LOOKUP('FR_PQH_STAT_SIT_RQST_TYPE'
, REQUEST_TYPE) REQUEST_TYPE_NAME
, EMPLOYEE_AGREEMENT_NEEDED
, MANAGER_AGREEMENT_NEEDED
, PRINT_ARRETTE
, RESERVE_POSITION
, REMUNERATION_PAID
, PAY_SHARE
, PAY_PERIODS
, FREQUENCY
, HR_GENERAL.DECODE_LOOKUP('PROC_PERIOD_TYPE'
, FREQUENCY) FREQUENCY_NAME
, FIRST_PERIOD_MAX_DURATION
, MIN_DURATION_PER_REQUEST
, MAX_DURATION_PER_REQUEST
, MAX_DURATION_WHOLE_CAREER
, RENEWABLE_ALLOWED
, MAX_NO_OF_RENEWALS
, MAX_DURATION_PER_RENEWAL
, MAX_TOT_CONTINUOUS_DURATION
, BUSINESS_GROUP_ID
, PQH_FR_STAT_SIT_UTIL.RULES_EXIST(STATUTORY_SITUATION_ID ) RULESEXIST
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, DEFAULT_FLAG
, ALLOW_PROGRESSION_FLAG
, EXTEND_PROBATION_PERIOD_FLAG
, REMUNERATE_ASSIGN_STATUS_ID
, HR_GENERAL.GET_USER_STATUS(REMUNERATE_ASSIGN_STATUS_ID) REMUNERATE_ASSIGN_STATUS_NAME
FROM PQH_FR_STAT_SITUATIONS