View: PER_COLLECTIVE_AGREEMENTS_V

Product:	PER - Human Resources
Description:	PER_COLLECTIVE_AGREEMENTS_V lists the information about Collective Agreements which may be negotiated between Employers and Bargaining Units
Implementation/DBA Data:	APPS.PER_COLLECTIVE_AGREEMENTS_V

View Text

SELECT PCA.ROWID
, PCA.COLLECTIVE_AGREEMENT_ID
, PCA.BUSINESS_GROUP_ID
, PCA.OBJECT_VERSION_NUMBER
, PCA.NAME
, PCA.CAG_NUMBER
, PCA.DESCRIPTION
, PCA.START_DATE
, PCA.END_DATE
, PCA.EMPLOYER_ORGANIZATION_ID
, HR1.NAME
, PCA.EMPLOYER_SIGNATORY
, PCA.BARGAINING_ORGANIZATION_ID
, HR2.NAME
, PCA.BARGAINING_UNIT_SIGNATORY
, PCA.JURISDICTION
, PCA.AUTHORIZING_BODY
, PCA.AUTHORIZED_DATE
, PCA.STATUS
, PCA.CAG_INFORMATION_CATEGORY
, PCA.CAG_INFORMATION1
, PCA.CAG_INFORMATION2
, PCA.CAG_INFORMATION3
, PCA.CAG_INFORMATION4
, PCA.CAG_INFORMATION5
, PCA.CAG_INFORMATION6
, PCA.CAG_INFORMATION7
, PCA.CAG_INFORMATION8
, PCA.CAG_INFORMATION9
, PCA.CAG_INFORMATION10
, PCA.CAG_INFORMATION11
, PCA.CAG_INFORMATION12
, PCA.CAG_INFORMATION13
, PCA.CAG_INFORMATION14
, PCA.CAG_INFORMATION15
, PCA.CAG_INFORMATION16
, PCA.CAG_INFORMATION17
, PCA.CAG_INFORMATION18
, PCA.CAG_INFORMATION19
, PCA.CAG_INFORMATION20
, PCA.ATTRIBUTE_CATEGORY
, PCA.ATTRIBUTE1
, PCA.ATTRIBUTE2
, PCA.ATTRIBUTE3
, PCA.ATTRIBUTE4
, PCA.ATTRIBUTE5
, PCA.ATTRIBUTE6
, PCA.ATTRIBUTE7
, PCA.ATTRIBUTE8
, PCA.ATTRIBUTE9
, PCA.ATTRIBUTE10
, PCA.ATTRIBUTE11
, PCA.ATTRIBUTE12
, PCA.ATTRIBUTE13
, PCA.ATTRIBUTE14
, PCA.ATTRIBUTE15
, PCA.ATTRIBUTE16
, PCA.ATTRIBUTE17
, PCA.ATTRIBUTE18
, PCA.ATTRIBUTE19
, PCA.ATTRIBUTE20
, PCA.LAST_UPDATE_DATE
, PCA.LAST_UPDATED_BY
, PCA.LAST_UPDATE_LOGIN
, PCA.CREATED_BY
, PCA.CREATION_DATE
FROM PER_COLLECTIVE_AGREEMENTS PCA
, HR_ORGANIZATION_UNITS HR1
, HR_ORGANIZATION_UNITS HR2
WHERE (HR1.ORGANIZATION_ID (+) = PCA.EMPLOYER_ORGANIZATION_ID
AND HR2.ORGANIZATION_ID (+) = PCA.BARGAINING_ORGANIZATION_ID)
AND PCA.START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns