[Home] [Help]
View: HRILV_GRD_BGS_X
Product: | HRI - Human Resources Intelligence (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ GRD.GRADE_ID ID
, GRD.NAME VALUE
, GRD.DATE_FROM DATE_FROM
, NVL(GRD.DATE_TO
, HR_GENERAL.END_OF_TIME) DATE_TO /*PARENT IDS*/
, GRD.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM PER_GRADES GRD
WHERE /*RESTRICTION*/ TRUNC(SYSDATE) BETWEEN GRD.DATE_FROM
AND NVL(GRD.DATE_TO
, HR_GENERAL.END_OF_TIME) /*SECURITY*/
AND GRD.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, GRD.BUSINESS_GROUP_ID) WITH READ ONLY
Columns
Name |
ID |
VALUE |
DATE_FROM |
DATE_TO |
BUSINESS_GROUP_ID |