VIEW: APPS.HRBV_ASSIGNMENT_STATUS_TYPE

Source

View Text - Preformatted

SELECT hr_bis.bis_decode_lookup('YES_NO',ast.active_flag) active_flag ,hr_bis.bis_decode_lookup('YES_NO',ast.default_flag) default_flag ,hr_bis.bis_decode_lookup('PRIM_OR_SEC',ast.primary_flag) primary_flag ,astT.user_status user_status ,ast.pay_system_status pay_system_status ,ast.per_system_status per_system_status ,ast.legislation_code legislation_code ,ast.active_flag active_flag_code ,ast.default_flag default_flag_code ,ast.primary_flag primary_flag_code ,ast.assignment_status_type_id assignment_status_type_id ,ast.business_group_id business_group_id ,ast.last_update_date last_update_date ,ast.last_updated_by last_updated_by ,ast.last_update_login last_update_login ,ast.created_by created_by ,ast.creation_date creation_date ,CASE WHEN ( (ast.business_group_id IS NULL) OR (ast.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, ast.business_group_id))) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM per_assignment_status_types ast ,per_assignment_status_types_tl astT WHERE ast.assignment_status_type_id = astT.assignment_status_type_id AND astT.language = USERENV('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, AST.ACTIVE_FLAG) ACTIVE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, AST.DEFAULT_FLAG) DEFAULT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('PRIM_OR_SEC'
, AST.PRIMARY_FLAG) PRIMARY_FLAG
, ASTT.USER_STATUS USER_STATUS
, AST.PAY_SYSTEM_STATUS PAY_SYSTEM_STATUS
, AST.PER_SYSTEM_STATUS PER_SYSTEM_STATUS
, AST.LEGISLATION_CODE LEGISLATION_CODE
, AST.ACTIVE_FLAG ACTIVE_FLAG_CODE
, AST.DEFAULT_FLAG DEFAULT_FLAG_CODE
, AST.PRIMARY_FLAG PRIMARY_FLAG_CODE
, AST.ASSIGNMENT_STATUS_TYPE_ID ASSIGNMENT_STATUS_TYPE_ID
, AST.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, AST.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AST.LAST_UPDATED_BY LAST_UPDATED_BY
, AST.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AST.CREATED_BY CREATED_BY
, AST.CREATION_DATE CREATION_DATE
, CASE WHEN ( (AST.BUSINESS_GROUP_ID IS NULL) OR (AST.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, AST.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_ASSIGNMENT_STATUS_TYPES AST
, PER_ASSIGNMENT_STATUS_TYPES_TL ASTT
WHERE AST.ASSIGNMENT_STATUS_TYPE_ID = ASTT.ASSIGNMENT_STATUS_TYPE_ID
AND ASTT.LANGUAGE = USERENV('LANG') WITH READ ONLY