View: PAY_ELE_CLASSIFICATION_RULES_V

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

View Text

SELECT ECR.ROWID ROW_ID
, ECR.ELEMENT_SET_ID
, ECR.CLASSIFICATION_ID
, ECR.LAST_UPDATE_DATE
, ECR.LAST_UPDATED_BY
, ECR.LAST_UPDATE_LOGIN
, ECR.CREATED_BY
, ECR.CREATION_DATE
, ECLTL.CLASSIFICATION_NAME
, HL.MEANING DEBIT_OR_CREDIT
FROM PAY_ELE_CLASSIFICATION_RULES ECR
, PAY_ELEMENT_CLASSIFICATIONS_TL ECLTL
, PAY_ELEMENT_CLASSIFICATIONS ECL
, HR_LOOKUPS HL
WHERE ECL.CLASSIFICATION_ID = ECLTL.CLASSIFICATION_ID
AND ECLTL.LANGUAGE = USERENV('LANG')
AND ECL.CLASSIFICATION_ID = ECR.CLASSIFICATION_ID
AND HL.LOOKUP_CODE (+) = ECL.COSTING_DEBIT_OR_CREDIT
AND ((HL.LOOKUP_CODE IS NOT NULL
AND HL.LOOKUP_TYPE = 'DEBIT_CREDIT') OR (HL.LOOKUP_CODE IS NULL))

Columns