VIEW: APPS.PAY_ALL_PAYROLLS_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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