eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PAYBV_PAYROLL_ACTION

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

View Text

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

Columns

Name
ACTION_TYPE
ACTION_STATUS
EFFECTIVE_DATE
ACTION_SEQUENCE
CHEQUE_PROCEDURE
CHEQUE_REPORT
COMMENTS
CURRENT_CHUNK_NUMBER
CURRENT_TASK
END_CHEQUE_NUMBER
LEGISLATIVE_PARAMETERS
OVERRIDING_DD_DATE
START_CHEQUE_NUMBER
START_DATE
DATE_EARNED
DISPLAY_RUN_NUMBER
PAY_ADVICE_DATE
PAY_ADVICE_MESSAGE
DF
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
OBJECT_VERSION_NUMBER
REPORT_TYPE
REPORT_QUALIFIER
MAGNETIC_FILE_NAME
REPORT_FILE_NAME
REPORT_CATEGORY
END_DATE
PURGE_PHASE
FUTURE_PROCESS_MODE
BATCH_PROCESS_MODE
ACTION_TYPE_CODE
ACTION_STATUS_CODE
CHEQUE_PROCEDURE_CODE
PAYROLL_ACTION_ID
BUSINESS_GROUP_ID
CONSOLIDATION_SET_ID
PAYROLL_ID
ORG_PAYMENT_METHOD_ID
PAYMENT_TYPE_ID
REQUEST_ID
ELEMENT_SET_ID
ASSIGNMENT_SET_ID
TARGET_PAYROLL_ACTION_ID
TIME_PERIOD_ID
BACKPAY_SET_ID
RUN_TYPE_ID
BALANCE_SET_ID
BATCH_ID
ACTION_PARAMETER_GROUP_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
BG_SECURITY_FLAG_CODE