View: PAY_NET_CALCULATION_RULES_V

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

View Text

SELECT NCR.ROWID
, NCR.NET_CALCULATION_RULE_ID
, NCR.ACCRUAL_PLAN_ID
, NCR.BUSINESS_GROUP_ID
, NCR.OBJECT_VERSION_NUMBER
, NCR.INPUT_VALUE_ID
, NCR.DATE_INPUT_VALUE_ID
, PIVTL.NAME
, PIV1TL.NAME
, PET.ELEMENT_TYPE_ID
, PETTL.ELEMENT_NAME
, NCR.ADD_OR_SUBTRACT
, HRL.MEANING
FROM HR_LOOKUPS HRL
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_TYPES_F_TL PETTL
, PAY_INPUT_VALUES_F PIV
, PAY_INPUT_VALUES_F PIV1
, PAY_INPUT_VALUES_F_TL PIVTL
, PAY_INPUT_VALUES_F_TL PIV1TL
, FND_SESSIONS SES
, PAY_NET_CALCULATION_RULES NCR
WHERE PIV.INPUT_VALUE_ID = PIVTL.INPUT_VALUE_ID
AND PIVTL.LANGUAGE = USERENV('LANG')
AND PIV1.INPUT_VALUE_ID = PIV1TL.INPUT_VALUE_ID (+)
AND DECODE(PIV1TL.INPUT_VALUE_ID
, NULL
, '1'
, PIV1TL.LANGUAGE) = DECODE(PIV1TL.INPUT_VALUE_ID
, NULL
, '1'
, USERENV('LANG'))
AND PETTL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PETTL.LANGUAGE = USERENV('LANG')
AND HRL.LOOKUP_CODE = NCR.ADD_OR_SUBTRACT
AND HRL.LOOKUP_TYPE = 'ADD_SUBTRACT'
AND SES.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND PET.ELEMENT_TYPE_ID = PIV.ELEMENT_TYPE_ID
AND SES.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND PIV.INPUT_VALUE_ID = NCR.INPUT_VALUE_ID
AND SES.EFFECTIVE_DATE BETWEEN NVL(PIV1.EFFECTIVE_START_DATE
, SES.EFFECTIVE_DATE)
AND NVL(PIV1.EFFECTIVE_END_DATE
, SES.EFFECTIVE_DATE)
AND PIV1.INPUT_VALUE_ID(+) = NCR.DATE_INPUT_VALUE_ID
AND SES.SESSION_ID = USERENV('SESSIONID')

Columns