[Home] [Help]
608: to_number(max(decode(name,'Tax Previous',
609: fnd_number.canonical_to_number(result_value),NULL)))
610: tax_previous
611: FROM pay_input_values_f v,
612: pay_run_result_values rrv
613: WHERE rrv.run_result_id = l_run_result_id
614: AND v.input_value_id = rrv.input_value_id
615: AND v.element_type_id = l_element_type_id;
616:
721: and act.action_status = 'C'
722: and pact.payroll_action_id = act.payroll_action_id
723: and act.action_sequence = (
724: select /*+ ORDERED use_nl(a,pact2,t,r,v,f)
725: user_index(v, PAY_RUN_RESULT_VALUES_PK) */
726: max(a.action_sequence)
727: from pay_assignment_actions a
728: ,pay_payroll_actions pact2
729: ,pay_balance_types t
728: ,pay_payroll_actions pact2
729: ,pay_balance_types t
730: ,pay_balance_feeds_f f
731: ,pay_run_results r
732: ,pay_run_result_values v
733: where t.balance_name in ('Taxable Pay','PAYE')
734: and t.legislation_code = 'GB'
735: and f.balance_type_id = t.balance_type_id
736: and v.input_value_id = f.input_value_id
834: sys.dual target where exists
835: (select 1
836: from PAY_BALANCE_FEEDS_F FEED
837: , PAY_BALANCE_TYPES PBT
838: , PAY_RUN_RESULT_VALUES PRRV
839: , PAY_RUN_RESULTS PRR
840: WHERE PBT.BALANCE_NAME in ('Taxable Pay', 'PAYE')
841: AND PBT.LEGISLATION_CODE = 'GB'
842: AND PBT.BALANCE_TYPE_ID = FEED.BALANCE_TYPE_ID
2006: (select prrv.result_value
2007: from pay_input_values_f inv,
2008: pay_element_types_f type,
2009: pay_run_results prr,
2010: pay_run_result_values prrv
2011: where prrv.input_value_id = inv.input_value_id
2012: and inv.name = 'Tax Code'
2013: and prr.assignment_action_id = c_assignment_action_id
2014: and c_effective_end_date between
2905: AND name = p_ipv_name;
2906: --
2907: CURSOR csr_result_value(p_ipv_id IN NUMBER) IS
2908: SELECT result_value
2909: FROM pay_run_result_values
2910: WHERE run_result_id = l_max_run_result_id
2911: AND input_value_id = p_ipv_id;
2912: --
2913: CURSOR csr_max_run_result IS