VIEW: APPS.HRI_CL_TRNACT_ACTDEF_V

Source

View Text - Preformatted

SELECT act.activity_id ID , act.name VALUE , hr_general.start_of_time start_date , hr_general.end_of_time end_date , act.business_group_id business_group_id , CASE WHEN ( act.business_group_id IS NULL OR act.business_group_id = NVL( ota_general.get_business_group_id , act.business_group_id ) ) THEN 'Y' ELSE 'N' END bg_security_flag_code , act.comments comments , act.description description , act.multiple_con_versions_flag multiple_con_versions_flag FROM ota_activity_definitions act 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 , '' comments , '' description , '' multiple_con_versions_flag FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT ACT.ACTIVITY_ID ID
, ACT.NAME VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, ACT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CASE WHEN ( ACT.BUSINESS_GROUP_ID IS NULL OR ACT.BUSINESS_GROUP_ID = NVL( OTA_GENERAL.GET_BUSINESS_GROUP_ID
, ACT.BUSINESS_GROUP_ID ) ) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
, ACT.COMMENTS COMMENTS
, ACT.DESCRIPTION DESCRIPTION
, ACT.MULTIPLE_CON_VERSIONS_FLAG MULTIPLE_CON_VERSIONS_FLAG
FROM OTA_ACTIVITY_DEFINITIONS ACT 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
, '' COMMENTS
, '' DESCRIPTION
, '' MULTIPLE_CON_VERSIONS_FLAG
FROM DUAL WITH READ ONLY