APPS.PAY_GB_RTI_EYU dependencies on PAY_INPUT_VALUES_F

Line 626: FROM pay_input_values_f v,

622:
623: CURSOR csr_run_result(p_run_result_id number,p_element_type_id number) IS
624: SELECT max(decode(name,'Tax Code',result_value,NULL)) tax_code,
625: max(decode(name,'Tax Basis',result_value,NULL)) tax_basis
626: FROM pay_input_values_f v,
627: pay_run_result_values rrv
628: WHERE rrv.run_result_id = p_run_result_id
629: AND v.input_value_id = rrv.input_value_id
630: AND v.element_type_id = p_element_type_id;

Line 637: pay_input_values_f iv,

633: SELECT max(decode(iv.name,'Tax Code',screen_entry_value)) tax_code,
634: max(decode(iv.name,'Tax Basis',DECODE(screen_entry_value,'N','Y',NULL),NULL)) tax_basis -- kvinayku bug no 14774165
635: FROM pay_element_entries_f e,
636: pay_element_entry_values_f v,
637: pay_input_values_f iv,
638: pay_element_links_f link
639: WHERE e.assignment_id = p_assignment_id
640: AND link.element_type_id = g_paye_details_id
641: AND e.element_link_id = link.element_link_id