[Home] [Help]
View: HRILV_JOB_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 $ */ JOB.JOB_ID ID
, JOB.NAME VALUE
, JOB.DATE_FROM DATE_FROM
, NVL(JOB.DATE_TO
, HR_GENERAL.END_OF_TIME) DATE_TO /*PARENT IDS*/
, JOB.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM PER_JOBS JOB
WHERE /*RESTRICTION*/ TRUNC(SYSDATE) BETWEEN JOB.DATE_FROM
AND NVL(JOB.DATE_TO
, HR_GENERAL.END_OF_TIME) /*SECURITY*/
AND JOB.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, JOB.BUSINESS_GROUP_ID) WITH READ ONLY
Columns
Name |
ID |
VALUE |
DATE_FROM |
DATE_TO |
BUSINESS_GROUP_ID |