eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAY_FR_NET_CALC_RULES_V

Source

View Text - Preformatted


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')

View Text - HTML Formatted

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')