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_PRE_PAYMENTS_V4

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

View Text

SELECT PPAY.ROWID ROW_ID
, PPAY.PRE_PAYMENT_ID
, PPAY.PERSONAL_PAYMENT_METHOD_ID
, PPAY.ASSIGNMENT_ACTION_ID
, PPAY.ORG_PAYMENT_METHOD_ID
, PPAY.VALUE
, PPACT.ACTION_TYPE
, HR.MEANING TYPE_MEANING
, PPT.CATEGORY
, PPAY.BASE_CURRENCY_VALUE
, PASS.ASSIGNMENT_ID
, PASS.PAYROLL_ID
, PACT.ACTION_STATUS
, PPACT.EFFECTIVE_DATE
, PORGTL.ORG_PAYMENT_METHOD_NAME
, PASS.LAST_UPDATE_DATE
, PASS.LAST_UPDATED_BY
, PASS.LAST_UPDATE_LOGIN
, PASS.CREATED_BY
, PASS.CREATION_DATE
, PORG.EFFECTIVE_START_DATE PORG_START_DATE
, PORG.EFFECTIVE_END_DATE PORG_END_DATE
, PASS.EFFECTIVE_START_DATE PASS_START_DATE
, PASS.EFFECTIVE_END_DATE PASS_END_DATE
, PORG.CURRENCY_CODE
FROM PAY_ORG_PAYMENT_METHODS_F_TL PORGTL
, PAY_ORG_PAYMENT_METHODS_F PORG
, PAY_PAYROLL_ACTIONS PPACT
, PER_ALL_ASSIGNMENTS_F PASS
, PAY_ASSIGNMENT_ACTIONS PACT
, PAY_PRE_PAYMENTS PPAY
, HR_LOOKUPS HR
, PAY_PAYMENT_TYPES PPT
WHERE PORG.ORG_PAYMENT_METHOD_ID = PORGTL.ORG_PAYMENT_METHOD_ID
AND PORGTL.LANGUAGE = USERENV('LANG')
AND PPAY.ASSIGNMENT_ACTION_ID = PACT.ASSIGNMENT_ACTION_ID
AND PACT.PAYROLL_ACTION_ID = PPACT.PAYROLL_ACTION_ID
AND PPACT.ACTION_TYPE = HR.LOOKUP_CODE
AND HR.LOOKUP_TYPE = 'ACTION_TYPE'
AND PPAY.ORG_PAYMENT_METHOD_ID = PORG.ORG_PAYMENT_METHOD_ID
AND PORG.PAYMENT_TYPE_ID = PPT.PAYMENT_TYPE_ID
AND PASS.ASSIGNMENT_ID = PACT.ASSIGNMENT_ID
AND PPACT.EFFECTIVE_DATE BETWEEN PASS.EFFECTIVE_START_DATE
AND PASS.EFFECTIVE_END_DATE
AND PPACT.EFFECTIVE_DATE BETWEEN PORG.EFFECTIVE_START_DATE
AND PORG.EFFECTIVE_END_DATE
AND NOT EXISTS ( SELECT 1
FROM PAY_ACTION_INTERLOCKS PAI
, PAY_ASSIGNMENT_ACTIONS PACT2
WHERE PAI.LOCKING_ACTION_ID = PACT2.ASSIGNMENT_ACTION_ID
AND PAI.LOCKED_ACTION_ID = PPAY.ASSIGNMENT_ACTION_ID
AND PACT2.PRE_PAYMENT_ID = PPAY.PRE_PAYMENT_ID
AND NOT EXISTS ( SELECT 1
FROM PAY_ACTION_INTERLOCKS PAI1
, PAY_ASSIGNMENT_ACTIONS PACT3
, PAY_PAYROLL_ACTIONS PPACT1
WHERE PAI1.LOCKED_ACTION_ID = PACT2.ASSIGNMENT_ACTION_ID
AND PAI1.LOCKING_ACTION_ID = PACT3.ASSIGNMENT_ACTION_ID
AND PACT3.PAYROLL_ACTION_ID = PPACT1.PAYROLL_ACTION_ID
AND PPACT1.ACTION_TYPE = 'D' ) )

Columns

Name
ROW_ID
PRE_PAYMENT_ID
PERSONAL_PAYMENT_METHOD_ID
ASSIGNMENT_ACTION_ID
ORG_PAYMENT_METHOD_ID
VALUE
ACTION_TYPE
TYPE_MEANING
CATEGORY
BASE_CURRENCY_VALUE
ASSIGNMENT_ID
PAYROLL_ID
ACTION_STATUS
EFFECTIVE_DATE
ORG_PAYMENT_METHOD_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
PORG_START_DATE
PORG_END_DATE
PASS_START_DATE
PASS_END_DATE
CURRENCY_CODE