VIEW: APPS.PAY_NET_CALCULATION_RULES_V

Source

View Text - Preformatted

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 , NCR.absence_attendance_type_id ,NCR.use_element_link , DECODE(PAP_ABS.PTO_INPUT_VALUE_ID, NULL, DECODE(PAP_CO.co_input_value_id, null, DECODE(NCR.ABSENCE_ATTENDANCE_TYPE_ID, NULL, DECODE(PAP_RES.RESIDUAL_INPUT_VALUE_ID,NULL,'O','R'),'A'),'C'),'A') RULE_TYPE 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, PAY_ACCRUAL_PLANS PAP_ABS, PAY_ACCRUAL_PLANS PAP_CO, PAY_ACCRUAL_PLANS PAP_RES 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') AND (NCR.ACCRUAL_PLAN_ID = PAP_ABS.ACCRUAL_PLAN_ID(+) AND PAP_ABS.PTO_INPUT_VALUE_ID(+) = NCR.INPUT_VALUE_ID) AND (NCR.ACCRUAL_PLAN_ID = PAP_CO.ACCRUAL_PLAN_ID(+) AND PAP_CO.CO_INPUT_VALUE_ID(+) = NCR.INPUT_VALUE_ID) AND (NCR.accrual_plan_id = PAP_RES.ACCRUAL_PLAN_ID(+) AND PAP_RES.RESIDUAL_INPUT_VALUE_ID(+) = NCR.INPUT_VALUE_ID)

View Text - HTML Formatted

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
, NCR.ABSENCE_ATTENDANCE_TYPE_ID
, NCR.USE_ELEMENT_LINK
, DECODE(PAP_ABS.PTO_INPUT_VALUE_ID
, NULL
, DECODE(PAP_CO.CO_INPUT_VALUE_ID
, NULL
, DECODE(NCR.ABSENCE_ATTENDANCE_TYPE_ID
, NULL
, DECODE(PAP_RES.RESIDUAL_INPUT_VALUE_ID
, NULL
, 'O'
, 'R')
, 'A')
, 'C')
, 'A') RULE_TYPE
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
, PAY_ACCRUAL_PLANS PAP_ABS
, PAY_ACCRUAL_PLANS PAP_CO
, PAY_ACCRUAL_PLANS PAP_RES
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')
AND (NCR.ACCRUAL_PLAN_ID = PAP_ABS.ACCRUAL_PLAN_ID(+)
AND PAP_ABS.PTO_INPUT_VALUE_ID(+) = NCR.INPUT_VALUE_ID)
AND (NCR.ACCRUAL_PLAN_ID = PAP_CO.ACCRUAL_PLAN_ID(+)
AND PAP_CO.CO_INPUT_VALUE_ID(+) = NCR.INPUT_VALUE_ID)
AND (NCR.ACCRUAL_PLAN_ID = PAP_RES.ACCRUAL_PLAN_ID(+)
AND PAP_RES.RESIDUAL_INPUT_VALUE_ID(+) = NCR.INPUT_VALUE_ID)