View: PAY_ORG_PAY_METHOD_USAGES_F_V

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

View Text

SELECT OPU.ROWID ROW_ID
, OPU.ORG_PAY_METHOD_USAGE_ID
, OPU.EFFECTIVE_START_DATE
, OPU.EFFECTIVE_END_DATE
, OPU.PAYROLL_ID
, OPU.ORG_PAYMENT_METHOD_ID
, OPU.LAST_UPDATE_DATE
, OPU.LAST_UPDATED_BY
, OPU.LAST_UPDATE_LOGIN
, OPU.CREATED_BY
, OPU.CREATION_DATE
, OPMTL.ORG_PAYMENT_METHOD_NAME NAME
, PTTL.PAYMENT_TYPE_NAME TYPE
FROM PAY_ORG_PAY_METHOD_USAGES_F OPU
, PAY_ORG_PAYMENT_METHODS_F OPM
, PAY_ORG_PAYMENT_METHODS_F_TL OPMTL
, PAY_PAYMENT_TYPES PT
, PAY_PAYMENT_TYPES_TL PTTL
, FND_SESSIONS SES
WHERE PT.PAYMENT_TYPE_ID = PTTL.PAYMENT_TYPE_ID
AND PTTL.LANGUAGE = USERENV('LANG')
AND OPM.ORG_PAYMENT_METHOD_ID = OPMTL.ORG_PAYMENT_METHOD_ID
AND OPMTL.LANGUAGE = USERENV('LANG')
AND OPM.ORG_PAYMENT_METHOD_ID = OPU.ORG_PAYMENT_METHOD_ID
AND PT.PAYMENT_TYPE_ID = OPM.PAYMENT_TYPE_ID
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN OPU.EFFECTIVE_START_DATE
AND OPU.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE
AND OPM.EFFECTIVE_END_DATE

Columns