[Home] [Help]
306: -- it is possible for the element entry value to have a NULL
307: -- SCON while the Run Result still holds a valid SCON.
308: --
309: select prrv.result_value
310: from pay_run_result_values prrv,
311: pay_run_results prr
312: where prr.source_id = c_element_entry_id
313: and prr.element_type_id = g_ni_id
314: and prr.assignment_action_id = c_assignment_action_id
3335: AND per.effective_start_date <= g_end_year
3336: AND per.effective_end_date >= g_start_year
3337: AND substr(per_information2,1,1) = 'Y')
3338: AND EXISTS (SELECT '1'
3339: FROM pay_run_result_values prrv
3340: WHERE input_value_id = g_process_type_id
3341: AND result_value in ('DY', 'DN', 'DP', 'DR', 'PY')
3342: AND run_result_id = (SELECT to_number(substr(max(lpad(to_char(act.action_sequence),15,'0')|| lpad(to_char(prr.run_result_id),19,'0')),16))
3343: FROM pay_payroll_Actions pact,
3446: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3447: rebate_emp
3448: FROM pay_balance_feeds_f feed
3449: ,pay_balance_types bal
3450: ,pay_run_result_values target
3451: ,pay_run_results rr
3452: ,pay_element_entry_values_f ev_scon
3453: ,pay_element_entry_values_f ev_cat
3454: ,pay_element_entries_f e_ni
3704: 100 * to_number(max(decode(name,'Tax Previous',
3705: fnd_number.canonical_to_number(result_value),NULL)))
3706: tax_previous
3707: FROM pay_input_values_f v,
3708: pay_run_result_values rrv
3709: WHERE rrv.run_result_id = p_tax_run_result_id
3710: AND v.input_value_id = rrv.input_value_id
3711: AND v.element_type_id = g_paye_details_id;
3712: --
3719: 100 * to_number(max(decode(name,'Tax Previous',
3720: fnd_number.canonical_to_number(result_value),NULL)))
3721: tax_previous
3722: FROM pay_input_values_f v,
3723: pay_run_result_values rrv
3724: WHERE rrv.run_result_id = p_tax_run_result_id
3725: AND v.input_value_id = rrv.input_value_id
3726: AND v.element_type_id = g_paye_element_id;
3727: --