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.

VIEW: APPS.PAY_PRE_PAYMENTS_V4

Source

View Text - Preformatted


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 , PPACT.PAYROLL_ACTION_ID 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' ) )

View Text - HTML Formatted

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
, PPACT.PAYROLL_ACTION_ID
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' ) )