View: PER_POSITIONS_LOV_V2

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

View Text

SELECT P2.NAME
, P1.POSITION_ID
, P1.ORGANIZATION_ID
, P1.JOB_ID
, P1.BUSINESS_GROUP_ID
FROM HR_POSITIONS_F P1
, HR_ALL_POSITIONS_F P2
, PER_SHARED_TYPES PST
, FND_SESSIONS S
WHERE S.EFFECTIVE_DATE BETWEEN P1.EFFECTIVE_START_DATE
AND P1.EFFECTIVE_END_DATE
AND HR_GENERAL.END_OF_TIME BETWEEN P2.EFFECTIVE_START_DATE
AND P2.EFFECTIVE_END_DATE
AND P1.POSITION_ID = P2.POSITION_ID
AND (P1.STATUS = 'VALID' OR P1.STATUS IS NULL)
AND S.SESSION_ID = USERENV('SESSIONID')
AND PST.SHARED_TYPE_ID = P1.AVAILABILITY_STATUS_ID
AND PST.LOOKUP_TYPE = 'POSITION_AVAILABILITY_STATUS'
AND (PST.BUSINESS_GROUP_ID = P1.BUSINESS_GROUP_ID OR PST.BUSINESS_GROUP_ID IS NULL)
AND SYSTEM_TYPE_CD = 'ACTIVE'

Columns