VIEW: APPS.BEN_PL_EXTRACT_IDENTIFIER_V

Source

View Text - Preformatted

SELECT PEI.ROWID , 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, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('sessionid') AND SE.EFFECTIVE_DATE BETWEEN PEI.EFFECTIVE_START_DATE AND PEI.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT PEI.ROWID
, 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
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN PEI.EFFECTIVE_START_DATE
AND PEI.EFFECTIVE_END_DATE