APPS.PER_ASSIGNMENTS_F
[Home] [Help]
| Product: | PER - Human Resources |
|---|---|
| Description: | Secure view based on the corresponding _ALL_ table. |
| Implementation/DBA Data: |
APPS.PER_ASSIGNMENTS_F
|
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
, BARGAINING_UNIT_CODE
, LABOUR_UNION_MEMBER_FLAG
, HOURLY_SALARIED_CODE
, 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
, OBJECT_VERSION_NUMBER
, CONTRACT_ID
, CAGR_ID_FLEX_NUM
, CAGR_GRADE_DEF_ID
, ESTABLISHMENT_ID
, COLLECTIVE_AGREEMENT_ID
, NOTICE_PERIOD
, NOTICE_PERIOD_UOM
, EMPLOYEE_CATEGORY
, WORK_AT_HOME
, JOB_POST_SOURCE_NAME
, 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
, ASSIGNMENT_CATEGORY
, PROJECT_TITLE
, GRADE_LADDER_PGM_ID
, SUPERVISOR_ASSIGNMENT_ID
FROM PER_ALL_ASSIGNMENTS_F PAA
WHERE DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('PER_ALL_ASSIGNMENTS_F'
, PAA.ASSIGNMENT_ID
, PAA.PERSON_ID
, PAA.ASSIGNMENT_TYPE )) = 'TRUE'
AND DECODE(HR_GENERAL.GET_XBG_PROFILE
, 'Y'
, PAA.BUSINESS_GROUP_ID
, HR_GENERAL.GET_BUSINESS_GROUP_ID) = PAA.BUSINESS_GROUP_ID