[Home] [Help]
665: to_number(max(decode(name,'Tax Previous',
666: fnd_number.canonical_to_number(result_value),NULL)))
667: tax_previous
668: FROM pay_input_values_f v,
669: pay_run_result_values rrv
670: WHERE rrv.run_result_id = l_run_result_id
671: AND v.input_value_id = rrv.input_value_id
672: AND v.element_type_id = l_element_type_id;
673:
782: and act.action_status = 'C'
783: and pact.payroll_action_id = act.payroll_action_id
784: and act.action_sequence = (
785: select /*+ ORDERED use_nl(a,pact2,t,r,v,f)
786: user_index(v, PAY_RUN_RESULT_VALUES_PK) */
787: max(a.action_sequence)
788: from pay_assignment_actions a
789: ,pay_payroll_actions pact2
790: ,pay_balance_types t
789: ,pay_payroll_actions pact2
790: ,pay_balance_types t
791: ,pay_balance_feeds_f f
792: ,pay_run_results r
793: ,pay_run_result_values v
794: where t.balance_name in ('Taxable Pay','PAYE')
795: and t.legislation_code = 'GB'
796: and f.balance_type_id = t.balance_type_id
797: and v.input_value_id = f.input_value_id
912: sys.dual target where exists
913: (select 1
914: from PAY_BALANCE_FEEDS_F FEED
915: , PAY_BALANCE_TYPES PBT
916: , PAY_RUN_RESULT_VALUES PRRV
917: , PAY_RUN_RESULTS PRR
918: WHERE PBT.BALANCE_NAME in ('Taxable Pay', 'PAYE')
919: AND PBT.LEGISLATION_CODE = 'GB'
920: AND PBT.BALANCE_TYPE_ID = FEED.BALANCE_TYPE_ID
2128: (select prrv.result_value
2129: from pay_input_values_f inv,
2130: pay_element_types_f type,
2131: pay_run_results prr,
2132: pay_run_result_values prrv
2133: where prrv.input_value_id = inv.input_value_id
2134: and inv.name = 'Tax Code'
2135: and prr.assignment_action_id = c_assignment_action_id
2136: /* and c_effective_end_date between
3290: AND name = p_ipv_name;
3291: --
3292: CURSOR csr_result_value(p_ipv_id IN NUMBER) IS
3293: SELECT result_value
3294: FROM pay_run_result_values
3295: WHERE run_result_id = l_max_run_result_id
3296: AND input_value_id = p_ipv_id;
3297: --
3298: CURSOR csr_max_run_result IS