View: PER_POSITION_STRUCTURES_LOV

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

View Text

SELECT PS.POSITION_STRUCTURE_ID
, PS.PRIMARY_POSITION_FLAG
, PS.BUSINESS_GROUP_ID
, MEANING
, PS.NAME
, PSV.POS_STRUCTURE_VERSION_ID
, PSV.DATE_FROM
, NVL(PSV.DATE_TO
, TO_DATE('31-12-4712'
, 'DD-MM-YYYY')) DATE_TO
FROM PER_POSITION_STRUCTURES PS
, PER_POS_STRUCTURE_VERSIONS PSV
, FND_LOOKUPS FL
WHERE PS.POSITION_STRUCTURE_ID = PSV.POSITION_STRUCTURE_ID
AND PS.PRIMARY_POSITION_FLAG = FL.LOOKUP_CODE
AND FL.LOOKUP_TYPE = 'YES_NO'

Columns