VIEW: APPS.PAY_IE_SOE_PRSI_DETAILS_V

Source

View Text - Preformatted

SELECT /*+ ORDERED INDEX(SES FND_SESSIONS_U1) INDEX(PET PAY_ELEMENT_TYPES_F_UK2) INDEX(PRR PAY_RUN_RESULTS_N50) INDEX(PIV PAY_INPUT_VALUES_F_N50) INDEX(PRRV PAY_RUN_RESULT_VALUES_PK) */ prr.assignment_action_id, MAX (DECODE (piv.NAME, 'Contribution Class', prrv.result_value, NULL)) contribution_class, MAX (DECODE (piv.NAME, 'Subclass', prrv.result_value, NULL)) overridden_subclass FROM fnd_sessions ses, pay_element_types_f pet, pay_run_results prr, pay_input_values_f piv, pay_run_result_values prrv WHERE pet.element_type_id = prr.element_type_id AND pet.element_name = 'IE PRSI Detail' AND pet.legislation_code = 'IE' AND prr.run_result_id = prrv.run_result_id AND piv.input_value_id = prrv.input_value_id AND piv.NAME IN ('Contribution Class', 'Subclass' ) AND piv.element_type_id = pet.element_type_id AND ses.session_id = USERENV ('sessionid') 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 GROUP BY prr.assignment_action_id

View Text - HTML Formatted

SELECT /*+ ORDERED INDEX(SES FND_SESSIONS_U1) INDEX(PET PAY_ELEMENT_TYPES_F_UK2) INDEX(PRR PAY_RUN_RESULTS_N50) INDEX(PIV PAY_INPUT_VALUES_F_N50) INDEX(PRRV PAY_RUN_RESULT_VALUES_PK) */ PRR.ASSIGNMENT_ACTION_ID
, MAX (DECODE (PIV.NAME
, 'CONTRIBUTION CLASS'
, PRRV.RESULT_VALUE
, NULL)) CONTRIBUTION_CLASS
, MAX (DECODE (PIV.NAME
, 'SUBCLASS'
, PRRV.RESULT_VALUE
, NULL)) OVERRIDDEN_SUBCLASS
FROM FND_SESSIONS SES
, PAY_ELEMENT_TYPES_F PET
, PAY_RUN_RESULTS PRR
, PAY_INPUT_VALUES_F PIV
, PAY_RUN_RESULT_VALUES PRRV
WHERE PET.ELEMENT_TYPE_ID = PRR.ELEMENT_TYPE_ID
AND PET.ELEMENT_NAME = 'IE PRSI DETAIL'
AND PET.LEGISLATION_CODE = 'IE'
AND PRR.RUN_RESULT_ID = PRRV.RUN_RESULT_ID
AND PIV.INPUT_VALUE_ID = PRRV.INPUT_VALUE_ID
AND PIV.NAME IN ('CONTRIBUTION CLASS'
, 'SUBCLASS' )
AND PIV.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND SES.SESSION_ID = USERENV ('SESSIONID')
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 GROUP BY PRR.ASSIGNMENT_ACTION_ID