View: PAYBV_COST_ALLOCATIONS_F_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAYBV_COST_ALLOCATIONS_F_V

View Text

SELECT CA.PROPORTION
, CA.EFFECTIVE_START_DATE
, CA.EFFECTIVE_END_DATE
, CA.BUSINESS_GROUP_ID
, CA.COST_ALLOCATION_ID
, CA.COST_ALLOCATION_KEYFLEX_ID
, CA.ASSIGNMENT_ID
, REQUEST_ID
, CA.PROGRAM_APPLICATION_ID
, CA.PROGRAM_ID
, CA.PROGRAM_UPDATE_DATE
, CA.LAST_UPDATE_DATE
, CA.LAST_UPDATED_BY
, CA.LAST_UPDATE_LOGIN
, CA.CREATED_BY
, CA.CREATION_DATE
, CA.OBJECT_VERSION_NUMBER
, CASE WHEN (CA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, CA.BUSINESS_GROUP_ID)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PAY_COST_ALLOCATIONS_F CA WITH READ ONLY

Columns