View: PAY_COST_ALLOCATIONS_V

Product:	PAY - Payroll
Description:	View of cost allocations for the effective date with concatenated segments from the cost allocation keyflex.
Implementation/DBA Data:	APPS.PAY_COST_ALLOCATIONS_V

View Text

SELECT PAY.ROWID ROW_ID
, PAY.COST_ALLOCATION_ID
, PAY.EFFECTIVE_START_DATE
, PAY.EFFECTIVE_END_DATE
, PAY.BUSINESS_GROUP_ID
, PAY.COST_ALLOCATION_KEYFLEX_ID
, PAY.ASSIGNMENT_ID
, PAY.PROPORTION
, PAY.REQUEST_ID
, PAY.PROGRAM_APPLICATION_ID
, PAY.PROGRAM_ID
, PAY.PROGRAM_UPDATE_DATE
, PAY.LAST_UPDATE_DATE
, PAY.LAST_UPDATED_BY
, PAY.LAST_UPDATE_LOGIN
, PAY.CREATED_BY
, PAY.CREATION_DATE
, PCAF.CONCATENATED_SEGMENTS
, PAY.OBJECT_VERSION_NUMBER
FROM FND_SESSIONS FND
, PAY_COST_ALLOCATION_KEYFLEX PCAF
, PAY_COST_ALLOCATIONS_F PAY
WHERE PCAF.COST_ALLOCATION_KEYFLEX_ID (+) = PAY.COST_ALLOCATION_KEYFLEX_ID
AND FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN PAY.EFFECTIVE_START_DATE
AND PAY.EFFECTIVE_END_DATE

Columns