VIEW: APPS.PAYBV_PAYROLL_ACTION

Source

View Text - Preformatted

SELECT hr_bis.bis_decode_lookup('ACTION_TYPE', ppa.action_type) ACTION_TYPE , hr_bis.bis_decode_lookup('ACTION_STATUS', ppa.ACTION_STATUS) ACTION_STATUS , ppa.EFFECTIVE_DATE , ppa.ACTION_SEQUENCE , hr_bis.bis_decode_lookup('CHEQUE_PROCEDURE', ppa.CHEQUE_PROCEDURE) CHEQUE_PROCEDURE , ppa.CHEQUE_REPORT , ppa.COMMENTS , ppa.CURRENT_CHUNK_NUMBER , ppa.CURRENT_TASK , ppa.END_CHEQUE_NUMBER , ppa.LEGISLATIVE_PARAMETERS , ppa.OVERRIDING_DD_DATE , ppa.START_CHEQUE_NUMBER , ppa.START_DATE , ppa.DATE_EARNED , ppa.DISPLAY_RUN_NUMBER , ppa.PAY_ADVICE_DATE , ppa.PAY_ADVICE_MESSAGE , '_DF:PAY:PAY_PAYROLL_ACTIONS:ppa' , ppa.ATTRIBUTE_CATEGORY, ppa.ATTRIBUTE1, ppa.ATTRIBUTE2, ppa.ATTRIBUTE3, ppa.ATTRIBUTE4, ppa.ATTRIBUTE5, ppa.ATTRIBUTE6, ppa.ATTRIBUTE7, ppa.ATTRIBUTE8, ppa.ATTRIBUTE9, ppa.ATTRIBUTE10, ppa.ATTRIBUTE11, ppa.ATTRIBUTE12, ppa.ATTRIBUTE13, ppa.ATTRIBUTE14, ppa.ATTRIBUTE15, ppa.ATTRIBUTE16, ppa.ATTRIBUTE17, ppa.ATTRIBUTE18, ppa.ATTRIBUTE19, ppa.ATTRIBUTE20, ppa.OBJECT_VERSION_NUMBER , ppa.REPORT_TYPE , ppa.REPORT_QUALIFIER , ppa.MAGNETIC_FILE_NAME , ppa.REPORT_FILE_NAME , ppa.REPORT_CATEGORY , ppa.END_DATE , ppa.PURGE_PHASE , ppa.FUTURE_PROCESS_MODE , ppa.BATCH_PROCESS_MODE , ppa.ACTION_TYPE ACTION_TYPE_CODE , ppa.ACTION_STATUS ACTION_STATUS_CODE , ppa.CHEQUE_PROCEDURE CHEQUE_PROCEDURE_CODE , ppa.PAYROLL_ACTION_ID , ppa.BUSINESS_GROUP_ID , ppa.CONSOLIDATION_SET_ID , ppa.PAYROLL_ID , ppa.ORG_PAYMENT_METHOD_ID , ppa.PAYMENT_TYPE_ID , ppa.REQUEST_ID , ppa.ELEMENT_SET_ID , ppa.ASSIGNMENT_SET_ID , ppa.TARGET_PAYROLL_ACTION_ID , ppa.TIME_PERIOD_ID , ppa.BACKPAY_SET_ID , ppa.RUN_TYPE_ID , ppa.BALANCE_SET_ID , ppa.BATCH_ID , ppa.ACTION_PARAMETER_GROUP_ID , ppa.LAST_UPDATE_DATE , ppa.LAST_UPDATED_BY , ppa.LAST_UPDATE_LOGIN , ppa.CREATED_BY , ppa.CREATION_DATE , CASE WHEN (ppa.business_group_id = nvl(hr_bis.get_sec_profile_bg_id, ppa.business_group_id)) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM pay_payroll_actions ppa WITH READ ONLY

View Text - HTML Formatted

SELECT HR_BIS.BIS_DECODE_LOOKUP('ACTION_TYPE'
, PPA.ACTION_TYPE) ACTION_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('ACTION_STATUS'
, PPA.ACTION_STATUS) ACTION_STATUS
, PPA.EFFECTIVE_DATE
, PPA.ACTION_SEQUENCE
, HR_BIS.BIS_DECODE_LOOKUP('CHEQUE_PROCEDURE'
, PPA.CHEQUE_PROCEDURE) CHEQUE_PROCEDURE
, PPA.CHEQUE_REPORT
, PPA.COMMENTS
, PPA.CURRENT_CHUNK_NUMBER
, PPA.CURRENT_TASK
, PPA.END_CHEQUE_NUMBER
, PPA.LEGISLATIVE_PARAMETERS
, PPA.OVERRIDING_DD_DATE
, PPA.START_CHEQUE_NUMBER
, PPA.START_DATE
, PPA.DATE_EARNED
, PPA.DISPLAY_RUN_NUMBER
, PPA.PAY_ADVICE_DATE
, PPA.PAY_ADVICE_MESSAGE
, '_DF:PAY:PAY_PAYROLL_ACTIONS:PPA'
, PPA.ATTRIBUTE_CATEGORY
, PPA.ATTRIBUTE1
, PPA.ATTRIBUTE2
, PPA.ATTRIBUTE3
, PPA.ATTRIBUTE4
, PPA.ATTRIBUTE5
, PPA.ATTRIBUTE6
, PPA.ATTRIBUTE7
, PPA.ATTRIBUTE8
, PPA.ATTRIBUTE9
, PPA.ATTRIBUTE10
, PPA.ATTRIBUTE11
, PPA.ATTRIBUTE12
, PPA.ATTRIBUTE13
, PPA.ATTRIBUTE14
, PPA.ATTRIBUTE15
, PPA.ATTRIBUTE16
, PPA.ATTRIBUTE17
, PPA.ATTRIBUTE18
, PPA.ATTRIBUTE19
, PPA.ATTRIBUTE20
, PPA.OBJECT_VERSION_NUMBER
, PPA.REPORT_TYPE
, PPA.REPORT_QUALIFIER
, PPA.MAGNETIC_FILE_NAME
, PPA.REPORT_FILE_NAME
, PPA.REPORT_CATEGORY
, PPA.END_DATE
, PPA.PURGE_PHASE
, PPA.FUTURE_PROCESS_MODE
, PPA.BATCH_PROCESS_MODE
, PPA.ACTION_TYPE ACTION_TYPE_CODE
, PPA.ACTION_STATUS ACTION_STATUS_CODE
, PPA.CHEQUE_PROCEDURE CHEQUE_PROCEDURE_CODE
, PPA.PAYROLL_ACTION_ID
, PPA.BUSINESS_GROUP_ID
, PPA.CONSOLIDATION_SET_ID
, PPA.PAYROLL_ID
, PPA.ORG_PAYMENT_METHOD_ID
, PPA.PAYMENT_TYPE_ID
, PPA.REQUEST_ID
, PPA.ELEMENT_SET_ID
, PPA.ASSIGNMENT_SET_ID
, PPA.TARGET_PAYROLL_ACTION_ID
, PPA.TIME_PERIOD_ID
, PPA.BACKPAY_SET_ID
, PPA.RUN_TYPE_ID
, PPA.BALANCE_SET_ID
, PPA.BATCH_ID
, PPA.ACTION_PARAMETER_GROUP_ID
, PPA.LAST_UPDATE_DATE
, PPA.LAST_UPDATED_BY
, PPA.LAST_UPDATE_LOGIN
, PPA.CREATED_BY
, PPA.CREATION_DATE
, CASE WHEN (PPA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PPA.BUSINESS_GROUP_ID)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PAY_PAYROLL_ACTIONS PPA WITH READ ONLY