VIEW: APPS.HRBV_COLLECTIVE_AGREEMENTS_V

Source

View Text - Preformatted

SELECT CAG.NAME, CAG.CAG_NUMBER, CAG.DESCRIPTION, CAG.START_DATE, CAG.END_DATE, CAG.EMPLOYER_SIGNATORY, CAG.BARGAINING_UNIT_SIGNATORY, CAG.JURISDICTION, CAG.AUTHORIZING_BODY, CAG.AUTHORIZED_DATE, CAG.CAG_INFORMATION_CATEGORY, CAG.CAG_INFORMATION1, CAG.CAG_INFORMATION2, CAG.CAG_INFORMATION3, CAG.CAG_INFORMATION4, CAG.CAG_INFORMATION5, CAG.CAG_INFORMATION6, CAG.CAG_INFORMATION7, CAG.CAG_INFORMATION8, CAG.CAG_INFORMATION9, CAG.CAG_INFORMATION10, CAG.CAG_INFORMATION11, CAG.CAG_INFORMATION12, CAG.CAG_INFORMATION13, CAG.CAG_INFORMATION14, CAG.CAG_INFORMATION15, CAG.CAG_INFORMATION16, CAG.CAG_INFORMATION17, CAG.CAG_INFORMATION18, CAG.CAG_INFORMATION19, CAG.CAG_INFORMATION20, CAG.STATUS, HR_BIS.BIS_DECODE_LOOKUP('CAGR_STATUS',CAG.STATUS), '_DF:PER:PER_COLLECTIVE_AGREEMENTS:CAG', CAG.COLLECTIVE_AGREEMENT_ID, CAG.EMPLOYER_ORGANIZATION_ID, CAG.BARGAINING_ORGANIZATION_ID, CAG.BUSINESS_GROUP_ID, CAG.PL_ID, CAG.LAST_UPDATE_DATE, CAG.LAST_UPDATED_BY, CAG.CREATED_BY, CAG.CREATION_DATE, CASE WHEN CAG.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, CAG.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_COLLECTIVE_AGREEMENTS CAG WITH READ ONLY

View Text - HTML Formatted

SELECT CAG.NAME
, CAG.CAG_NUMBER
, CAG.DESCRIPTION
, CAG.START_DATE
, CAG.END_DATE
, CAG.EMPLOYER_SIGNATORY
, CAG.BARGAINING_UNIT_SIGNATORY
, CAG.JURISDICTION
, CAG.AUTHORIZING_BODY
, CAG.AUTHORIZED_DATE
, CAG.CAG_INFORMATION_CATEGORY
, CAG.CAG_INFORMATION1
, CAG.CAG_INFORMATION2
, CAG.CAG_INFORMATION3
, CAG.CAG_INFORMATION4
, CAG.CAG_INFORMATION5
, CAG.CAG_INFORMATION6
, CAG.CAG_INFORMATION7
, CAG.CAG_INFORMATION8
, CAG.CAG_INFORMATION9
, CAG.CAG_INFORMATION10
, CAG.CAG_INFORMATION11
, CAG.CAG_INFORMATION12
, CAG.CAG_INFORMATION13
, CAG.CAG_INFORMATION14
, CAG.CAG_INFORMATION15
, CAG.CAG_INFORMATION16
, CAG.CAG_INFORMATION17
, CAG.CAG_INFORMATION18
, CAG.CAG_INFORMATION19
, CAG.CAG_INFORMATION20
, CAG.STATUS
, HR_BIS.BIS_DECODE_LOOKUP('CAGR_STATUS'
, CAG.STATUS)
, '_DF:PER:PER_COLLECTIVE_AGREEMENTS:CAG'
, CAG.COLLECTIVE_AGREEMENT_ID
, CAG.EMPLOYER_ORGANIZATION_ID
, CAG.BARGAINING_ORGANIZATION_ID
, CAG.BUSINESS_GROUP_ID
, CAG.PL_ID
, CAG.LAST_UPDATE_DATE
, CAG.LAST_UPDATED_BY
, CAG.CREATED_BY
, CAG.CREATION_DATE
, CASE WHEN CAG.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, CAG.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_COLLECTIVE_AGREEMENTS CAG WITH READ ONLY