[Home] [Help]
SELECT 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, piv.input_value_id input_value_id, piv.name name, piv.display_sequence display_sequence, piv.hot_default_flag hot_default_flag, piv.default_value idefault_value, piv.element_type_id element_type_id, pivt.name uname, prrv.result_value result_value from pay_input_values_f_tl pivt, pay_input_values_f piv, 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 piv.input_value_id = prrv.input_value_id and ppa.date_earned between piv.effective_start_date and piv.effective_end_date and pivt.input_value_id = piv.input_value_id and pivt.language = userenv('LANG')
SELECT 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
, PIV.INPUT_VALUE_ID INPUT_VALUE_ID
, PIV.NAME NAME
, PIV.DISPLAY_SEQUENCE DISPLAY_SEQUENCE
, PIV.HOT_DEFAULT_FLAG HOT_DEFAULT_FLAG
, PIV.DEFAULT_VALUE IDEFAULT_VALUE
, PIV.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, PIVT.NAME UNAME
, PRRV.RESULT_VALUE RESULT_VALUE
FROM PAY_INPUT_VALUES_F_TL PIVT
, PAY_INPUT_VALUES_F PIV
, 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 PIV.INPUT_VALUE_ID = PRRV.INPUT_VALUE_ID
AND PPA.DATE_EARNED BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND PIVT.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND PIVT.LANGUAGE = USERENV('LANG')
|
|
|
|