[Home] [Help]
[Dependency Information]
VIEW: APPS.HRI_CS_SEPCR_V
Object Details
Object Name: | HRI_CS_SEPCR_V |
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
View Type
A Business Intelligence System view
Creates a structure linking separation category to separation reasons.
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
SEPARATION_CATEGORY_CODE |
VARCHAR2 |
(30) |
|
|
SEPARATION_REASON_CODE |
VARCHAR2 |
(30) |
Yes |
|
START_DATE |
DATE |
|
|
|
END_DATE |
DATE |
|
|
|
CREATION_DATE |
DATE |
|
|
|
LAST_CHANGE_DATE |
DATE |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT SEPARATION_CATEGORY_CODE
, SEPARATION_REASON_CODE
, START_DATE
, END_DATE
, CREATION_DATE
, LAST_CHANGE_DATE
FROM APPS.HRI_CS_SEPCR_V;
Dependencies
[top of page]
APPS.HRI_CS_SEPCR_V references the following:
-
APPS
-
HRI_INV_SPRTN_RSNS
-
HR_GENERAL
- show dependent code
APPS.HRI_CS_SEPCR_V is referenced by following:
-
APPS
-
HRI_BPL_TERMINATION
- show dependent code
-
HRI_DBI_WMV_SEPARATION
- show dependent code
-
HRI_MB_WAC_LOSS_ENTRPRS_V
-
HRI_MB_WRK_ACTIVITY_V
-
PUBLIC
-
HRI_CS_SEPCR_V