Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAY_RUN_TYPE_ORG_METHODS_V |
SELECT ROM.RUN_TYPE_ORG_METHOD_ID
, ROM.EFFECTIVE_START_DATE
, ROM.EFFECTIVE_END_DATE
, ROM.PRIORITY
, ROM.PERCENTAGE
, ROM.AMOUNT
, ROM.OBJECT_VERSION_NUMBER
, ROM.RUN_TYPE_ID
, PRT_TL.RUN_TYPE_NAME
, ROM.ORG_PAYMENT_METHOD_ID
, OPM_TL.ORG_PAYMENT_METHOD_NAME
, OPM.CURRENCY_CODE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('PAYMENT_CATEGORY'
, PPT.CATEGORY)
, 1
, 80) ORG_PAYMENT_METHOD_TYPE
, ROM.BUSINESS_GROUP_ID
, ROM.LEGISLATION_CODE
, ROM.ROWID ROW_ID
FROM PAY_RUN_TYPE_ORG_METHODS_F ROM
, PAY_RUN_TYPES_F PRT
, PAY_RUN_TYPES_F_TL PRT_TL
, PAY_ORG_PAYMENT_METHODS_F OPM
, PAY_ORG_PAYMENT_METHODS_F_TL OPM_TL
, PAY_PAYMENT_TYPES PPT
, FND_SESSIONS FS
WHERE ROM.RUN_TYPE_ID = PRT.RUN_TYPE_ID
AND PRT.RUN_TYPE_ID = PRT_TL.RUN_TYPE_ID
AND PRT_TL.LANGUAGE = USERENV('LANG')
AND ROM.ORG_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID
AND OPM.ORG_PAYMENT_METHOD_ID = OPM_TL.ORG_PAYMENT_METHOD_ID
AND OPM_TL.LANGUAGE = USERENV('LANG')
AND OPM.PAYMENT_TYPE_ID = PPT.PAYMENT_TYPE_ID
AND FS.SESSION_ID = USERENV('SESSIONID')
AND FS.EFFECTIVE_DATE BETWEEN ROM.EFFECTIVE_START_DATE
AND ROM.EFFECTIVE_END_DATE
AND FS.EFFECTIVE_DATE BETWEEN PRT.EFFECTIVE_START_DATE
AND PRT.EFFECTIVE_END_DATE
AND FS.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE
AND OPM.EFFECTIVE_END_DATE