View: PAY_ALL_PAYROLLS_D

Product:	PAY - Payroll
Description:	Used by DateTrack History
Implementation/DBA Data:	APPS.PAY_ALL_PAYROLLS_D

View Text

SELECT PAYROLL.PAYROLL_ID
, PAYROLL.EFFECTIVE_START_DATE
, PAYROLL.EFFECTIVE_END_DATE
, CSET.CONSOLIDATION_SET_NAME
, SCL.CONCATENATED_SEGMENTS
, PAYROLL.PERIOD_TYPE
, PAYROLL.CUT_OFF_DATE_OFFSET
, PAYROLL.DIRECT_DEPOSIT_DATE_OFFSET
, PAYROLL.FIRST_PERIOD_END_DATE
, PAYROLL.MIDPOINT_OFFSET
, FND1.MEANING
, PAYROLL.ARREARS_FLAG
, PAYROLL.MULTI_ASSIGNMENTS_FLAG
, PAYROLL.PAY_ADVICE_DATE_OFFSET
, PAYROLL.PAY_DATE_OFFSET
, PAYROLL.PAYROLL_NAME
, HR1.MEANING
, METHODTL.ORG_PAYMENT_METHOD_NAME
, ORGTL.NAME
, CFLX.CONCATENATED_SEGMENTS
, SFLX.CONCATENATED_SEGMENTS
, PAYROLL.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM PAY_PAYROLLS_F PAYROLL
, PAY_CONSOLIDATION_SETS CSET
, HR_SOFT_CODING_KEYFLEX SCL
, PAY_ORG_PAYMENT_METHODS_F_TL METHODTL
, PAY_ORG_PAYMENT_METHODS_F METHOD
, HR_ALL_ORGANIZATION_UNITS_TL ORGTL
, HR_ALL_ORGANIZATION_UNITS ORG
, PAY_COST_ALLOCATION_KEYFLEX CFLX
, PAY_COST_ALLOCATION_KEYFLEX SFLX
, HR_LOOKUPS HR1
, FND_LOOKUPS FND1
, FND_USER FUSER
WHERE METHOD.ORG_PAYMENT_METHOD_ID = METHODTL.ORG_PAYMENT_METHOD_ID (+)
AND DECODE(METHODTL.ORG_PAYMENT_METHOD_ID
, NULL
, '1'
, METHODTL.LANGUAGE) = DECODE(METHODTL.ORG_PAYMENT_METHOD_ID
, NULL
, '1'
, USERENV('LANG'))
AND ORG.ORGANIZATION_ID = ORGTL.ORGANIZATION_ID (+)
AND DECODE(ORGTL.ORGANIZATION_ID
, NULL
, '1'
, ORGTL.LANGUAGE) = DECODE(ORGTL.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND CSET.CONSOLIDATION_SET_ID = PAYROLL.CONSOLIDATION_SET_ID
AND SCL.SOFT_CODING_KEYFLEX_ID (+)= PAYROLL.SOFT_CODING_KEYFLEX_ID
AND METHOD.ORG_PAYMENT_METHOD_ID (+)= PAYROLL.DEFAULT_PAYMENT_METHOD_ID
AND PAYROLL.EFFECTIVE_START_DATE BETWEEN NVL (METHOD.EFFECTIVE_START_DATE
, PAYROLL.EFFECTIVE_START_DATE)
AND NVL (METHOD.EFFECTIVE_END_DATE
, PAYROLL.EFFECTIVE_START_DATE)
AND ORG.ORGANIZATION_ID (+)= PAYROLL.ORGANIZATION_ID
AND CFLX.COST_ALLOCATION_KEYFLEX_ID (+)= PAYROLL.COST_ALLOCATION_KEYFLEX_ID
AND SFLX.COST_ALLOCATION_KEYFLEX_ID (+)= PAYROLL.SUSPENSE_ACCOUNT_KEYFLEX_ID
AND HR1.LOOKUP_CODE = PAYROLL.WORKLOAD_SHIFTING_LEVEL
AND HR1.LOOKUP_TYPE = 'WORKLOAD_SHIFTING_LEVEL'
AND FND1.LOOKUP_CODE = PAYROLL.NEGATIVE_PAY_ALLOWED_FLAG
AND FND1.LOOKUP_TYPE = 'YES_NO'
AND FUSER.USER_ID (+)= PAYROLL.LAST_UPDATED_BY

Columns