[Home] [Help]
330: -- it is possible for the element entry value to have a NULL
331: -- SCON while the Run Result still holds a valid SCON.
332: --
333: select prrv.result_value
334: from pay_run_result_values prrv,
335: pay_run_results prr
336: where prr.source_id = c_element_entry_id
337: and prr.element_type_id = g_ni_id
338: and prr.assignment_action_id = c_assignment_action_id
3463: AND per.effective_start_date <= g_end_year
3464: AND per.effective_end_date >= g_start_year
3465: AND substr(per_information2,1,1) = 'Y')
3466: AND EXISTS (SELECT '1'
3467: FROM pay_run_result_values prrv
3468: WHERE input_value_id = g_process_type_id
3469: AND result_value in ('DY', 'DN', 'DP', 'DR', 'PY')
3470: 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))
3471: FROM pay_payroll_Actions pact,
3581: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3582: rebate_emp
3583: FROM pay_balance_feeds_f feed
3584: ,pay_balance_types bal
3585: ,pay_run_result_values target
3586: ,pay_run_results rr
3587: ,pay_element_entry_values_f ev_scon
3588: ,pay_element_entry_values_f ev_cat
3589: ,pay_element_entries_f e_ni
3845: 100 * to_number(max(decode(name,'Tax Previous',
3846: fnd_number.canonical_to_number(result_value),NULL)))
3847: tax_previous
3848: FROM pay_input_values_f v,
3849: pay_run_result_values rrv
3850: WHERE rrv.run_result_id = p_tax_run_result_id
3851: AND v.input_value_id = rrv.input_value_id
3852: AND v.element_type_id = g_paye_details_id;
3853: --
3860: 100 * to_number(max(decode(name,'Tax Previous',
3861: fnd_number.canonical_to_number(result_value),NULL)))
3862: tax_previous
3863: FROM pay_input_values_f v,
3864: pay_run_result_values rrv
3865: WHERE rrv.run_result_id = p_tax_run_result_id
3866: AND v.input_value_id = rrv.input_value_id
3867: AND v.element_type_id = g_paye_element_id;
3868: --