VIEW: APPS.PAY_KR_SEP_RESULT_NET_INVOL_V

Source

View Text - Preformatted

SELECT /*+RULE*/ paa.assignment_action_id assignment_action_id, paa.assignment_id assignment_id, ppa.effective_date effective_date, ppa.date_earned date_earned, paa.run_type_id run_type_id, prr.run_result_id run_result_id, prrv.input_value_id rrvinput_value_id, ivpbf.input_value_id bfinput_value_id, ivpbf.effective_start_date bfeffective_start_date, ivpbf.effective_end_date bfeffective_end_date, ivpbf.scale scale, hr_general.decode_lookup('ADD_SUBTRACT',ivpbf.scale) uscale, ivpbt.balance_type_id balance_type_id, piv.input_value_id iinput_value_id, piv.effective_start_date ieffective_start_date, piv.effective_end_date ieffective_end_date, piv.name name, pivtl.name uname, pet.element_name element_name, pet.effective_start_date eeffective_start_date, pet.effective_end_date eeffective_end_date, pet.processing_priority processing_priority, pettl.element_name uelement_name, prrv.result_value result_value from pay_element_types_f_tl pettl, pay_element_types_f pet, pay_input_values_f_tl pivtl, pay_input_values_f piv, pay_balance_types ivpbt, pay_balance_feeds_f ivpbf, pay_run_result_values prrv, pay_run_results prr, pay_payroll_actions ppa, pay_assignment_actions paa where ppa.payroll_action_id = paa.payroll_action_id and prr.assignment_action_id = paa.assignment_action_id and prrv.run_result_id = prr.run_result_id and ivpbf.input_value_id = prrv.input_value_id and ppa.effective_date between ivpbf.effective_start_date and ivpbf.effective_end_date and ivpbt.balance_type_id = ivpbf.balance_type_id and ivpbt.balance_name = 'INVOL_DEDUCTIONS' and ivpbt.legislation_code = 'KR' and piv.input_value_id = ivpbf.input_value_id and ppa.effective_date between piv.effective_start_date and piv.effective_end_date and pivtl.input_value_id = piv.input_value_id and pivtl.language = userenv('LANG') and pet.element_type_id = piv.element_type_id and ppa.effective_date between pet.effective_start_date and pet.effective_end_date and pettl.element_type_id = pet.element_type_id and pettl.language = userenv('LANG')

View Text - HTML Formatted

SELECT /*+RULE*/ PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID ASSIGNMENT_ID
, PPA.EFFECTIVE_DATE EFFECTIVE_DATE
, PPA.DATE_EARNED DATE_EARNED
, PAA.RUN_TYPE_ID RUN_TYPE_ID
, PRR.RUN_RESULT_ID RUN_RESULT_ID
, PRRV.INPUT_VALUE_ID RRVINPUT_VALUE_ID
, IVPBF.INPUT_VALUE_ID BFINPUT_VALUE_ID
, IVPBF.EFFECTIVE_START_DATE BFEFFECTIVE_START_DATE
, IVPBF.EFFECTIVE_END_DATE BFEFFECTIVE_END_DATE
, IVPBF.SCALE SCALE
, HR_GENERAL.DECODE_LOOKUP('ADD_SUBTRACT'
, IVPBF.SCALE) USCALE
, IVPBT.BALANCE_TYPE_ID BALANCE_TYPE_ID
, PIV.INPUT_VALUE_ID IINPUT_VALUE_ID
, PIV.EFFECTIVE_START_DATE IEFFECTIVE_START_DATE
, PIV.EFFECTIVE_END_DATE IEFFECTIVE_END_DATE
, PIV.NAME NAME
, PIVTL.NAME UNAME
, PET.ELEMENT_NAME ELEMENT_NAME
, PET.EFFECTIVE_START_DATE EEFFECTIVE_START_DATE
, PET.EFFECTIVE_END_DATE EEFFECTIVE_END_DATE
, PET.PROCESSING_PRIORITY PROCESSING_PRIORITY
, PETTL.ELEMENT_NAME UELEMENT_NAME
, PRRV.RESULT_VALUE RESULT_VALUE
FROM PAY_ELEMENT_TYPES_F_TL PETTL
, PAY_ELEMENT_TYPES_F PET
, PAY_INPUT_VALUES_F_TL PIVTL
, PAY_INPUT_VALUES_F PIV
, PAY_BALANCE_TYPES IVPBT
, PAY_BALANCE_FEEDS_F IVPBF
, PAY_RUN_RESULT_VALUES PRRV
, PAY_RUN_RESULTS PRR
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PRR.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PRRV.RUN_RESULT_ID = PRR.RUN_RESULT_ID
AND IVPBF.INPUT_VALUE_ID = PRRV.INPUT_VALUE_ID
AND PPA.EFFECTIVE_DATE BETWEEN IVPBF.EFFECTIVE_START_DATE
AND IVPBF.EFFECTIVE_END_DATE
AND IVPBT.BALANCE_TYPE_ID = IVPBF.BALANCE_TYPE_ID
AND IVPBT.BALANCE_NAME = 'INVOL_DEDUCTIONS'
AND IVPBT.LEGISLATION_CODE = 'KR'
AND PIV.INPUT_VALUE_ID = IVPBF.INPUT_VALUE_ID
AND PPA.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND PIVTL.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND PIVTL.LANGUAGE = USERENV('LANG')
AND PET.ELEMENT_TYPE_ID = PIV.ELEMENT_TYPE_ID
AND PPA.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND PETTL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PETTL.LANGUAGE = USERENV('LANG')