VIEW: APPS.HRBV_SECONDARY_ASS_STATUSES_V

Source

View Text - Preformatted

SELECT sas.start_date start_date, sas.comments comments, sas.end_date end_date, HR_BIS.BIS_DECODE_LOOKUP('EMP_SEC_ASSIGN_REASON', sas.reason) reason_m, sas.program_update_date program_update_date, sas.reason reason, '_DF:PER:PER_PERFORMANCE_RATINGS:SAS', sas.secondary_ass_status_id secondary_ass_status_id, sas.business_group_id business_group_id, sas.assignment_id assignment_id, sas.assignment_status_type_id assignment_status_type_id, sas.last_update_date last_update_date, sas.last_updated_by last_updated_by, sas.last_update_login last_update_login, sas.created_by created_by, sas.creation_date creation_date FROM PER_SECONDARY_ASS_STATUSES sas WITH READ ONLY

View Text - HTML Formatted

SELECT SAS.START_DATE START_DATE
, SAS.COMMENTS COMMENTS
, SAS.END_DATE END_DATE
, HR_BIS.BIS_DECODE_LOOKUP('EMP_SEC_ASSIGN_REASON'
, SAS.REASON) REASON_M
, SAS.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SAS.REASON REASON
, '_DF:PER:PER_PERFORMANCE_RATINGS:SAS'
, SAS.SECONDARY_ASS_STATUS_ID SECONDARY_ASS_STATUS_ID
, SAS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, SAS.ASSIGNMENT_ID ASSIGNMENT_ID
, SAS.ASSIGNMENT_STATUS_TYPE_ID ASSIGNMENT_STATUS_TYPE_ID
, SAS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SAS.LAST_UPDATED_BY LAST_UPDATED_BY
, SAS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SAS.CREATED_BY CREATED_BY
, SAS.CREATION_DATE CREATION_DATE
FROM PER_SECONDARY_ASS_STATUSES SAS WITH READ ONLY