[Home] [Help] [Dependency Information]

VIEW: APPS.HRIFV_US_EMPASGDTL_EMPXASG

Object Details

Object Name:	HRIFV_US_EMPASGDTL_EMPXASG
Object Type:	VIEW
Owner:	APPS
FND Design Data:	HRI.HRIFV_US_EMPASGDTL_EMPXASG
Subobject Name:
Status:	VALID

***** 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 Source]

Columns

Query Text

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

SELECT BUSINESS_GROUP_NAME
,      RECORD_START_DATE
,      RECORD_END_DATE
,      EMPLOYEE_START_DATE
,      EMPLOYEE_END_DATE
,      ASSIGNMENT_START_DATE
,      ASSIGNMENT_END_DATE
,      EMPLOYEE_NAME
,      EMPLOYEE_NUMBER
,      MIDDLE_NAMES
,      PREFERRED_NAME
,      FIRST_NAME
,      LAST_NAME
,      GENDER
,      PREVIOUS_LAST_NAME
,      REGISTERED_DISABLED
,      TOWN_OF_BIRTH
,      REGION_OF_BIRTH
,      COUNTRY_OF_BIRTH
,      DATE_OF_BIRTH
,      MARITAL_STATUS
,      NATIONALITY
,      NATIONAL_IDENTIFIER
,      APPLICANT_NUMBER
,      EMAIL_ADDRESS
,      MAIL_DESTINATION
,      SECOND_PASSPORT
,      OFFICE_NUMBER
,      INTERNAL_LOCATION
,      MAILSTOP
,      WORK_SCHEDULE
,      FTE_CAPACITY
,      RESUME_EXISTS
,      RESUME_LAST_UPDATED
,      CURRENT_APPLICANT_FLAG
,      CURRENT_EMPLOYEE_FLAG
,      DATE_EMPLOYEE_DATA_VERIFIED
,      DATE_OF_DEATH
,      FAST_PATH_EMPLOYEE
,      HOLD_APPLICATION_UNTIL
,      HONORS
,      ON_MILITARY_SERVICE
,      PROJECTED_START_DATE
,      STUDENT_STATUS
,      HIRE_DATE
,      ORIGINAL_DATE_OF_HIRE
,      ASSIGNMENT_TITLE
,      ASSIGNMENT_NUMBER
,      NORMAL_START_TIME
,      NORMAL_END_TIME
,      PRIMARY_FLAG
,      INTERNAL_ADDRESS
,      MANAGER_FLAG
,      EMPLOYMENT_CATEGORY
,      WORKING_HOURS_AMOUNT
,      WORKING_HOURS_FREQUENCY
,      ETHNIC_ORIGIN
,      I9
,      I9_EXPIRY_DATE
,      VISA_TYPE
,      VIETNAM_VETS_STATUS
,      STUDENT
,      NEW_HIRE_STATUS
,      EXCLUSION_REASON
,      CHILD_SUPPORT_OBLIGATION
,      SOCIAL_SECURITY_NUMBER
,      USER_ASSIGNMENT_STATUS
,      PER_SYSTEM_ASSIGNMENT_STATUS
,      PAY_SYSTEM_ASSIGNMENT_STATUS
,      _DF:ASG
,      _DF:PEO
,      GENDER_CODE
,      REGISTERED_DISABLED_CODE
,      MARITAL_STATUS_CODE
,      NATIONALITY_CODE
,      MAIL_DESTINATION_CODE
,      SECOND_PASSPORT_CODE
,      RESUME_EXISTS_CODE
,      CURRENT_APPLICANT_CODE
,      CURRENT_EMPLOYEE_CODE
,      FAST_PATH_EMPLOYEE_CODE
,      ON_MILITARY_SERVICE_CODE
,      STUDENT_STATUS_CODE
,      PRIMARY_FLAG_CODE
,      MANAGER_FLAG_CODE
,      EMPLOYMENT_CATEGORY_CODE
,      WORKING_HOURS_FREQUENCY_CODE
,      ETHNIC_ORIGIN_CODE
,      I9_CODE
,      VISA_TYPE_CODE
,      VIETNAM_VETS_STATUS_CODE
,      STUDENT_CODE
,      NEW_HIRE_STATUS_CODE
,      CHILD_SUPPORT_OBLIGATION_CODE
,      PER_SYSTEM_ASGN_STATUS_CODE
,      PAY_SYSTEM_ASGN_STATUS_CODE
,      PERSON_ID
,      BUSINESS_GROUP_ID
,      BENEFIT_GROUP_ID
,      PERSON_TYPE_ID
,      PERSON_COMMENT_ID
,      ASSIGNMENT_ID
,      GRADE_ID
,      JOB_ID
,      LOCATION_ID
,      ORGANIZATION_ID
,      PAYROLL_ID
,      PERIOD_OF_SERVICE_ID
,      PEOPLE_GROUP_ID
,      POSITION_ID
,      RECRUITMENT_ACTIVITY_ID
,      SALARY_BASIS_ID
,      SUPERVISOR_ID
,      SPECIAL_CEILING_STEP_ID
,      ASSIGNMENT_COMMENT_ID
,      SET_OF_BOOKS_ID
,      COLLECTIVE_AGREEMENT_ID
,      CONTRACT_ID
,      VACANCY_ID
,      RECRUITER_ID
,      PERSON_REFERRED_BY_ID
,      SOURCE_ORGANIZATION_ID
FROM APPS.HRIFV_US_EMPASGDTL_EMPXASG;

Dependencies

[top of page]

APPS

FND_DATE - show dependent code

HR_ALL_ORGANIZATION_UNITS_TL

HR_BIS - show dependent code

HR_GENERAL - show dependent code

HR_SECURITY - show dependent code

PER_ALL_PEOPLE_F

PER_ASSIGNMENTS_F

PER_ASSIGNMENT_STATUS_TYPES

PER_ASSIGNMENT_STATUS_TYPES_TL

PER_ASS_STATUS_TYPE_AMENDS

PER_ASS_STATUS_TYPE_AMENDS_TL

PER_BUSINESS_GROUPS

PER_PERIODS_OF_SERVICE

APPS.HRIFV_US_EMPASGDTL_EMPXASG is not referenced by any database object