View: PAY_VIEW_NET_CALC_RULES_V

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

View Text

SELECT 1
, 0
, PAP1.ACCRUAL_PLAN_ID
, 0
, 'ACCRUAL PLAN'
, PAP1.ACCRUAL_PLAN_ELEMENT_TYPE_ID
, PAP1.ACCRUAL_PLAN_NAME
, '1'
, HRL1.MEANING
, PAP1.ACCRUAL_UNITS_OF_MEASURE
, HRL2.MEANING
FROM HR_LOOKUPS HRL1
, HR_LOOKUPS HRL2
, PAY_ACCRUAL_PLANS PAP1
WHERE HRL1.LOOKUP_CODE = '1'
AND HRL1.LOOKUP_TYPE = 'ADD_SUBTRACT'
AND HRL2.LOOKUP_CODE = PAP1.ACCRUAL_UNITS_OF_MEASURE
AND HRL2.LOOKUP_TYPE = 'HOURS_OR_DAYS' UNION SELECT 2
, NCR1.NET_CALCULATION_RULE_ID
, NCR1.ACCRUAL_PLAN_ID
, NCR1.INPUT_VALUE_ID
, PIV1.NAME
, PET1.ELEMENT_TYPE_ID
, PET1.ELEMENT_NAME
, NCR1.ADD_OR_SUBTRACT
, HRL4.MEANING
, PAP2.ACCRUAL_UNITS_OF_MEASURE
, HRL3.MEANING
FROM PAY_ELEMENT_TYPES_F_TL PET1TL
, PAY_INPUT_VALUES_F_TL PIV1TL
, HR_LOOKUPS HRL4
, HR_LOOKUPS HRL3
, PAY_ELEMENT_TYPES_F PET1
, PAY_INPUT_VALUES_F PIV1
, PAY_NET_CALCULATION_RULES NCR1
, PAY_ACCRUAL_PLANS PAP2
, FND_SESSIONS SES1
WHERE PIV1TL.INPUT_VALUE_ID = PIV1.INPUT_VALUE_ID
AND PIV1TL.LANGUAGE = USERENV('LANG')
AND PET1.ELEMENT_TYPE_ID = PET1TL.ELEMENT_TYPE_ID
AND PET1TL.LANGUAGE = USERENV('LANG')
AND HRL4.LOOKUP_CODE = NCR1.ADD_OR_SUBTRACT
AND HRL4.LOOKUP_TYPE = 'ADD_SUBTRACT'
AND HRL3.LOOKUP_CODE = PAP2.ACCRUAL_UNITS_OF_MEASURE
AND HRL3.LOOKUP_TYPE = 'HOURS_OR_DAYS'
AND SES1.EFFECTIVE_DATE BETWEEN PET1.EFFECTIVE_START_DATE
AND PET1.EFFECTIVE_END_DATE
AND PET1.ELEMENT_TYPE_ID = PIV1.ELEMENT_TYPE_ID
AND SES1.EFFECTIVE_DATE BETWEEN PIV1.EFFECTIVE_START_DATE
AND PIV1.EFFECTIVE_END_DATE
AND PIV1.INPUT_VALUE_ID = NCR1.INPUT_VALUE_ID
AND NCR1.ACCRUAL_PLAN_ID = PAP2.ACCRUAL_PLAN_ID
AND NCR1.INPUT_VALUE_ID = PAP2.CO_INPUT_VALUE_ID
AND SES1.SESSION_ID = USERENV('SESSIONID') UNION SELECT 3
, NCR2.NET_CALCULATION_RULE_ID
, NCR2.ACCRUAL_PLAN_ID
, NCR2.INPUT_VALUE_ID
, PIV2.NAME
, PET2.ELEMENT_TYPE_ID
, PET2.ELEMENT_NAME
, NCR2.ADD_OR_SUBTRACT
, HRL6.MEANING
, PAP3.ACCRUAL_UNITS_OF_MEASURE
, HRL5.MEANING
FROM PAY_INPUT_VALUES_F_TL PIV2TL
, PAY_ELEMENT_TYPES_F_TL PET2TL
, HR_LOOKUPS HRL6
, HR_LOOKUPS HRL5
, PAY_ELEMENT_TYPES_F PET2
, PAY_INPUT_VALUES_F PIV2
, PAY_NET_CALCULATION_RULES NCR2
, PAY_ACCRUAL_PLANS PAP3
, FND_SESSIONS SES2
WHERE PIV2TL.INPUT_VALUE_ID = PIV2.INPUT_VALUE_ID
AND PIV2TL.LANGUAGE = USERENV('LANG')
AND PET2.ELEMENT_TYPE_ID = PET2TL.ELEMENT_TYPE_ID
AND PET2TL.LANGUAGE = USERENV('LANG')
AND HRL6.LOOKUP_CODE = NCR2.ADD_OR_SUBTRACT
AND HRL6.LOOKUP_TYPE = 'ADD_SUBTRACT'
AND HRL5.LOOKUP_CODE = PAP3.ACCRUAL_UNITS_OF_MEASURE
AND HRL5.LOOKUP_TYPE = 'HOURS_OR_DAYS'
AND SES2.EFFECTIVE_DATE BETWEEN PET2.EFFECTIVE_START_DATE
AND PET2.EFFECTIVE_END_DATE
AND PET2.ELEMENT_TYPE_ID = PIV2.ELEMENT_TYPE_ID
AND SES2.EFFECTIVE_DATE BETWEEN PIV2.EFFECTIVE_START_DATE
AND PIV2.EFFECTIVE_END_DATE
AND PIV2.INPUT_VALUE_ID = NCR2.INPUT_VALUE_ID
AND NCR2.ACCRUAL_PLAN_ID = PAP3.ACCRUAL_PLAN_ID
AND NCR2.INPUT_VALUE_ID != PAP3.CO_INPUT_VALUE_ID
AND SES2.SESSION_ID = USERENV('SESSIONID')

Columns