Product: | BEN - Advanced Benefits |
---|---|
Description: | This view displays records from BEN_PL_EXTRACT_IDENTIFIER_F as of session date of the user. |
Implementation/DBA Data: | APPS.BEN_PL_EXTRACT_IDENTIFIER |
SELECT PEI.PL_EXTRACT_IDENTIFIER_ID
, PEI.PL_ID
, PEI.PLIP_ID
, PEI.OIPL_ID
, PEI.THIRD_PARTY_IDENTIFIER
, PEI.ORGANIZATION_ID
, PEI.JOB_ID
, PEI.POSITION_ID
, PEI.PEOPLE_GROUP_ID
, PEI.GRADE_ID
, PEI.PAYROLL_ID
, PEI.HOME_STATE
, PEI.HOME_ZIP
, PEI.EFFECTIVE_START_DATE
, PEI.EFFECTIVE_END_DATE
, PEI.CREATED_BY
, PEI.CREATION_DATE
, PEI.LAST_UPDATE_DATE
, PEI.LAST_UPDATED_BY
, PEI.LAST_UPDATE_LOGIN
, PEI.OBJECT_VERSION_NUMBER
, PEI.BUSINESS_GROUP_ID
FROM BEN_PL_EXTRACT_IDENTIFIER_F PEI
WHERE PEI.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID') )
AND PEI.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID') )