Product: | PAY - Payroll |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PAY_SUB_CLASSIFICATION_RULES_V |
SELECT SCR.ROWID ROW_ID
, SCR.SUB_CLASSIFICATION_RULE_ID
, SCR.EFFECTIVE_START_DATE
, SCR.EFFECTIVE_END_DATE
, SCR.ELEMENT_TYPE_ID
, SCR.CLASSIFICATION_ID
, SCR.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, SCR.LEGISLATION_CODE
, SCR.LAST_UPDATE_DATE
, SCR.LAST_UPDATED_BY
, SCR.LAST_UPDATE_LOGIN
, SCR.CREATED_BY
, SCR.CREATION_DATE
, PECTL.CLASSIFICATION_NAME
, PECTL.DESCRIPTION
FROM PAY_ELEMENT_CLASSIFICATIONS_TL PECTL
, PAY_ELEMENT_CLASSIFICATIONS PEC
, PAY_SUB_CLASSIFICATION_RULES_F SCR
, FND_SESSIONS FND
WHERE PEC.CLASSIFICATION_ID = PECTL.CLASSIFICATION_ID
AND PECTL.LANGUAGE = USERENV('LANG')
AND PEC.CLASSIFICATION_ID = SCR.CLASSIFICATION_ID
AND FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN SCR.EFFECTIVE_START_DATE
AND SCR.EFFECTIVE_END_DATE