View: IGS_PE_PRIV_LEVEL_V

Product:	IGS - Student System
Description:	Stores Person's Privacy Level
Implementation/DBA Data:	APPS.IGS_PE_PRIV_LEVEL_V

View Text

SELECT PL.ROWID ROW_ID
, PL.PRIVACY_LEVEL_ID
, PL.PERSON_ID
, PE.PERSON_NUMBER
, PL.DATA_GROUP_ID
, DG.DATA_GROUP
, DG.LVL
, PL.ACTION
, LK1.MEANING ACTION_MEANING
, PL.WHOM
, LK2.MEANING WHOM_MEANING
, PL.REF_NOTES_ID
, PL.START_DATE
, PL.END_DATE
, PL.CREATED_BY
, PL.CREATION_DATE
, PL.LAST_UPDATED_BY
, PL.LAST_UPDATE_DATE
, PL.LAST_UPDATE_LOGIN
FROM IGS_PE_PRIV_LEVEL PL
, IGS_PE_DATA_GROUPS DG
, IGS_LOOKUP_VALUES LK1
, FND_LOOKUP_VALUES LK2
, IGS_PE_PERSON_BASE_V PE
WHERE PL.DATA_GROUP_ID = DG.DATA_GROUP_ID
AND PL.PERSON_ID=PE.PERSON_ID
AND PL.ACTION = LK1.LOOKUP_CODE
AND LK1.LOOKUP_TYPE = 'PERSON_PRIVACY_ACTION'
AND PL.WHOM = LK2.LOOKUP_CODE
AND LK2.LOOKUP_TYPE = 'PARTY_RELATIONS_TYPE'
AND LK2.LANGUAGE= USERENV ('LANG')
AND LK2.VIEW_APPLICATION_ID = 222
AND LK2.SECURITY_GROUP_ID = 0 UNION ALL SELECT PL.ROWID ROW_ID
, PL.PRIVACY_LEVEL_ID
, PL.PERSON_ID
, PE.PERSON_NUMBER
, PL.DATA_GROUP_ID
, DG.DATA_GROUP
, DG.LVL
, PL.ACTION
, LK1.MEANING ACTION_MEANING
, PL.WHOM
, LK2.MEANING WHOM_MEANING
, PL.REF_NOTES_ID
, PL.START_DATE
, PL.END_DATE
, PL.CREATED_BY
, PL.CREATION_DATE
, PL.LAST_UPDATED_BY
, PL.LAST_UPDATE_DATE
, PL.LAST_UPDATE_LOGIN
FROM IGS_PE_PRIV_LEVEL PL
, IGS_PE_DATA_GROUPS DG
, IGS_LOOKUP_VALUES LK1
, FND_LOOKUP_VALUES LK2
, IGS_PE_PERSON_BASE_V PE
WHERE PL.DATA_GROUP_ID = DG.DATA_GROUP_ID
AND PL.PERSON_ID= PE.PERSON_ID
AND PL.ACTION = LK1.LOOKUP_CODE
AND LK1.LOOKUP_TYPE = 'PERSON_PRIVACY_ACTION'
AND PL.WHOM = LK2.LOOKUP_CODE
AND LK2.LOOKUP_TYPE = 'PERSON_PRIVACY_RELEASE'
AND LK2.LANGUAGE= USERENV ('LANG')
AND LK2.VIEW_APPLICATION_ID = 8405
AND LK2.SECURITY_GROUP_ID = 0

Columns