DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PER_ALL_ASSIGNMENTS

Object Details
Object Name: PER_ALL_ASSIGNMENTS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.PER_ALL_ASSIGNMENTS
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_ID NUMBER (10) Yes
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE
Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
RECRUITER_ID NUMBER (10)

GRADE_ID NUMBER (15)

POSITION_ID NUMBER (15)

JOB_ID NUMBER (15)

ASSIGNMENT_STATUS_TYPE_ID NUMBER (9) Yes
PAYROLL_ID NUMBER (9)

LOCATION_ID NUMBER (15)

PERSON_REFERRED_BY_ID NUMBER (10)

SUPERVISOR_ID NUMBER (10)

SPECIAL_CEILING_STEP_ID NUMBER (15)

PERSON_ID NUMBER (10) Yes
RECRUITMENT_ACTIVITY_ID NUMBER (15)

SOURCE_ORGANIZATION_ID NUMBER (15)

ORGANIZATION_ID NUMBER (15) Yes
PEOPLE_GROUP_ID NUMBER (15)

SOFT_CODING_KEYFLEX_ID NUMBER (15)

VACANCY_ID NUMBER (15)

PAY_BASIS_ID NUMBER (9)

ASSIGNMENT_SEQUENCE NUMBER (15) Yes
ASSIGNMENT_TYPE VARCHAR2 (1) Yes
PRIMARY_FLAG VARCHAR2 (30) Yes
APPLICATION_ID NUMBER (15)

ASSIGNMENT_NUMBER VARCHAR2 (30)

CHANGE_REASON VARCHAR2 (30)

COMMENT_ID NUMBER (15)

DATE_PROBATION_END DATE


DEFAULT_CODE_COMB_ID NUMBER (15)

EMPLOYMENT_CATEGORY VARCHAR2 (30)

FREQUENCY VARCHAR2 (30)

INTERNAL_ADDRESS_LINE VARCHAR2 (80)

MANAGER_FLAG VARCHAR2 (30)

NORMAL_HOURS NUMBER (22)

PERF_REVIEW_PERIOD NUMBER (15)

PERF_REVIEW_PERIOD_FREQUENCY VARCHAR2 (30)

PERIOD_OF_SERVICE_ID NUMBER (15)

PROBATION_PERIOD NUMBER (22)

PROBATION_UNIT VARCHAR2 (30)

SAL_REVIEW_PERIOD NUMBER (15)

SAL_REVIEW_PERIOD_FREQUENCY VARCHAR2 (30)

SET_OF_BOOKS_ID NUMBER (15)

SOURCE_TYPE VARCHAR2 (30)

TIME_NORMAL_FINISH VARCHAR2 (5)

TIME_NORMAL_START VARCHAR2 (5)

REQUEST_ID NUMBER (15)

PROGRAM_APPLICATION_ID NUMBER (15)

PROGRAM_ID NUMBER (15)

PROGRAM_UPDATE_DATE DATE


ASS_ATTRIBUTE_CATEGORY VARCHAR2 (30)

ASS_ATTRIBUTE1 VARCHAR2 (150)

ASS_ATTRIBUTE2 VARCHAR2 (150)

ASS_ATTRIBUTE3 VARCHAR2 (150)

ASS_ATTRIBUTE4 VARCHAR2 (150)

ASS_ATTRIBUTE5 VARCHAR2 (150)

ASS_ATTRIBUTE6 VARCHAR2 (150)

ASS_ATTRIBUTE7 VARCHAR2 (150)

ASS_ATTRIBUTE8 VARCHAR2 (150)

ASS_ATTRIBUTE9 VARCHAR2 (150)

ASS_ATTRIBUTE10 VARCHAR2 (150)

ASS_ATTRIBUTE11 VARCHAR2 (150)

ASS_ATTRIBUTE12 VARCHAR2 (150)

ASS_ATTRIBUTE13 VARCHAR2 (150)

ASS_ATTRIBUTE14 VARCHAR2 (150)

ASS_ATTRIBUTE15 VARCHAR2 (150)

ASS_ATTRIBUTE16 VARCHAR2 (150)

ASS_ATTRIBUTE17 VARCHAR2 (150)

ASS_ATTRIBUTE18 VARCHAR2 (150)

ASS_ATTRIBUTE19 VARCHAR2 (150)

ASS_ATTRIBUTE20 VARCHAR2 (150)

ASS_ATTRIBUTE21 VARCHAR2 (150)

ASS_ATTRIBUTE22 VARCHAR2 (150)

ASS_ATTRIBUTE23 VARCHAR2 (150)

ASS_ATTRIBUTE24 VARCHAR2 (150)

ASS_ATTRIBUTE25 VARCHAR2 (150)

ASS_ATTRIBUTE26 VARCHAR2 (150)

ASS_ATTRIBUTE27 VARCHAR2 (150)

ASS_ATTRIBUTE28 VARCHAR2 (150)

ASS_ATTRIBUTE29 VARCHAR2 (150)

ASS_ATTRIBUTE30 VARCHAR2 (150)

LAST_UPDATE_DATE DATE


LAST_UPDATED_BY NUMBER (15)

LAST_UPDATE_LOGIN NUMBER (15)

CREATED_BY NUMBER (15)

CREATION_DATE DATE


TITLE VARCHAR2 (30)

NOTICE_PERIOD NUMBER (10)
NOTICE_PERIOD_UOM VARCHAR2 (30)
EMPLOYEE_CATEGORY VARCHAR2 (30)
WORK_AT_HOME VARCHAR2 (30)
JOB_POST_SOURCE_NAME VARCHAR2 (240)
OBJECT_VERSION_NUMBER NUMBER (9)

PERIOD_OF_PLACEMENT_DATE_START DATE

Date contingent worker placement started.
VENDOR_ID NUMBER (15)
Supplying organization for contingent workers
VENDOR_SITE_ID NUMBER (15)
Site of the supplying organization
PO_HEADER_ID NUMBER (15)
Purchase order header for contingent worker services procurement
PO_LINE_ID NUMBER (15)
Purchase order line for contingent worker services procurement
PROJECTED_ASSIGNMENT_END DATE

Date the assignment is expected to end
VENDOR_EMPLOYEE_NUMBER VARCHAR2 (30)
Employee number of worker with supplying organization
VENDOR_ASSIGNMENT_NUMBER VARCHAR2 (30)
Assignment number of this assignment with supplying organization
SUPERVISOR_ASSIGNMENT_ID NUMBER (15)
Assignment which acts as supervisory assignment
Query Text

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


SELECT ASSIGNMENT_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      RECRUITER_ID
,      GRADE_ID
,      POSITION_ID
,      JOB_ID
,      ASSIGNMENT_STATUS_TYPE_ID
,      PAYROLL_ID
,      LOCATION_ID
,      PERSON_REFERRED_BY_ID
,      SUPERVISOR_ID
,      SPECIAL_CEILING_STEP_ID
,      PERSON_ID
,      RECRUITMENT_ACTIVITY_ID
,      SOURCE_ORGANIZATION_ID
,      ORGANIZATION_ID
,      PEOPLE_GROUP_ID
,      SOFT_CODING_KEYFLEX_ID
,      VACANCY_ID
,      PAY_BASIS_ID
,      ASSIGNMENT_SEQUENCE
,      ASSIGNMENT_TYPE
,      PRIMARY_FLAG
,      APPLICATION_ID
,      ASSIGNMENT_NUMBER
,      CHANGE_REASON
,      COMMENT_ID
,      DATE_PROBATION_END
,      DEFAULT_CODE_COMB_ID
,      EMPLOYMENT_CATEGORY
,      FREQUENCY
,      INTERNAL_ADDRESS_LINE
,      MANAGER_FLAG
,      NORMAL_HOURS
,      PERF_REVIEW_PERIOD
,      PERF_REVIEW_PERIOD_FREQUENCY
,      PERIOD_OF_SERVICE_ID
,      PROBATION_PERIOD
,      PROBATION_UNIT
,      SAL_REVIEW_PERIOD
,      SAL_REVIEW_PERIOD_FREQUENCY
,      SET_OF_BOOKS_ID
,      SOURCE_TYPE
,      TIME_NORMAL_FINISH
,      TIME_NORMAL_START
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ASS_ATTRIBUTE_CATEGORY
,      ASS_ATTRIBUTE1
,      ASS_ATTRIBUTE2
,      ASS_ATTRIBUTE3
,      ASS_ATTRIBUTE4
,      ASS_ATTRIBUTE5
,      ASS_ATTRIBUTE6
,      ASS_ATTRIBUTE7
,      ASS_ATTRIBUTE8
,      ASS_ATTRIBUTE9
,      ASS_ATTRIBUTE10
,      ASS_ATTRIBUTE11
,      ASS_ATTRIBUTE12
,      ASS_ATTRIBUTE13
,      ASS_ATTRIBUTE14
,      ASS_ATTRIBUTE15
,      ASS_ATTRIBUTE16
,      ASS_ATTRIBUTE17
,      ASS_ATTRIBUTE18
,      ASS_ATTRIBUTE19
,      ASS_ATTRIBUTE20
,      ASS_ATTRIBUTE21
,      ASS_ATTRIBUTE22
,      ASS_ATTRIBUTE23
,      ASS_ATTRIBUTE24
,      ASS_ATTRIBUTE25
,      ASS_ATTRIBUTE26
,      ASS_ATTRIBUTE27
,      ASS_ATTRIBUTE28
,      ASS_ATTRIBUTE29
,      ASS_ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      TITLE
,      NOTICE_PERIOD
,      NOTICE_PERIOD_UOM
,      EMPLOYEE_CATEGORY
,      WORK_AT_HOME
,      JOB_POST_SOURCE_NAME
,      OBJECT_VERSION_NUMBER
,      PERIOD_OF_PLACEMENT_DATE_START
,      VENDOR_ID
,      VENDOR_SITE_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      PROJECTED_ASSIGNMENT_END
,      VENDOR_EMPLOYEE_NUMBER
,      VENDOR_ASSIGNMENT_NUMBER
,      SUPERVISOR_ASSIGNMENT_ID
FROM APPS.PER_ALL_ASSIGNMENTS;

Dependencies

[top of page]

APPS.PER_ALL_ASSIGNMENTS references the following:

SchemaAPPS
SynonymFND_SESSIONS
SynonymPER_ALL_ASSIGNMENTS_F
APPS.PER_ALL_ASSIGNMENTS is referenced by following:

SchemaAPPS
Package BodyGHR_CPDF_EHRIS - show dependent code
Package BodyGHR_CPDF_STATRPT - show dependent code
TriggerHR_PAY_IF_ELE_ENT_BRD
Package BodyOTA_EL_TRAINING_SS - show dependent code
Package BodyOTA_ENROLL_REVIEW_SS - show dependent code
Package BodyOTA_LEARNER_ENROLL_REVIEW_SS - show dependent code
Package BodyOTA_TRAINING_SS - show dependent code
Package BodyPAY_AU_PAYMENT_SUMMARY - show dependent code
Package BodyPAY_CA_GROUP_LEVEL_BAL_PKG - show dependent code
Package BodyPAY_CN_DEDUCTIONS - show dependent code
Package BodyPAY_FI_ARCHIVE_DPSA - show dependent code
Package BodyPAY_FI_ARCHIVE_LTFA - show dependent code
Package BodyPAY_FI_RULES - show dependent code
Package BodyPAY_GB_TAX_CREDIT_PKG - show dependent code
Package BodyPAY_HK_IR56_ARCHIVE - show dependent code
PL/SQL PackagePAY_HK_IR56_ARCHIVE - show dependent code
Package BodyPAY_IE_EOY_INCOMELEVY_REPORT - show dependent code
Package BodyPAY_INTERPRETER_PKG - show dependent code
Package BodyPAY_IPD_BUS - show dependent code
Package BodyPAY_JP_GENERIC_UPGRADE_PKG - show dependent code
Package BodyPAY_SG_PAYSLIP_ARCHIVE - show dependent code
PL/SQL PackagePAY_US_NACHA_IAT_TAPE - show dependent code
PL/SQL PackagePAY_ZA_ACB_TAPE - show dependent code
Package BodyPER_ASSIGNMENTS_F1_PKG - show dependent code
Package BodyPER_ASSIGNMENTS_F3_PKG - show dependent code
Package BodyPER_ORG_BGT_PKG - show dependent code
ViewPER_PEOPLE_V3
Package BodyPER_POS_BGT_PKG - show dependent code
ViewPER_QUICKPAINT_ASSIGNMENTS
Package BodyPER_VACANCIES_PKG - show dependent code
Package BodyPQH_PSF_BUS - show dependent code
Package BodyPQH_WF - show dependent code
Package BodyPQP_NL_PENSION_EXTRACTS - show dependent code
Package BodyPQP_NL_PGGM_PENSION_EXTRACTS - show dependent code
Package BodyPQP_PENSION_EXTRACTS - show dependent code
Package BodyPQP_US_PENSION_EXTRACTS - show dependent code