VIEW: APPS.HRI_OBI_CL_SPRN_SPRTNRSN_V

Source

View Text - Preformatted

SELECT hrl.lookup_type || '-' || hrl.lookup_code SPRN_SPRTNRSN_PK, hrl.meaning SPRN_SPRTNRSN_NAME, hrl.meaning SPRN_ORDER_BY, hrl.enabled_flag SPRN_ENABLED_FLAG, hrl.start_date_active sprn_valid_from, hrl.end_date_active sprn_valid_to FROM hr_standard_lookups hrl WHERE hrl.lookup_type IN ('LEAV_REAS', 'HR_CWK_TERMINATION_REASONS') UNION ALL SELECT id_char SPRN_SPRTNRSN_PK, hri_oltp_view_message.get_unassigned_msg SPRN_SPRTNRSN_NAME, null SPRN_ORDER_BY, 'Y' SPRN_ENABLED_FLAG, hr_general.start_of_time, hr_general.end_of_time FROM hri_unassigned WITH READ ONLY

View Text - HTML Formatted

SELECT HRL.LOOKUP_TYPE || '-' || HRL.LOOKUP_CODE SPRN_SPRTNRSN_PK
, HRL.MEANING SPRN_SPRTNRSN_NAME
, HRL.MEANING SPRN_ORDER_BY
, HRL.ENABLED_FLAG SPRN_ENABLED_FLAG
, HRL.START_DATE_ACTIVE SPRN_VALID_FROM
, HRL.END_DATE_ACTIVE SPRN_VALID_TO
FROM HR_STANDARD_LOOKUPS HRL
WHERE HRL.LOOKUP_TYPE IN ('LEAV_REAS'
, 'HR_CWK_TERMINATION_REASONS') UNION ALL SELECT ID_CHAR SPRN_SPRTNRSN_PK
, HRI_OLTP_VIEW_MESSAGE.GET_UNASSIGNED_MSG SPRN_SPRTNRSN_NAME
, NULL SPRN_ORDER_BY
, 'Y' SPRN_ENABLED_FLAG
, HR_GENERAL.START_OF_TIME
, HR_GENERAL.END_OF_TIME
FROM HRI_UNASSIGNED WITH READ ONLY