Product: | PER - Human Resources |
---|---|
Description: | Based on per_previous_job_info_types |
Implementation/DBA Data: | APPS.PER_PREV_JOB_INFO_TYPES_V |
SELECT JIT.INFORMATION_TYPE
, JIT.ACTIVE_INACTIVE_FLAG
, JIT.MULTIPLE_OCCURANCES_FLAG
, JIT.DESCRIPTION
, JIT.LEGISLATION_CODE
, JIT.OBJECT_VERSION_NUMBER
, JIT.LAST_UPDATE_DATE
, JIT.LAST_UPDATED_BY
, JIT.LAST_UPDATE_LOGIN
, JIT.CREATED_BY
, JIT.CREATION_DATE
, ITS.RESPONSIBILITY_ID
FROM PER_PREV_JOB_INFO_TYPES JIT
, PER_INFO_TYPE_SECURITY ITS WHERE JIT.ACTIVE_INACTIVE_FLAG = 'Y' AND ITS.APPLICATION_ID = 800 AND ITS.INFO_TYPE_TABLE_NAME = 'PER_PREV_JOB_INFO_TYPES' AND ITS.INFORMATION_TYPE = JIT.INFORMATION_TYPE