PER_BU_JOBS

Details

Schema: FUSION
Object owner: PER
Object type: VIEW

Columns

Name
JOB_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE JOB_CODE NAME SET_ID JOB_FAMILY_ID BUSINESS_GROUP_ID BENCHMARK_JOB_ID ACTION_OCCURRENCE_ID ACTIVE_STATUS BENCHMARK_JOB_FLAG APPROVAL_AUTHORITY MANAGER_LEVEL MED_CHECKUP_REQ REGULAR_TEMPORARY FULL_PART_TIME JOB_FUNCTION_CODE

Name

JOB_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

JOB_CODE

NAME

SET_ID

JOB_FAMILY_ID

BUSINESS_GROUP_ID

BENCHMARK_JOB_ID

ACTION_OCCURRENCE_ID

ACTIVE_STATUS

BENCHMARK_JOB_FLAG

APPROVAL_AUTHORITY

MANAGER_LEVEL

MED_CHECKUP_REQ

REGULAR_TEMPORARY

FULL_PART_TIME

JOB_FUNCTION_CODE

Query

SQL_Statement
SELECT JOBS.JOB_ID, JOBS.EFFECTIVE_START_DATE, JOBS.EFFECTIVE_END_DATE, JOBS.JOB_CODE, JOBS_TL.NAME, JOBS.SET_ID, JOBS.JOB_FAMILY_ID, JOBS.BUSINESS_GROUP_ID, JOBS.BENCHMARK_JOB_ID, JOBS.ACTION_OCCURRENCE_ID, JOBS.ACTIVE_STATUS, JOBS.BENCHMARK_JOB_FLAG, JOBS.APPROVAL_AUTHORITY, JOBS.MANAGER_LEVEL, JOBS.MED_CHECKUP_REQ, JOBS.REGULAR_TEMPORARY, JOBS.FULL_PART_TIME, JOBS.JOB_FUNCTION_CODE FROM PER_JOBS_F JOBS, PER_JOBS_F_TL JOBS_TL, FND_SETID_ASSIGNMENTS ASM WHERE JOBS.JOB_ID = JOBS_TL.JOB_ID AND JOBS.EFFECTIVE_START_DATE = JOBS_TL.EFFECTIVE_START_DATE AND JOBS.EFFECTIVE_END_DATE = JOBS_TL.EFFECTIVE_END_DATE AND JOBS_TL.LANGUAGE = SYS_CONTEXT ('USERENV','LANG') AND TRUNC (SYSDATE) BETWEEN JOBS.EFFECTIVE_START_DATE AND JOBS.EFFECTIVE_END_DATE AND ASM.DETERMINANT_TYPE(+) = 'BU' AND ASM.REFERENCE_GROUP_NAME(+) ='HR_JOBS' AND JOBS.SET_ID = ASM.SET_ID(+)

SQL_Statement

SELECT JOBS.JOB_ID,

JOBS.EFFECTIVE_START_DATE,

JOBS.EFFECTIVE_END_DATE,

JOBS.JOB_CODE,

JOBS_TL.NAME,

JOBS.SET_ID,

JOBS.JOB_FAMILY_ID,

JOBS.BUSINESS_GROUP_ID,

JOBS.BENCHMARK_JOB_ID,

JOBS.ACTION_OCCURRENCE_ID,

JOBS.ACTIVE_STATUS,

JOBS.BENCHMARK_JOB_FLAG,

JOBS.APPROVAL_AUTHORITY,

JOBS.MANAGER_LEVEL,

JOBS.MED_CHECKUP_REQ,

JOBS.REGULAR_TEMPORARY,

JOBS.FULL_PART_TIME,

JOBS.JOB_FUNCTION_CODE

FROM PER_JOBS_F JOBS,

PER_JOBS_F_TL JOBS_TL,

FND_SETID_ASSIGNMENTS ASM

WHERE JOBS.JOB_ID = JOBS_TL.JOB_ID

AND JOBS.EFFECTIVE_START_DATE = JOBS_TL.EFFECTIVE_START_DATE

AND JOBS.EFFECTIVE_END_DATE = JOBS_TL.EFFECTIVE_END_DATE

AND JOBS_TL.LANGUAGE = SYS_CONTEXT ('USERENV','LANG')

AND TRUNC (SYSDATE) BETWEEN

JOBS.EFFECTIVE_START_DATE AND JOBS.EFFECTIVE_END_DATE

AND ASM.DETERMINANT_TYPE(+) = 'BU'

AND ASM.REFERENCE_GROUP_NAME(+) ='HR_JOBS'

AND JOBS.SET_ID = ASM.SET_ID(+)