Product: | PQH - Public Sector HR |
---|---|
Description: | View for Statutory Situation Page |
Implementation/DBA Data: | APPS.PQH_FR_STAT_SITUATIONS_V |
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
FROM PQH_FR_STAT_SITUATIONS