[Home] [Help] [Dependency Information]

VIEW: APPS.HRBV_ASSIGNMENT

Object Details

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A Business Intelligence System view

Shared HRMS base view on PER_ASSIGNMENTS_F for use in Discoverer shared HRMS end user layer

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      TITLE
,      ASSIGNMENT_SEQUENCE
,      ASSIGNMENT_NUMBER
,      DATE_PROBATION_END
,      CHANGE_REASON
,      INTERNAL_ADDRESS_LINE
,      PROJECT_TITLE
,      TIME_NORMAL_START
,      TIME_NORMAL_FINISH
,      NOTICE_PERIOD
,      NOTICE_PERIOD_UOM
,      WORK_AT_HOME
,      BARGAINING_UNIT
,      LABOUR_UNION_MEMBER_FLAG
,      PERIOD_OF_PLACEMENT_DATE_START
,      PROBATION_PERIOD
,      PROBATION_UNIT
,      SAL_REVIEW_PERIOD
,      SAL_REVIEW_PERIOD_FREQUENCY
,      PERF_REVIEW_PERIOD
,      PERF_REVIEW_PERIOD_FREQUENCY
,      PRIMARY_FLAG
,      MANAGER_FLAG
,      EMPLOYEE_CATEGORY
,      ASSIGNMENT_TYPE
,      ASSIGNMENT_CATEGORY
,      EMPLOYMENT_CATEGORY
,      NORMAL_HOURS
,      NORMAL_HOURS_FREQUENCY
,      SOURCE_TYPE
,      VENDOR_EMPLOYEE_NUMBER
,      VENDOR_ASSIGNMENT_NUMBER
,      JOB_POST_SOURCE_NAME
,      CHANGE_REASON_CODE
,      NOTICE_PERIOD_UOM_CODE
,      WORK_AT_HOME_CODE
,      BARGAINING_UNIT_CODE
,      HOURLY_SALARIED_CODE
,      LABOUR_UNION_MEMBER_FLAG_CODE
,      PROBATION_UNIT_CODE
,      SAL_REVIEW_PERIOD_FREQ_CODE
,      PERF_REVIEW_PERIOD_FREQ_CODE
,      PRIMARY_FLAG_CODE
,      MANAGER_FLAG_CODE
,      EMPLOYMENT_CATEGORY_CODE
,      ASSIGNMENT_TYPE_CODE
,      NORMAL_HOURS_FREQUENCY_CODE
,      SOURCE_TYPE_CODE
,      _DF:AAD
,      LEGISLATION_CODE
,      ASSIGNMENT_ID
,      BUSINESS_GROUP_ID
,      ASSIGNMENT_STATUS_TYPE_ID
,      GRADE_ID
,      JOB_ID
,      LOCATION_ID
,      ORGANIZATION_ID
,      PAYROLL_ID
,      PERIOD_OF_SERVICE_ID
,      PERSON_ID
,      POSITION_ID
,      PEOPLE_GROUP_ID
,      SOFT_CODING_KEYFLEX_ID
,      PAY_BASIS_ID
,      SUPERVISOR_ID
,      VACANCY_ID
,      RECRUITER_ID
,      PERSON_REFERRED_BY_ID
,      RECRUITMENT_ACTIVITY_ID
,      SPECIAL_CEILING_STEP_ID
,      SOURCE_ORGANIZATION_ID
,      APPLICATION_ID
,      COMMENT_ID
,      DEFAULT_CODE_COMB_ID
,      SET_OF_BOOKS_ID
,      CONTRACT_ID
,      COLLECTIVE_AGREEMENT_ID
,      CAGR_ID_FLEX_NUM
,      CAGR_GRADE_DEF_ID
,      ESTABLISHMENT_ID
,      VENDOR_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      BG_SECURITY_FLAG_CODE
FROM APPS.HRBV_ASSIGNMENT;

Dependencies

[top of page]

APPS

HR_API - show dependent code

HR_BIS - show dependent code

HR_GENERAL - show dependent code

HR_SECURITY - show dependent code

PER_ASSIGNMENTS_F

APPS.HRBV_ASSIGNMENT is not referenced by any database object