View: PER_SECURITY_PROFILES_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_SECURITY_PROFILES_V

View Text

SELECT PSP.ROWID ROW_ID
, PSP.SECURITY_PROFILE_ID
, PSP.BUSINESS_GROUP_ID
, PBG.NAME BUSINESS_GROUP_NAME
, PSP.POSITION_ID
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(PSP.POSITION_ID) TOP_POSITION
, PSP.ORGANIZATION_ID
, ORGTL.NAME TOP_ORGANIZATION
, PSP.POSITION_STRUCTURE_ID
, PPS.NAME POSITION_HIERARCHY
, PSV.POS_STRUCTURE_VERSION_ID
, PSP.ORGANIZATION_STRUCTURE_ID
, OST.NAME ORGANIZATION_HIERARCHY
, OSV.ORG_STRUCTURE_VERSION_ID
, PSP.INCLUDE_TOP_ORGANIZATION_FLAG
, PSP.INCLUDE_TOP_POSITION_FLAG
, PSP.SECURITY_PROFILE_NAME
, PSP.VIEW_ALL_APPLICANTS_FLAG
, PSP.VIEW_ALL_EMPLOYEES_FLAG
, PSP.VIEW_ALL_CWK_FLAG
, PSP.VIEW_ALL_CONTACTS_FLAG
, PSP.VIEW_ALL_CANDIDATES_FLAG
, PSP.VIEW_ALL_FLAG
, PSP.VIEW_ALL_ORGANIZATIONS_FLAG
, PSP.VIEW_ALL_PAYROLLS_FLAG
, PSP.VIEW_ALL_POSITIONS_FLAG
, PSP.INCLUDE_EXCLUDE_PAYROLL_FLAG
, PSP.REPORTING_ORACLE_USERNAME
, PSP.ALLOW_GRANTED_USERS_FLAG
, PSP.RESTRICT_BY_SUPERVISOR_FLAG
, PSP.SUPERVISOR_LEVELS
, PSP.EXCLUDE_SECONDARY_ASGS_FLAG
, PSP.EXCLUDE_PERSON_FLAG
, PER.FULL_NAME
, PSP.NAMED_PERSON_ID
, PSP.CUSTOM_RESTRICTION_FLAG
, PSP.RESTRICTION_TEXT
, PSP.EXCLUDE_BUSINESS_GROUPS_FLAG
, PSP.REQUEST_ID
, PSP.PROGRAM_APPLICATION_ID
, PSP.PROGRAM_ID
, PSP.PROGRAM_UPDATE_DATE
, PSP.LAST_UPDATE_DATE
, PSP.LAST_UPDATED_BY
, PSP.LAST_UPDATE_LOGIN
, PSP.CREATED_BY
, PSP.CREATION_DATE
, PSP.ORG_SECURITY_MODE
, PSP.RESTRICT_ON_INDIVIDUAL_ASG
, PSP.TOP_ORGANIZATION_METHOD
, PSP.TOP_POSITION_METHOD
FROM PER_SECURITY_PROFILES PSP
, PER_ALL_PEOPLE_F PER
, PER_BUSINESS_GROUPS_PERF PBG
, PER_ORGANIZATION_STRUCTURES OST
, PER_ORG_STRUCTURE_VERSIONS OSV
, PER_POSITION_STRUCTURES PPS
, PER_POS_STRUCTURE_VERSIONS PSV
, HR_ALL_ORGANIZATION_UNITS ORG
, HR_ALL_ORGANIZATION_UNITS_TL ORGTL
WHERE PSP.BUSINESS_GROUP_ID + 0 = PBG.BUSINESS_GROUP_ID (+)
AND PSP.ORGANIZATION_STRUCTURE_ID = OST.ORGANIZATION_STRUCTURE_ID (+)
AND PSP.ORGANIZATION_STRUCTURE_ID = OSV.ORGANIZATION_STRUCTURE_ID (+)
AND SYSDATE BETWEEN OSV.DATE_FROM (+)
AND NVL(OSV.DATE_TO (+)
, TO_DATE('4712/12/31'
, 'YYYY/MM/DD'))
AND PSP.POSITION_STRUCTURE_ID = PPS.POSITION_STRUCTURE_ID (+)
AND PSP.POSITION_STRUCTURE_ID = PSV.POSITION_STRUCTURE_ID (+)
AND SYSDATE BETWEEN PSV.DATE_FROM (+)
AND NVL(PSV.DATE_TO (+)
, TO_DATE('4712/12/31'
, 'YYYY//MM/DD'))
AND PSP.ORGANIZATION_ID = ORG.ORGANIZATION_ID (+)
AND ORG.ORGANIZATION_ID = ORGTL.ORGANIZATION_ID (+)
AND DECODE(ORGTL.ORGANIZATION_ID
, NULL
, '1'
, ORGTL.LANGUAGE) = DECODE(ORGTL.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND PSP.NAMED_PERSON_ID=PER.PERSON_ID(+)
AND SYSDATE BETWEEN PER.EFFECTIVE_START_DATE (+)
AND NVL(PER.EFFECTIVE_END_DATE (+)
, TO_DATE('4712/12/31'
, 'YYYY//MM/DD'))

Columns