eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: HR.PQH_FR_STAT_SITUATIONS#

Source

View Text - Preformatted


select STATUTORY_SITUATION_ID STATUTORY_SITUATION_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, SITUATION_NAME SITUATION_NAME, TYPE_OF_PS TYPE_OF_PS, SITUATION_TYPE SITUATION_TYPE, SUB_TYPE SUB_TYPE, SOURCE SOURCE, LOCATION LOCATION, REASON REASON, DATE_FROM DATE_FROM, DATE_TO DATE_TO, REQUEST_TYPE REQUEST_TYPE, EMPLOYEE_AGREEMENT_NEEDED EMPLOYEE_AGREEMENT_NEEDED, MANAGER_AGREEMENT_NEEDED MANAGER_AGREEMENT_NEEDED, PRINT_ARRETTE PRINT_ARRETTE, RESERVE_POSITION RESERVE_POSITION, REMUNERATION_PAID REMUNERATION_PAID, PAY_SHARE PAY_SHARE, PAY_PERIODS PAY_PERIODS, FREQUENCY FREQUENCY, FIRST_PERIOD_MAX_DURATION FIRST_PERIOD_MAX_DURATION, MIN_DURATION_PER_REQUEST MIN_DURATION_PER_REQUEST, MAX_DURATION_PER_REQUEST MAX_DURATION_PER_REQUEST, MAX_DURATION_WHOLE_CAREER MAX_DURATION_WHOLE_CAREER, RENEWABLE_ALLOWED RENEWABLE_ALLOWED, MAX_NO_OF_RENEWALS MAX_NO_OF_RENEWALS, MAX_DURATION_PER_RENEWAL MAX_DURATION_PER_RENEWAL, MAX_TOT_CONTINUOUS_DURATION MAX_TOT_CONTINUOUS_DURATION, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, DEFAULT_FLAG DEFAULT_FLAG, ALLOW_PROGRESSION_FLAG ALLOW_PROGRESSION_FLAG, EXTEND_PROBATION_PERIOD_FLAG EXTEND_PROBATION_PERIOD_FLAG, REMUNERATE_ASSIGN_STATUS_ID REMUNERATE_ASSIGN_STATUS_ID from "HR"."PQH_FR_STAT_SITUATIONS"

View Text - HTML Formatted

SELECT STATUTORY_SITUATION_ID STATUTORY_SITUATION_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, SITUATION_NAME SITUATION_NAME
, TYPE_OF_PS TYPE_OF_PS
, SITUATION_TYPE SITUATION_TYPE
, SUB_TYPE SUB_TYPE
, SOURCE SOURCE
, LOCATION LOCATION
, REASON REASON
, DATE_FROM DATE_FROM
, DATE_TO DATE_TO
, REQUEST_TYPE REQUEST_TYPE
, EMPLOYEE_AGREEMENT_NEEDED EMPLOYEE_AGREEMENT_NEEDED
, MANAGER_AGREEMENT_NEEDED MANAGER_AGREEMENT_NEEDED
, PRINT_ARRETTE PRINT_ARRETTE
, RESERVE_POSITION RESERVE_POSITION
, REMUNERATION_PAID REMUNERATION_PAID
, PAY_SHARE PAY_SHARE
, PAY_PERIODS PAY_PERIODS
, FREQUENCY FREQUENCY
, FIRST_PERIOD_MAX_DURATION FIRST_PERIOD_MAX_DURATION
, MIN_DURATION_PER_REQUEST MIN_DURATION_PER_REQUEST
, MAX_DURATION_PER_REQUEST MAX_DURATION_PER_REQUEST
, MAX_DURATION_WHOLE_CAREER MAX_DURATION_WHOLE_CAREER
, RENEWABLE_ALLOWED RENEWABLE_ALLOWED
, MAX_NO_OF_RENEWALS MAX_NO_OF_RENEWALS
, MAX_DURATION_PER_RENEWAL MAX_DURATION_PER_RENEWAL
, MAX_TOT_CONTINUOUS_DURATION MAX_TOT_CONTINUOUS_DURATION
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, DEFAULT_FLAG DEFAULT_FLAG
, ALLOW_PROGRESSION_FLAG ALLOW_PROGRESSION_FLAG
, EXTEND_PROBATION_PERIOD_FLAG EXTEND_PROBATION_PERIOD_FLAG
, REMUNERATE_ASSIGN_STATUS_ID REMUNERATE_ASSIGN_STATUS_ID
FROM "HR"."PQH_FR_STAT_SITUATIONS"