VIEW: APPS.HRI_CL_COL_AGRMNTS_B_V

Source

View Text - Preformatted

SELECT agr.collective_agreement_id ID , agr.name VALUE , Agr.Start_Date START_DATE , nvl(agr.end_date, hr_general.end_of_time) END_DATE , CASE WHEN ( NVL(agr.business_group_id, -1) = NVL(NVL(hr_bis.get_sec_profile_bg_id, agr.business_group_id),-1) ) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE , agr.business_group_id BUSINESS_GROUP_ID FROM per_collective_agreements agr UNION ALL SELECT -1 ID , '' VALUE , hr_general.start_of_time START_DATE , hr_general.end_of_time END_DATE , 'Y' BG_SECURITY_FLAG_CODE , to_number(NULL) BUSINESS_GROUP_ID FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT AGR.COLLECTIVE_AGREEMENT_ID ID
, AGR.NAME VALUE
, AGR.START_DATE START_DATE
, NVL(AGR.END_DATE
, HR_GENERAL.END_OF_TIME) END_DATE
, CASE WHEN ( NVL(AGR.BUSINESS_GROUP_ID
, -1) = NVL(NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, AGR.BUSINESS_GROUP_ID)
, -1) ) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
, AGR.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM PER_COLLECTIVE_AGREEMENTS AGR UNION ALL SELECT -1 ID
, '' VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, 'Y' BG_SECURITY_FLAG_CODE
, TO_NUMBER(NULL) BUSINESS_GROUP_ID
FROM DUAL WITH READ ONLY