View: PAY_US_SRS_RETRY_ROLLBACK_V

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

View Text

SELECT PPA.PAYROLL_ACTION_ID
, PPA.ACTION_SEQUENCE
, PPA.EFFECTIVE_DATE
, PPA.START_DATE
, PPA.ACTION_TYPE
, HR_GENERAL.DECODE_FND_COMM_LOOKUP('ACTION_TYPE'
, PPA.ACTION_TYPE) || DECODE(PPA.ACTION_TYPE
, 'X'
, DECODE(PPA.REPORT_TYPE
, 'YREND'
, '-'
, DECODE(PPA.REPORT_CATEGORY
, NULL
, NULL
, '-' || HR_GENERAL.DECODE_FND_COMM_LOOKUP( PPA.REPORT_QUALIFIER||'_'|| PPA.REPORT_TYPE||'_MEDIA_TYPE'
, PPA.REPORT_CATEGORY)))
, NULL)
, DECODE(PPA.REPORT_TYPE
, 'XFR_INTERFACE'
, HR_GENERAL.DECODE_PAYROLL(TO_NUMBER( PAY_MAG_UTILS.GET_PARAMETER( 'TRANSFER_PAYROLL_ID'
, 'TRANSFER_CONSOLIDATION_SET_ID'
, PPA.LEGISLATIVE_PARAMETERS)))
, 'FLS'
, HR_GENERAL.DECODE_PAYROLL(TO_NUMBER( DECODE(LTRIM(RTRIM(PAY_MAG_UTILS.GET_PARAMETER( 'TRANSFER_PAYROLL_ID'
, 'TRANSFER_CONSOLIDATION_SET_ID'
, PPA.LEGISLATIVE_PARAMETERS)))
, NULL
, '-1'
, PAY_MAG_UTILS.GET_PARAMETER( 'TRANSFER_PAYROLL_ID'
, 'TRANSFER_CONSOLIDATION_SET_ID'
, PPA.LEGISLATIVE_PARAMETERS))))
, HR_GENERAL.DECODE_PAYROLL(PPA.PAYROLL_ID)) "PAYROLL"
, DECODE(REPORT_TYPE
, 'YREND'
, HR_GENERAL.DECODE_ORGANIZATION( TO_NUMBER( PAY_MAG_UTILS.GET_PARAMETER( 'TRANSFER_GRE'
, NULL
, PPA.LEGISLATIVE_PARAMETERS)))
, 'W2C_PRE_PROCESS'
, HR_GENERAL.DECODE_ORGANIZATION(TO_NUMBER( LTRIM(RTRIM(SUBSTR(PPA.LEGISLATIVE_PARAMETERS
, INSTR(PPA.LEGISLATIVE_PARAMETERS
, 'TRANSFER_GRE=')+LENGTH('TRANSFER_GRE=')
, INSTR(SUBSTR(PPA.LEGISLATIVE_PARAMETERS
, INSTR(PPA.LEGISLATIVE_PARAMETERS
, 'TRANSFER_GRE='))
, ' ') - LENGTH('TRANSFER_GRE='))))))
, 'W-2C PAPER'
, HR_GENERAL.DECODE_ORGANIZATION(TO_NUMBER( LTRIM(RTRIM(SUBSTR(PPA.LEGISLATIVE_PARAMETERS
, INSTR(PPA.LEGISLATIVE_PARAMETERS
, 'TRANSFER_GRE=')+LENGTH('TRANSFER_GRE=')
, INSTR(SUBSTR(PPA.LEGISLATIVE_PARAMETERS
, INSTR(PPA.LEGISLATIVE_PARAMETERS
, 'TRANSFER_GRE='))
, ' ') - LENGTH('TRANSFER_GRE='))))))
, '1099R'
, HR_GENERAL.DECODE_ORGANIZATION( TO_NUMBER( PAY_MAG_UTILS.GET_PARAMETER( 'TRANSFER_TRANS_LEGAL_CO_ID'
, 'TRANSFER_ALL_PAYERS'
, PPA.LEGISLATIVE_PARAMETERS)))
, 'XFR_INTERFACE'
, HR_US_REPORTS.GET_CONSOLIDATION_SET(TO_NUMBER( PAY_MAG_UTILS.GET_PARAMETER( 'TRANSFER_CONSOLIDATION_SET_ID'
, ''
, PPA.LEGISLATIVE_PARAMETERS)))
, 'FLS'
, DECODE(HR_US_REPORTS.GET_CONSOLIDATION_SET(TO_NUMBER(DECODE(LTRIM(RTRIM( PAY_MAG_UTILS.GET_PARAMETER( 'TRANSFER_CONSOLIDATION_SET_ID'
, 'TRANSFER_TAX_UNIT_ID'
, PPA.LEGISLATIVE_PARAMETERS)))
, NULL
, '-1'
, PAY_MAG_UTILS.GET_PARAMETER( 'TRANSFER_CONSOLIDATION_SET_ID'
, 'TRANSFER_TAX_UNIT_ID'
, PPA.LEGISLATIVE_PARAMETERS))))
, NULL
, HR_GENERAL.DECODE_ORGANIZATION(TO_NUMBER( DECODE(LTRIM(RTRIM( PAY_MAG_UTILS.GET_PARAMETER( 'TRANSFER_TAX_UNIT_ID'
, ''
, PPA.LEGISLATIVE_PARAMETERS)))
, NULL
, '-1'
, PAY_MAG_UTILS.GET_PARAMETER( 'TRANSFER_TAX_UNIT_ID'
, ''
, PPA.LEGISLATIVE_PARAMETERS))))
, DECODE(HR_GENERAL.DECODE_ORGANIZATION(TO_NUMBER( DECODE(LTRIM(RTRIM( PAY_MAG_UTILS.GET_PARAMETER( 'TRANSFER_TAX_UNIT_ID'
, ''
, PPA.LEGISLATIVE_PARAMETERS)))
, NULL
, '-1'
, PAY_MAG_UTILS.GET_PARAMETER ('TRANSFER_TAX_UNIT_ID'
, ''
, PPA.LEGISLATIVE_PARAMETERS))))
, NULL
, HR_US_REPORTS.GET_CONSOLIDATION_SET(TO_NUMBER( PAY_MAG_UTILS.GET_PARAMETER( 'TRANSFER_CONSOLIDATION_SET_ID'
, 'TRANSFER_TAX_UNIT_ID'
, PPA.LEGISLATIVE_PARAMETERS)))
, HR_US_REPORTS.GET_CONSOLIDATION_SET(TO_NUMBER( DECODE(LTRIM(RTRIM(PAY_MAG_UTILS.GET_PARAMETER( 'TRANSFER_CONSOLIDATION_SET_ID'
, 'TRANSFER_TAX_UNIT_ID'
, PPA.LEGISLATIVE_PARAMETERS)))
, NULL
, -1
, PAY_MAG_UTILS.GET_PARAMETER( 'TRANSFER_CONSOLIDATION_SET_ID'
, 'TRANSFER_TAX_UNIT_ID'
, PPA.LEGISLATIVE_PARAMETERS)))) ||'/'|| HR_GENERAL.DECODE_ORGANIZATION( TO_NUMBER( DECODE(LTRIM(RTRIM( PAY_MAG_UTILS.GET_PARAMETER( 'TRANSFER_TAX_UNIT_ID'
, ''
, PPA.LEGISLATIVE_PARAMETERS)))
, NULL
, '-1'
, PAY_MAG_UTILS.GET_PARAMETER( 'TRANSFER_TAX_UNIT_ID'
, ''
, PPA.LEGISLATIVE_PARAMETERS))))))
, HR_US_REPORTS.GET_CONSOLIDATION_SET(PPA.CONSOLIDATION_SET_ID))
, PPA.REPORT_TYPE
, PPA.REPORT_CATEGORY
, PPA.REPORT_TYPE||'-'|| PPA.REPORT_QUALIFIER || DECODE(REPORT_CATEGORY
, 'RL'
, ' - LOCAL '
, '')
, PPA.ACTION_STATUS
, HR_GENERAL.DECODE_FND_COMM_LOOKUP('ACTION_STATUS'
, PPA.ACTION_STATUS)
, PPA.REQUEST_ID
, PPA.BUSINESS_GROUP_ID
, PPA.CURRENT_TASK
, PPA.PURGE_PHASE
, PPA.PAYROLL_ID
, PPA.CONSOLIDATION_SET_ID
, DECODE(REPORT_TYPE
, 'YREND'
, TO_NUMBER( PAY_MAG_UTILS.GET_PARAMETER( 'TRANSFER_GRE'
, NULL
, PPA.LEGISLATIVE_PARAMETERS))
, 'W2C_PRE_PROCESS'
, TO_NUMBER( LTRIM(RTRIM(SUBSTR(PPA.LEGISLATIVE_PARAMETERS
, INSTR(PPA.LEGISLATIVE_PARAMETERS
, 'TRANSFER_GRE=')+LENGTH('TRANSFER_GRE=')
, INSTR(SUBSTR(PPA.LEGISLATIVE_PARAMETERS
, INSTR(PPA.LEGISLATIVE_PARAMETERS
, 'TRANSFER_GRE='))
, ' ') - LENGTH('TRANSFER_GRE=')))))
, 'W-2C PAPER'
, TO_NUMBER( LTRIM(RTRIM(SUBSTR(PPA.LEGISLATIVE_PARAMETERS
, INSTR(PPA.LEGISLATIVE_PARAMETERS
, 'TRANSFER_GRE=')+LENGTH('TRANSFER_GRE=')
, INSTR(SUBSTR(PPA.LEGISLATIVE_PARAMETERS
, INSTR(PPA.LEGISLATIVE_PARAMETERS
, 'TRANSFER_GRE='))
, ' ') - LENGTH('TRANSFER_GRE=')))))
, '1099R'
, TO_NUMBER( PAY_MAG_UTILS.GET_PARAMETER( 'TRANSFER_TRANS_LEGAL_CO_ID'
, 'TRANSFER_ALL_PAYERS'
, PPA.LEGISLATIVE_PARAMETERS))
, 'FLS'
, TO_NUMBER( DECODE(LTRIM(RTRIM( PAY_MAG_UTILS.GET_PARAMETER( 'TRANSFER_TAX_UNIT_ID'
, ''
, PPA.LEGISLATIVE_PARAMETERS)))
, NULL
, '-1'
, PAY_MAG_UTILS.GET_PARAMETER( 'TRANSFER_TAX_UNIT_ID'
, ''
, PPA.LEGISLATIVE_PARAMETERS)))
, 'W2'
, TO_NUMBER( PAY_MAG_UTILS.GET_PARAMETER( 'TRANSFER_TRANS_LEGAL_CO_ID'
, 'TRANSFER_DATE'
, PPA.LEGISLATIVE_PARAMETERS))
, 'SQWL'
, TO_NUMBER( PAY_MAG_UTILS.GET_PARAMETER( 'TRANSFER_TRANS_LEGAL_CO_ID'
, 'TRANSFER_DATE'
, PPA.LEGISLATIVE_PARAMETERS)) ) ORGANIZATION_ID
FROM PAY_PAYROLL_ACTIONS PPA
WHERE PPA.ACTION_TYPE <> 'I'
AND PPA.CURRENT_TASK IS NULL
AND DECODE(PPA.ACTION_TYPE
, 'X'
, PPA.REPORT_CATEGORY
, 'Y' ) IS NOT NULL

Columns