View: PAY_ORG_PAYMENT_METHODS_D

Product:	PAY - Payroll
Description:	Used by DateTrack History
Implementation/DBA Data:	APPS.PAY_ORG_PAYMENT_METHODS_D

View Text

SELECT PAYORG.ORG_PAYMENT_METHOD_ID
, PAYORG.EFFECTIVE_START_DATE
, PAYORG.EFFECTIVE_END_DATE
, PTYPETL.PAYMENT_TYPE_NAME
, PAYORGTL.ORG_PAYMENT_METHOD_NAME
, PAYORG.LAST_UPDATE_DATE
, FUSER.USER_NAME
, PAYORG.ORG_PAYMENT_METHOD_NAME SYSTEM_ORG_PAY_METHOD_NAME
FROM PAY_ORG_PAYMENT_METHODS_F PAYORG
, PAY_PAYMENT_TYPES PTYPE
, PAY_ORG_PAYMENT_METHODS_F_TL PAYORGTL
, PAY_PAYMENT_TYPES_TL PTYPETL
, FND_USER FUSER
WHERE PAYORG.ORG_PAYMENT_METHOD_ID = PAYORGTL.ORG_PAYMENT_METHOD_ID
AND PAYORGTL.LANGUAGE = USERENV('LANG')
AND PTYPE.PAYMENT_TYPE_ID = PTYPETL.PAYMENT_TYPE_ID
AND PTYPETL.LANGUAGE = USERENV('LANG')
AND PTYPE.PAYMENT_TYPE_ID = PAYORG.PAYMENT_TYPE_ID
AND FUSER.USER_ID (+)= PAYORG.LAST_UPDATED_BY

Columns