[Home] [Help]
View: PAY_IE_EMEA_BAL_V
Product: | PAY - Payroll |
Description: | Used in IE Payslip Advice Report |
Implementation/DBA Data: |
APPS.PAY_IE_EMEA_BAL_V
|
View Text
SELECT PAI2.ACTION_CONTEXT_ID ASSIGNMENT_ACTION_ID
, SUBSTR(PAI1.ACTION_INFORMATION4
, 1
, 30) BALANCE_NAME
, SUBSTR(PAI1.ACTION_INFORMATION5
, 1
, 2) NI_TYPE
, TO_NUMBER(PAI2.ACTION_INFORMATION4) BALANCE_VALUE
FROM PAY_ACTION_INFORMATION PAI1
, PAY_ACTION_INFORMATION PAI2
, PAY_ASSIGNMENT_ACTIONS PAA1
WHERE PAA1.PAYROLL_ACTION_ID = PAI1.ACTION_CONTEXT_ID
AND PAI1.ACTION_CONTEXT_TYPE = 'PA'
AND PAI1.ACTION_INFORMATION_CATEGORY = 'EMEA BALANCE DEFINITION'
AND PAI2.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI2.ACTION_INFORMATION_CATEGORY = 'EMEA BALANCES'
AND PAI1.ACTION_INFORMATION2 = PAI2.ACTION_INFORMATION1
AND PAA1.ASSIGNMENT_ACTION_ID = PAI2.ACTION_CONTEXT_ID
AND PAI1.ACTION_INFORMATION1 IS NULL UNION SELECT PAI2.ACTION_CONTEXT_ID ASSIGNMENT_ACTION_ID
, SUBSTR(PAI1.ACTION_INFORMATION4
, 1
, 30) BALANCE_NAME
, SUBSTR(PAI1.ACTION_INFORMATION5
, 1
, 2) NI_TYPE
, TO_NUMBER(PAI2.ACTION_INFORMATION4) BALANCE_VALUE
FROM PAY_ACTION_INTERLOCKS LCK
, PAY_ACTION_INFORMATION PAI1
, PAY_ACTION_INFORMATION PAI2
, PAY_ASSIGNMENT_ACTIONS PAA1
, PAY_ASSIGNMENT_ACTIONS PAA2
WHERE LCK.LOCKING_ACTION_ID = PAI2.ACTION_CONTEXT_ID
AND LCK.LOCKED_ACTION_ID = PAA1.ASSIGNMENT_ACTION_ID
AND PAA1.PAYROLL_ACTION_ID = PAI1.ACTION_INFORMATION1
AND PAI1.ACTION_CONTEXT_TYPE = 'PA'
AND PAI1.ACTION_INFORMATION_CATEGORY = 'EMEA BALANCE DEFINITION'
AND PAI2.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI2.ACTION_INFORMATION_CATEGORY = 'EMEA BALANCES'
AND PAI1.ACTION_INFORMATION2 = PAI2.ACTION_INFORMATION1
AND LCK.LOCKING_ACTION_ID = PAA2.ASSIGNMENT_ACTION_ID
AND PAA2.PAYROLL_ACTION_ID = PAI1.ACTION_CONTEXT_ID
AND PAI1.ACTION_INFORMATION1 IS NOT NULL
Columns
Name |
ASSIGNMENT_ACTION_ID |
BALANCE_NAME |
NI_TYPE |
BALANCE_VALUE |