FND Design Data [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