VIEW: APPS.HRI_CL_ASG_SET_V

Source

View Text - Preformatted

SELECT ast.assignment_set_id ID , ast.assignment_set_name VALUE , hr_general.start_of_time START_DATE , hr_general.end_of_time END_DATE , ast.business_group_id BUSINESS_GROUP_ID , CASE WHEN ( 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 hr_assignment_sets ast UNION ALL SELECT -1 ID , '' VALUE , hr_general.start_of_time START_DATE , hr_general.end_of_time END_DATE , -1 BUSINESS_GROUP_ID , 'Y' BG_SECURITY_FLAG_CODE FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT AST.ASSIGNMENT_SET_ID ID
, AST.ASSIGNMENT_SET_NAME VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, AST.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CASE WHEN ( 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 HR_ASSIGNMENT_SETS AST UNION ALL SELECT -1 ID
, '' VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, -1 BUSINESS_GROUP_ID
, 'Y' BG_SECURITY_FLAG_CODE
FROM DUAL WITH READ ONLY