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: PAY_PAYROLL_ACTIONS_V7

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_PAYROLL_ACTIONS_V7

View Text

SELECT PAC1.ROWID ROW_ID
, PAC1.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, PAC1.PAYROLL_ID
, PAC1.PAYROLL_ACTION_ID
, PAC1.ACTION_TYPE
, PAC1.EFFECTIVE_DATE
, PAC1.DATE_EARNED
, HR_PAYROLLS.DISPLAY_PERIOD_NAME(PAC1.PAYROLL_ACTION_ID) PERIOD_NAME
, LO1.MEANING
, PRO.PAYROLL_NAME
, DECODE(PAC1.ACTION_STATUS
, 'P'
, DECODE( REQUEST.PHASE_CODE
, 'C'
, 'E'
, PAC1.ACTION_STATUS)
, PAC1.ACTION_STATUS) STATUS_CODE
, PAC1.ACTION_STATUS
, PAC1.ACTION_SEQUENCE
, PAC1.DISPLAY_RUN_NUMBER
, PAC1.CONSOLIDATION_SET_ID
, PAC1.ASSIGNMENT_SET_ID
, PAC1.ELEMENT_SET_ID
, PAC1.REQUEST_ID
, PAC1.COMMENTS
FROM FND_CONCURRENT_REQUESTS REQUEST
, HR_LOOKUPS LO1
, PER_TIME_PERIODS PTP
, PAY_PAYROLLS_F PRO
, PAY_PAYROLL_ACTIONS PAC1
WHERE PAC1.PAYROLL_ID = PTP.PAYROLL_ID
AND PAC1.EFFECTIVE_DATE BETWEEN PTP.START_DATE
AND PTP.END_DATE
AND LO1.LOOKUP_TYPE = 'ACTION_TYPE'
AND LO1.LOOKUP_CODE = PAC1.ACTION_TYPE
AND PAC1.PAYROLL_ID = PRO.PAYROLL_ID
AND PAC1.EFFECTIVE_DATE BETWEEN PRO.EFFECTIVE_START_DATE
AND PRO.EFFECTIVE_END_DATE
AND PAC1.ACTION_STATUS != 'U'
AND PAC1.ACTION_TYPE != 'I'
AND PAC1.REQUEST_ID = REQUEST.REQUEST_ID (+) UNION ALL SELECT PAC1.ROWID ROW_ID
, PAC1.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, PAC1.PAYROLL_ID
, PAC1.PAYROLL_ACTION_ID
, PAC1.ACTION_TYPE
, PAC1.EFFECTIVE_DATE
, PAC1.DATE_EARNED
, NULL
, LO1.MEANING
, NULL
, DECODE(PAC1.ACTION_STATUS
, 'P'
, DECODE( REQUEST.PHASE_CODE
, 'C'
, 'E'
, PAC1.ACTION_STATUS)
, PAC1.ACTION_STATUS) STATUS_CODE
, PAC1.ACTION_STATUS
, PAC1.ACTION_SEQUENCE
, PAC1.DISPLAY_RUN_NUMBER
, PAC1.CONSOLIDATION_SET_ID
, PAC1.ASSIGNMENT_SET_ID
, PAC1.ELEMENT_SET_ID
, PAC1.REQUEST_ID
, PAC1.COMMENTS
FROM FND_CONCURRENT_REQUESTS REQUEST
, HR_LOOKUPS LO1
, PAY_PAYROLL_ACTIONS PAC1
WHERE PAC1.PAYROLL_ID IS NULL
AND LO1.LOOKUP_TYPE = 'ACTION_TYPE'
AND LO1.LOOKUP_CODE = PAC1.ACTION_TYPE
AND PAC1.ACTION_STATUS != ' U'
AND PAC1.ACTION_TYPE != 'I'
AND PAC1.REQUEST_ID = REQUEST.REQUEST_ID (+)

Columns

Name
ROW_ID
BUSINESS_GROUP_ID
PAYROLL_ID
PAYROLL_ACTION_ID
ACTION_TYPE
EFFECTIVE_DATE
DATE_EARNED
PERIOD_NAME
MEANING
PAYROLL_NAME
STATUS_CODE
ACTION_STATUS
ACTION_SEQUENCE
DISPLAY_RUN_NUMBER
CONSOLIDATION_SET_ID
ASSIGNMENT_SET_ID
ELEMENT_SET_ID
REQUEST_ID
COMMENTS