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'
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'
|
|
|