VIEW: APPS.HRBV_ASSIGNMENT

Source

View Text - Preformatted

SELECT asg.effective_start_date effective_start_date ,asg.effective_end_date effective_end_date ,asg.title title ,asg.assignment_sequence assignment_sequence ,asg.assignment_number assignment_number ,asg.date_probation_end date_probation_end ,decode(asg.assignment_type ,'E', hr_bis.bis_decode_lookup('EMP_ASSIGN_REASON', asg.change_reason) ,'C', hr_bis.bis_decode_lookup('CWK_ASSIGN_REASON', asg.change_reason)) change_reason ,asg.internal_address_line internal_address_line ,asg.project_title project_title ,asg.time_normal_start time_normal_start ,asg.time_normal_finish time_normal_finish ,asg.notice_period notice_period ,hr_bis.bis_decode_lookup('QUALIFYING_UNITS',asg.notice_period_uom) notice_period_uom ,hr_bis.bis_decode_lookup('YES_NO',asg.work_at_home) work_at_home ,hr_bis.bis_decode_lookup('BARGAINING_UNIT_CODE',asg.bargaining_unit_code) bargaining_unit_code ,hr_bis.bis_decode_lookup('YES_NO',asg.labour_union_member_flag) labour_union_member_flag ,asg.period_of_placement_date_start period_of_placement_date_start ,asg.probation_period probation_period ,hr_bis.bis_decode_lookup('QUALIFYING_UNITS',asg.probation_unit) probation_unit ,asg.sal_review_period sal_review_period ,hr_bis.bis_decode_lookup('FREQUENCY',asg.sal_review_period_frequency) sal_review_period_frequency ,asg.perf_review_period perf_review_period ,hr_bis.bis_decode_lookup('FREQUENCY',asg.perf_review_period_frequency) perf_review_period_frequency ,hr_bis.bis_decode_lookup('YES_NO',asg.primary_flag) primary_flag ,hr_bis.bis_decode_lookup('YES_NO',asg.manager_flag) manager_flag ,hr_bis.bis_decode_lookup('EMPLOYEE_CATG',asg.employee_category) employee_category ,hr_bis.bis_decode_lookup('EMP_APL',asg.assignment_type) assignment_type ,asg.assignment_category assignment_category ,decode(asg.assignment_type ,'E', hr_bis.bis_decode_lookup('EMP_CAT', asg.employment_category) ,'C', hr_bis.bis_decode_lookup('CWK_ASG_CATEGORY', asg.employment_category)) employment_category ,asg.normal_hours normal_hours ,hr_bis.bis_decode_lookup('FREQUENCY',asg.frequency) normal_hours_frequency ,hr_bis.bis_decode_lookup('REC_TYPE',asg.source_type) source_type ,asg.vendor_employee_number vendor_employee_number ,asg.vendor_assignment_number vendor_assignment_number ,asg.job_post_source_name job_post_source_name ,asg.change_reason change_reason_code ,asg.notice_period_uom notice_period_uom_code ,asg.work_at_home work_at_home_code ,asg.bargaining_unit_code bargaining_unit_code ,asg.hourly_salaried_code hourly_salaried_code ,asg.labour_union_member_flag labour_union_member_flag_code ,asg.probation_unit probation_unit_code ,asg.sal_review_period_frequency sal_review_period_freq_code ,asg.perf_review_period_frequency perf_review_period_freq_code ,asg.primary_flag primary_flag_code ,asg.manager_flag manager_flag_code ,asg.employment_category employment_category_code ,asg.assignment_type assignment_type_code ,asg.frequency frequency_code ,asg.source_type source_type_code ,'_DF:PER:PER_ASSIGNMENTS:asg' ,hr_api.return_legislation_code(asg.business_group_id) legislation_code ,asg.assignment_id assignment_id ,asg.business_group_id business_group_id ,asg.assignment_status_type_id assignment_status_type_id ,asg.grade_id grade_id ,asg.job_id job_id ,asg.location_id location_id ,asg.organization_id organization_id ,asg.payroll_id payroll_id ,asg.period_of_service_id period_of_service_id ,asg.person_id person_id ,asg.position_id position_id ,asg.people_group_id people_group_id ,asg.soft_coding_keyflex_id soft_coding_keyflex_id ,asg.pay_basis_id pay_basis_id ,asg.supervisor_id supervisor_id ,asg.vacancy_id vacancy_id ,asg.recruiter_id recruiter_id ,asg.person_referred_by_id person_referred_by_id ,asg.recruitment_activity_id recruitment_activity_id ,asg.special_ceiling_step_id special_ceiling_step_id ,asg.source_organization_id source_organization_id ,asg.application_id application_id ,asg.comment_id comment_id ,asg.default_code_comb_id default_code_comb_id ,asg.set_of_books_id set_of_books_id ,asg.contract_id contract_id ,asg.collective_agreement_id collective_agreement_id ,asg.cagr_id_flex_num cagr_id_flex_num ,asg.cagr_grade_def_id cagr_grade_def_id ,asg.establishment_id establishment_id ,asg.vendor_id vendor_id ,asg.last_update_date last_update_date ,asg.last_updated_by last_updated_by ,asg.last_update_login last_update_login ,asg.created_by created_by ,asg.creation_date creation_date ,CASE WHEN (asg.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, asg.business_group_id)) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM per_assignments_f asg WITH READ ONLY

View Text - HTML Formatted

SELECT ASG.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, ASG.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, ASG.TITLE TITLE
, ASG.ASSIGNMENT_SEQUENCE ASSIGNMENT_SEQUENCE
, ASG.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, ASG.DATE_PROBATION_END DATE_PROBATION_END
, DECODE(ASG.ASSIGNMENT_TYPE
, 'E'
, HR_BIS.BIS_DECODE_LOOKUP('EMP_ASSIGN_REASON'
, ASG.CHANGE_REASON)
, 'C'
, HR_BIS.BIS_DECODE_LOOKUP('CWK_ASSIGN_REASON'
, ASG.CHANGE_REASON)) CHANGE_REASON
, ASG.INTERNAL_ADDRESS_LINE INTERNAL_ADDRESS_LINE
, ASG.PROJECT_TITLE PROJECT_TITLE
, ASG.TIME_NORMAL_START TIME_NORMAL_START
, ASG.TIME_NORMAL_FINISH TIME_NORMAL_FINISH
, ASG.NOTICE_PERIOD NOTICE_PERIOD
, HR_BIS.BIS_DECODE_LOOKUP('QUALIFYING_UNITS'
, ASG.NOTICE_PERIOD_UOM) NOTICE_PERIOD_UOM
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ASG.WORK_AT_HOME) WORK_AT_HOME
, HR_BIS.BIS_DECODE_LOOKUP('BARGAINING_UNIT_CODE'
, ASG.BARGAINING_UNIT_CODE) BARGAINING_UNIT_CODE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ASG.LABOUR_UNION_MEMBER_FLAG) LABOUR_UNION_MEMBER_FLAG
, ASG.PERIOD_OF_PLACEMENT_DATE_START PERIOD_OF_PLACEMENT_DATE_START
, ASG.PROBATION_PERIOD PROBATION_PERIOD
, HR_BIS.BIS_DECODE_LOOKUP('QUALIFYING_UNITS'
, ASG.PROBATION_UNIT) PROBATION_UNIT
, ASG.SAL_REVIEW_PERIOD SAL_REVIEW_PERIOD
, HR_BIS.BIS_DECODE_LOOKUP('FREQUENCY'
, ASG.SAL_REVIEW_PERIOD_FREQUENCY) SAL_REVIEW_PERIOD_FREQUENCY
, ASG.PERF_REVIEW_PERIOD PERF_REVIEW_PERIOD
, HR_BIS.BIS_DECODE_LOOKUP('FREQUENCY'
, ASG.PERF_REVIEW_PERIOD_FREQUENCY) PERF_REVIEW_PERIOD_FREQUENCY
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ASG.PRIMARY_FLAG) PRIMARY_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ASG.MANAGER_FLAG) MANAGER_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('EMPLOYEE_CATG'
, ASG.EMPLOYEE_CATEGORY) EMPLOYEE_CATEGORY
, HR_BIS.BIS_DECODE_LOOKUP('EMP_APL'
, ASG.ASSIGNMENT_TYPE) ASSIGNMENT_TYPE
, ASG.ASSIGNMENT_CATEGORY ASSIGNMENT_CATEGORY
, DECODE(ASG.ASSIGNMENT_TYPE
, 'E'
, HR_BIS.BIS_DECODE_LOOKUP('EMP_CAT'
, ASG.EMPLOYMENT_CATEGORY)
, 'C'
, HR_BIS.BIS_DECODE_LOOKUP('CWK_ASG_CATEGORY'
, ASG.EMPLOYMENT_CATEGORY)) EMPLOYMENT_CATEGORY
, ASG.NORMAL_HOURS NORMAL_HOURS
, HR_BIS.BIS_DECODE_LOOKUP('FREQUENCY'
, ASG.FREQUENCY) NORMAL_HOURS_FREQUENCY
, HR_BIS.BIS_DECODE_LOOKUP('REC_TYPE'
, ASG.SOURCE_TYPE) SOURCE_TYPE
, ASG.VENDOR_EMPLOYEE_NUMBER VENDOR_EMPLOYEE_NUMBER
, ASG.VENDOR_ASSIGNMENT_NUMBER VENDOR_ASSIGNMENT_NUMBER
, ASG.JOB_POST_SOURCE_NAME JOB_POST_SOURCE_NAME
, ASG.CHANGE_REASON CHANGE_REASON_CODE
, ASG.NOTICE_PERIOD_UOM NOTICE_PERIOD_UOM_CODE
, ASG.WORK_AT_HOME WORK_AT_HOME_CODE
, ASG.BARGAINING_UNIT_CODE BARGAINING_UNIT_CODE
, ASG.HOURLY_SALARIED_CODE HOURLY_SALARIED_CODE
, ASG.LABOUR_UNION_MEMBER_FLAG LABOUR_UNION_MEMBER_FLAG_CODE
, ASG.PROBATION_UNIT PROBATION_UNIT_CODE
, ASG.SAL_REVIEW_PERIOD_FREQUENCY SAL_REVIEW_PERIOD_FREQ_CODE
, ASG.PERF_REVIEW_PERIOD_FREQUENCY PERF_REVIEW_PERIOD_FREQ_CODE
, ASG.PRIMARY_FLAG PRIMARY_FLAG_CODE
, ASG.MANAGER_FLAG MANAGER_FLAG_CODE
, ASG.EMPLOYMENT_CATEGORY EMPLOYMENT_CATEGORY_CODE
, ASG.ASSIGNMENT_TYPE ASSIGNMENT_TYPE_CODE
, ASG.FREQUENCY FREQUENCY_CODE
, ASG.SOURCE_TYPE SOURCE_TYPE_CODE
, '_DF:PER:PER_ASSIGNMENTS:ASG'
, HR_API.RETURN_LEGISLATION_CODE(ASG.BUSINESS_GROUP_ID) LEGISLATION_CODE
, ASG.ASSIGNMENT_ID ASSIGNMENT_ID
, ASG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ASG.ASSIGNMENT_STATUS_TYPE_ID ASSIGNMENT_STATUS_TYPE_ID
, ASG.GRADE_ID GRADE_ID
, ASG.JOB_ID JOB_ID
, ASG.LOCATION_ID LOCATION_ID
, ASG.ORGANIZATION_ID ORGANIZATION_ID
, ASG.PAYROLL_ID PAYROLL_ID
, ASG.PERIOD_OF_SERVICE_ID PERIOD_OF_SERVICE_ID
, ASG.PERSON_ID PERSON_ID
, ASG.POSITION_ID POSITION_ID
, ASG.PEOPLE_GROUP_ID PEOPLE_GROUP_ID
, ASG.SOFT_CODING_KEYFLEX_ID SOFT_CODING_KEYFLEX_ID
, ASG.PAY_BASIS_ID PAY_BASIS_ID
, ASG.SUPERVISOR_ID SUPERVISOR_ID
, ASG.VACANCY_ID VACANCY_ID
, ASG.RECRUITER_ID RECRUITER_ID
, ASG.PERSON_REFERRED_BY_ID PERSON_REFERRED_BY_ID
, ASG.RECRUITMENT_ACTIVITY_ID RECRUITMENT_ACTIVITY_ID
, ASG.SPECIAL_CEILING_STEP_ID SPECIAL_CEILING_STEP_ID
, ASG.SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, ASG.APPLICATION_ID APPLICATION_ID
, ASG.COMMENT_ID COMMENT_ID
, ASG.DEFAULT_CODE_COMB_ID DEFAULT_CODE_COMB_ID
, ASG.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ASG.CONTRACT_ID CONTRACT_ID
, ASG.COLLECTIVE_AGREEMENT_ID COLLECTIVE_AGREEMENT_ID
, ASG.CAGR_ID_FLEX_NUM CAGR_ID_FLEX_NUM
, ASG.CAGR_GRADE_DEF_ID CAGR_GRADE_DEF_ID
, ASG.ESTABLISHMENT_ID ESTABLISHMENT_ID
, ASG.VENDOR_ID VENDOR_ID
, ASG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ASG.LAST_UPDATED_BY LAST_UPDATED_BY
, ASG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ASG.CREATED_BY CREATED_BY
, ASG.CREATION_DATE CREATION_DATE
, CASE WHEN (ASG.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ASG.BUSINESS_GROUP_ID)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_ASSIGNMENTS_F ASG WITH READ ONLY