SQL Query to fetch Costing of Payroll information

We can access the task using Costing of Payroll.

SQL Query to pull Costing of Payroll:

SELECT pcaf.SOURCE_TYPE AS SOURCE_TYPE
	,pcaf.SOURCE_ID AS SOURCE_ID
	,pcaf.EFFECTIVE_START_DATE AS EFFECTIVE_START_DATE
	,pcaf.EFFECTIVE_END_DATE AS EFFECTIVE_END_DATE
	,pcaa.SEGMENT1 AS SEGMENT1
	,pcaa.SEGMENT2 AS SEGMENT2
	,pcaa.SEGMENT3 AS SEGMENT3
	,pcaa.SEGMENT4 AS SEGMENT4
	,pcaa.SEGMENT5 AS SEGMENT5
	,pcaa.SEGMENT6 AS SEGMENT6
	,pcaa.SEGMENT7 AS SEGMENT7
	,pcaf.CREATOR_ID AS CREATOR_ID
	,pcaa.SOURCE_SUB_TYPE AS SOURCE_SUB_TYPE
	,pcaa.PROPORTION AS PROPORTION
	,pcaa.SUB_TYPE_SEQUENCE AS SUB_TYPE_SEQUENCE
	,pcaf.HISTORY_COMMENTS AS HISTORY_COMMENTS
	,pcaf.CREATED_BY AS CREATED_BY
	,PAY_ALL_PAYROLLS_F.PAYROLL_NAME AS PAYROLL_NAME
FROM FUSION.PAY_ALL_PAYROLLS_F PAY_ALL_PAYROLLS_F
	,FUSION.pcaa pcaa
	,FUSION.pcaf pcaf
WHERE pcaf.COST_ALLOCATION_RECORD_ID = pcaa.COST_ALLOCATION_RECORD_ID
	AND pcaf.SOURCE_ID = PAY_ALL_PAYROLLS_F.PAYROLL_ID
	AND pcaf.source_type = 'PAY'
	AND sysdate BETWEEN pcaf.EFFECTIVE_START_DATE AND pcaf.EFFECTIVE_END_DATE