View: PER_SEC_PROFILE_ASSIGNMENTS_V

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

View Text

SELECT F1.USER_ID
, F1.RESPONSIBILITY_ID
, F1.RESPONSIBILITY_APPLICATION_ID
, F1.SECURITY_GROUP_ID
, P3.START_DATE
, FND_DATE.CANONICAL_TO_DATE(DECODE(FND_DATE.DATE_TO_CANONICAL(P3.END_DATE)
, '4712/12/31 00:00:00'
, NULL
, FND_DATE.DATE_TO_CANONICAL(P3.END_DATE))) END_DATE
, F2.USER_NAME
, F3.RESPONSIBILITY_NAME
, P1.FULL_NAME
, DECODE(P1.CURRENT_EMPLOYEE_FLAG
, 'Y'
, '*'
, 'Y'
, '*'
, '') CURRENT_EMPLOYEE
, P1.CURRENT_EMPLOYEE_FLAG
, P1.PERSON_ID EMPLOYEE_ID
, P3.BUSINESS_GROUP_ID
, HR_GENERAL.DECODE_ORGANIZATION(P3.BUSINESS_GROUP_ID)
, P3.OBJECT_VERSION_NUMBER
, P4.SECURITY_PROFILE_NAME
, F4.APPLICATION_NAME
, P4.SECURITY_PROFILE_ID
, P1.EMPLOYEE_NUMBER
, P3.SEC_PROFILE_ASSIGNMENT_ID
FROM FND_USER_RESP_GROUPS_DIRECT F1
, FND_USER F2
, FND_RESPONSIBILITY_VL F3
, FND_APPLICATION_VL F4
, PER_ALL_PEOPLE_F P1
, PER_SEC_PROFILE_ASSIGNMENTS P3
, PER_SECURITY_PROFILES P4
WHERE F1.SECURITY_GROUP_ID = P3.SECURITY_GROUP_ID (+)
AND F3.APPLICATION_ID = F4.APPLICATION_ID
AND F1.USER_ID = F2.USER_ID (+)
AND F1.USER_ID = P3.USER_ID (+)
AND (F1.RESPONSIBILITY_ID = F3.RESPONSIBILITY_ID
AND F1.RESPONSIBILITY_APPLICATION_ID = F3.APPLICATION_ID)
AND F1.RESPONSIBILITY_ID = P3.RESPONSIBILITY_ID (+)
AND F1.RESPONSIBILITY_APPLICATION_ID = P3.RESPONSIBILITY_APPLICATION_ID (+)
AND F2.EMPLOYEE_ID = P1.PERSON_ID (+)
AND P4.SECURITY_PROFILE_ID (+) = P3.SECURITY_PROFILE_ID
AND TRUNC(SYSDATE) BETWEEN P1.EFFECTIVE_START_DATE (+)
AND P1.EFFECTIVE_END_DATE (+)

Columns