VIEW: APPS.HRI_CL_ASGSTYP_BX_V

Source

View Text - Preformatted

SELECT ast.assignment_status_type_id id , NVL(ast_tl.user_status , asa_tl.user_status) value , hr_general.start_of_time date_from , hr_general.end_of_time date_to , NVL(ast.business_group_id ,asa.business_group_id) business_group_id , ast.pay_system_status pay_system_status , ast.per_system_status per_system_status , ast.primary_flag primary_flag , ast.default_flag default_flag , NVL(ast.active_flag ,asa.active_flag) valid_code FROM per_assignment_status_types ast , per_assignment_status_types_tl ast_tl , per_ass_status_type_amends asa , per_ass_status_type_amends_tl asa_tl WHERE NVL(asa.active_flag, ast.active_flag) = 'Y' AND ast.assignment_status_type_id = asa.assignment_status_type_id (+) AND ast.assignment_status_type_id = ast_tl.assignment_status_type_id AND asa.ass_status_type_amend_id = asa_tl.ass_status_type_amend_id (+) AND ast_tl.language = userenv('LANG') AND DECODE (asa_tl.ass_status_type_amend_id, null, '1', asa_tl.language) = DECODE (asa_tl.ass_status_type_amend_id, null, '1', userenv('LANG')) AND (asa.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,asa.business_group_id) OR ast.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,ast.business_group_id) OR ast.business_group_id IS NULL) WITH READ ONLY

View Text - HTML Formatted

SELECT AST.ASSIGNMENT_STATUS_TYPE_ID ID
, NVL(AST_TL.USER_STATUS
, ASA_TL.USER_STATUS) VALUE
, HR_GENERAL.START_OF_TIME DATE_FROM
, HR_GENERAL.END_OF_TIME DATE_TO
, NVL(AST.BUSINESS_GROUP_ID
, ASA.BUSINESS_GROUP_ID) BUSINESS_GROUP_ID
, AST.PAY_SYSTEM_STATUS PAY_SYSTEM_STATUS
, AST.PER_SYSTEM_STATUS PER_SYSTEM_STATUS
, AST.PRIMARY_FLAG PRIMARY_FLAG
, AST.DEFAULT_FLAG DEFAULT_FLAG
, NVL(AST.ACTIVE_FLAG
, ASA.ACTIVE_FLAG) VALID_CODE
FROM PER_ASSIGNMENT_STATUS_TYPES AST
, PER_ASSIGNMENT_STATUS_TYPES_TL AST_TL
, PER_ASS_STATUS_TYPE_AMENDS ASA
, PER_ASS_STATUS_TYPE_AMENDS_TL ASA_TL
WHERE NVL(ASA.ACTIVE_FLAG
, AST.ACTIVE_FLAG) = 'Y'
AND AST.ASSIGNMENT_STATUS_TYPE_ID = ASA.ASSIGNMENT_STATUS_TYPE_ID (+)
AND AST.ASSIGNMENT_STATUS_TYPE_ID = AST_TL.ASSIGNMENT_STATUS_TYPE_ID
AND ASA.ASS_STATUS_TYPE_AMEND_ID = ASA_TL.ASS_STATUS_TYPE_AMEND_ID (+)
AND AST_TL.LANGUAGE = USERENV('LANG')
AND DECODE (ASA_TL.ASS_STATUS_TYPE_AMEND_ID
, NULL
, '1'
, ASA_TL.LANGUAGE) = DECODE (ASA_TL.ASS_STATUS_TYPE_AMEND_ID
, NULL
, '1'
, USERENV('LANG'))
AND (ASA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ASA.BUSINESS_GROUP_ID) OR AST.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, AST.BUSINESS_GROUP_ID) OR AST.BUSINESS_GROUP_ID IS NULL) WITH READ ONLY