VIEW: APPS.PER_ASSIGNMENTS_F

Source

View Text - Preformatted

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

View Text - HTML Formatted

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