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