View: PAY_FR_NET_CALC_RULES_V

Product:	PAY - Payroll
Description:	This View is Used in the View Accruals Form for displaying French Specific details
Implementation/DBA Data:	APPS.PAY_FR_NET_CALC_RULES_V

View Text

SELECT 100 NET_RULE_TYPE
, PEE.ASSIGNMENT_ID NET_CALCULATION_RULE_ID
, PAP.ACCRUAL_PLAN_ID ACCRUAL_PLAN_ID
, SUM(TO_NUMBER(PEEV1.SCREEN_ENTRY_VALUE)) INPUT_VALUE_ID
, FND_DATE.DATE_TO_DISPLAYDATE(PEE.EFFECTIVE_START_DATE) INPUT_VALUE_NAME
, PET.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, PETTL.ELEMENT_NAME ELEMENT_TYPE_NAME
, TO_CHAR(PEEV.INPUT_VALUE_ID) ADD_OR_SUBTRACT
, PEEV.SCREEN_ENTRY_VALUE ADD_OR_SUBTRACT_NAME
, PAP.ACCRUAL_UNITS_OF_MEASURE ACCRUAL_UNITS_OF_MEASURE
, HR_GENERAL.DECODE_LOOKUP('HOURS_OR_DAYS'
, PAP.ACCRUAL_UNITS_OF_MEASURE) ACCRUAL_UNITS_OF_MEASURE_NAME
FROM PAY_ELEMENT_ENTRY_VALUES_F PEEV
, PAY_ELEMENT_ENTRY_VALUES_F PEEV1
, PAY_ELEMENT_ENTRIES_F PEE
, PAY_ELEMENT_LINKS_F PEL
, PAY_INPUT_VALUES_F PIV
, PAY_ELEMENT_TYPES_F_TL PETTL
, PAY_ELEMENT_TYPES_F PET
, PAY_ACCRUAL_PLANS PAP
, FND_SESSIONS SES
WHERE PEEV.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND ((PEEV.INPUT_VALUE_ID = TO_NUMBER(PAP.INFORMATION23)) OR (PEEV.INPUT_VALUE_ID = TO_NUMBER(PAP.INFORMATION24)) OR (PEEV.INPUT_VALUE_ID = TO_NUMBER(PAP.INFORMATION25)))
AND PEEV1.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND ((PEEV1.INPUT_VALUE_ID = TO_NUMBER(PAP.INFORMATION8)) OR (PEEV1.INPUT_VALUE_ID = TO_NUMBER(PAP.INFORMATION9)) OR (PEEV1.INPUT_VALUE_ID = TO_NUMBER(PAP.INFORMATION10)) OR (PEEV1.INPUT_VALUE_ID = TO_NUMBER(PAP.INFORMATION11)) OR (PEEV1.INPUT_VALUE_ID = TO_NUMBER(PAP.INFORMATION12)) OR (PEEV1.INPUT_VALUE_ID = TO_NUMBER(PAP.INFORMATION13)) OR (PEEV1.INPUT_VALUE_ID = TO_NUMBER(PAP.INFORMATION14)) OR (PEEV1.INPUT_VALUE_ID = TO_NUMBER(PAP.INFORMATION15)) OR (PEEV1.INPUT_VALUE_ID = TO_NUMBER(PAP.INFORMATION16)) OR (PEEV1.INPUT_VALUE_ID = TO_NUMBER(PAP.INFORMATION17)) OR (PEEV1.INPUT_VALUE_ID = TO_NUMBER(PAP.INFORMATION18)) OR (PEEV1.INPUT_VALUE_ID = TO_NUMBER(PAP.INFORMATION19)) OR (PEEV1.INPUT_VALUE_ID = TO_NUMBER(PAP.INFORMATION20)) OR (PEEV1.INPUT_VALUE_ID = TO_NUMBER(PAP.INFORMATION21)) OR (PEEV1.INPUT_VALUE_ID = TO_NUMBER(PAP.INFORMATION22)) )
AND PEEV1.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND PEE.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID
AND PEL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PET.ELEMENT_TYPE_ID = PIV.ELEMENT_TYPE_ID
AND PET.ELEMENT_TYPE_ID = PETTL.ELEMENT_TYPE_ID
AND PETTL.LANGUAGE = USERENV ('LANG')
AND PAP.ACCRUAL_CATEGORY IN ('FR_MAIN_HOLIDAY'
, 'FR_RTT_HOLIDAY'
, 'FR_ADDITIONAL_HOLIDAY')
AND SES.EFFECTIVE_DATE BETWEEN PEL.EFFECTIVE_START_DATE
AND PEL.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND SES.SESSION_ID = USERENV ('SESSIONID') GROUP BY 100
, PAP.ACCRUAL_UNITS_OF_MEASURE
, PEE.ASSIGNMENT_ID
, PAP.ACCRUAL_PLAN_ID
, PET.ELEMENT_TYPE_ID
, PETTL.ELEMENT_NAME
, PEEV.INPUT_VALUE_ID
, FND_DATE.DATE_TO_DISPLAYDATE(PEE.EFFECTIVE_START_DATE)
, PEEV.SCREEN_ENTRY_VALUE UNION SELECT 200
, PEE.ASSIGNMENT_ID
, PAP.ACCRUAL_PLAN_ID
, -1 * ( NVL(TO_NUMBER (PAA.ABS_INFORMATION2)
, 0) + NVL(TO_NUMBER(PAA.ABS_INFORMATION3)
, 0) + NVL(TO_NUMBER(PAA.ABS_INFORMATION4)
, 0) + NVL(TO_NUMBER(PAA.ABS_INFORMATION5)
, 0) + NVL(TO_NUMBER(PAA.ABS_INFORMATION6)
, 0))
, FND_DATE.DATE_TO_DISPLAYDATE(PEE.EFFECTIVE_START_DATE)
, PET.ELEMENT_TYPE_ID
, PETTL.ELEMENT_NAME
, TO_CHAR(PIV.INPUT_VALUE_ID)
, PAA.ABS_INFORMATION1
, PAP.ACCRUAL_UNITS_OF_MEASURE
, HR_GENERAL.DECODE_LOOKUP('HOURS_OR_DAYS'
, PAP.ACCRUAL_UNITS_OF_MEASURE) ACCRUAL_UNITS_OF_MEASURE_NAME
FROM PAY_ELEMENT_ENTRIES_F PEE
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_TYPES_F PET
, PAY_INPUT_VALUES_F PIV
, PAY_ELEMENT_TYPES_F_TL PETTL
, PAY_ACCRUAL_PLANS PAP
, PER_ABSENCE_ATTENDANCES PAA
, FND_SESSIONS SES
WHERE PEE.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID
AND PEL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PET.ELEMENT_TYPE_ID = PETTL.ELEMENT_TYPE_ID
AND PETTL.LANGUAGE = USERENV ('LANG')
AND PET.ELEMENT_TYPE_ID = PIV.ELEMENT_TYPE_ID
AND PIV.INPUT_VALUE_ID = PAP.PTO_INPUT_VALUE_ID
AND PEE.CREATOR_ID = PAA.ABSENCE_ATTENDANCE_ID
AND PAA.ABS_INFORMATION_CATEGORY IN('FR_FR_MAIN_HOLIDAY'
, 'FR_FR_RTT_HOLIDAY'
, 'FR_FR_ADDITIONAL_HOLIDAY')
AND SES.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PEL.EFFECTIVE_START_DATE
AND PEL.EFFECTIVE_END_DATE
AND SES.SESSION_ID = USERENV ('SESSIONID')

Columns