Product: | PAY - Payroll |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PAY_BALANCE_TYPES_V |
SELECT BT.ROWID ROW_ID
, BT.BALANCE_TYPE_ID
, BT.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, BT.LEGISLATION_CODE
, BT.CURRENCY_CODE
, BT.ASSIGNMENT_REMUNERATION_FLAG
, BTTL.BALANCE_NAME
, BT.BALANCE_NAME BASE_BALANCE_NAME
, BT.BALANCE_UOM
, BT.COMMENTS
, BT.LEGISLATION_SUBGROUP
, BTTL.REPORTING_NAME
, BT.ATTRIBUTE_CATEGORY
, BT.ATTRIBUTE1
, BT.ATTRIBUTE2
, BT.ATTRIBUTE3
, BT.ATTRIBUTE4
, BT.ATTRIBUTE5
, BT.ATTRIBUTE6
, BT.ATTRIBUTE7
, BT.ATTRIBUTE8
, BT.ATTRIBUTE9
, BT.ATTRIBUTE10
, BT.ATTRIBUTE11
, BT.ATTRIBUTE12
, BT.ATTRIBUTE13
, BT.ATTRIBUTE14
, BT.ATTRIBUTE15
, BT.ATTRIBUTE16
, BT.ATTRIBUTE17
, BT.ATTRIBUTE18
, BT.ATTRIBUTE19
, BT.ATTRIBUTE20
, BT.LAST_UPDATE_DATE
, BT.LAST_UPDATED_BY
, BT.LAST_UPDATE_LOGIN
, BT.CREATED_BY
, BT.CREATION_DATE
, HL.MEANING UNITS
, BT.BALANCE_CATEGORY_ID
, PBC.CATEGORY_NAME
, BT.BASE_BALANCE_TYPE_ID
, BASE_BTTL.BALANCE_NAME BASE_BALANCE
, BT.INPUT_VALUE_ID PRIMARY_BAL_IV_ID
, PIVTL.NAME PRIMARY_BAL_IV_NAME
, PET.ELEMENT_TYPE_ID PRIMARY_BAL_ELE_ID
, PETTL.ELEMENT_NAME PRIMARY_BAL_ELE_NAME
, PBC.USER_CATEGORY_NAME
, BCT.USER_CATEGORY_NAME TL_USER_CATEGORY_NAME
FROM PAY_BALANCE_TYPES BT
, PAY_BALANCE_TYPES_TL BTTL
, HR_LOOKUPS HL
, PAY_BALANCE_CATEGORIES_F PBC
, PAY_BALANCE_CATEGORIES_F_TL BCT
, FND_SESSIONS FS
, PAY_BALANCE_TYPES BASE_BT
, PAY_BALANCE_TYPES_TL BASE_BTTL
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_TYPES_F_TL PETTL
, PAY_INPUT_VALUES_F PIV
, PAY_INPUT_VALUES_F_TL PIVTL
WHERE BT.BALANCE_TYPE_ID = BTTL.BALANCE_TYPE_ID
AND BTTL.LANGUAGE = USERENV('LANG')
AND HL.LOOKUP_TYPE = 'UNITS'
AND HL.LOOKUP_CODE = BT.BALANCE_UOM
AND BT.BALANCE_CATEGORY_ID = PBC.BALANCE_CATEGORY_ID (+)
AND BT.BALANCE_CATEGORY_ID = BCT.BALANCE_CATEGORY_ID(+)
AND NVL(BCT.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')
AND FS.SESSION_ID = USERENV('SESSIONID')
AND FS.EFFECTIVE_DATE BETWEEN NVL(PBC.EFFECTIVE_START_DATE
, FND_DATE.CANONICAL_TO_DATE('0001/01/01'))
AND NVL(PBC.EFFECTIVE_END_DATE
, FND_DATE.CANONICAL_TO_DATE('4712/12/31'))
AND BT.BASE_BALANCE_TYPE_ID = BASE_BT.BALANCE_TYPE_ID (+)
AND BASE_BT.BALANCE_TYPE_ID = BASE_BTTL.BALANCE_TYPE_ID (+)
AND NVL(BASE_BTTL.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')
AND BT.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID (+)
AND PIV.INPUT_VALUE_ID = PIVTL.INPUT_VALUE_ID (+)
AND NVL(PIVTL.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')
AND FS.EFFECTIVE_DATE BETWEEN NVL(PIV.EFFECTIVE_START_DATE
, FND_DATE.CANONICAL_TO_DATE('0001/01/01'))
AND NVL(PIV.EFFECTIVE_END_DATE
, FND_DATE.CANONICAL_TO_DATE('4712/12/31'))
AND PET.ELEMENT_TYPE_ID (+) = PIV.ELEMENT_TYPE_ID
AND PET.ELEMENT_TYPE_ID = PETTL.ELEMENT_TYPE_ID (+)
AND NVL(PETTL.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')
AND FS.EFFECTIVE_DATE BETWEEN NVL(PET.EFFECTIVE_START_DATE
, FND_DATE.CANONICAL_TO_DATE('0001/01/01'))
AND NVL(PET.EFFECTIVE_END_DATE
, FND_DATE.CANONICAL_TO_DATE('4712/12/31'))