APPS.PAY_YEAR_END_EXTRACT dependencies on PAY_RUN_RESULT_VALUES

Line 473: ,pay_run_result_values TARGET

469: 100*nvl(sum(decode(substr(bal.balance_name,6),'CO',
470: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) CO
471: from pay_balance_feeds_f FEED
472: ,pay_balance_types BAL
473: ,pay_run_result_values TARGET
474: ,pay_run_results RR
475: ,pay_element_entry_values_f EV_SCON
476: ,pay_element_entries_f E_NI
477: ,pay_element_links_f EL_NI

Line 1743: pay_run_result_values rrv

1739: max(decode(name,'Tax Basis',result_value,null)) Tax_Basis,
1740: 100 * fnd_number.canonical_to_number(max(decode(name,'Pay Previous',result_value,null))) Pay_previous,
1741: 100 * fnd_number.canonical_to_number(max(decode(name,'Tax Previous',result_value,null))) Tax_previous
1742: from pay_input_values_f v,
1743: pay_run_result_values rrv
1744: where rrv.RUN_RESULT_ID = ye_asg.TAX_RUN_RESULT_ID
1745: and v.INPUT_VALUE_ID = rrv.INPUT_VALUE_ID
1746: and v.element_type_id = l_paye_details_id )
1747: where ye_asg.tax_code is null