eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_MOVDED_EDI dependencies on PAY_INPUT_VALUES_F

Line 675: from pay_input_values_f v,

671: to_number(max(decode(name,'Pay Previous',
672: fnd_number.canonical_to_number(result_value),NULL))) pay_previous,
673: to_number(max(decode(name,'Tax Previous',
674: fnd_number.canonical_to_number(result_value),NULL))) tax_previous
675: from pay_input_values_f v,
676: pay_run_result_values rrv
677: where rrv.run_result_id = l_run_result_id
678: and v.input_value_id = rrv.input_value_id
679: and v.element_type_id = l_element_type_id;

Line 689: pay_input_values_f iv,

685: max(decode(iv.name,'Pay Previous',screen_entry_value)) pay_previous,
686: max(decode(iv.name,'Tax Previous',screen_entry_value)) tax_previous
687: from pay_element_entries_f e,
688: pay_element_entry_values_f v,
689: pay_input_values_f iv,
690: pay_element_links_f link
691: where e.assignment_id = l_assignment_id
692: and link.element_type_id = l_paye_details_id
693: and e.element_link_id = link.element_link_id

Line 1044: pay_input_values_f inv,

1040: nvl(min(decode(inv.name, 'End Date', eev.screen_entry_value, null)),'4712/12/31 00:00:00') e_date,
1041: fnd_date.date_to_canonical(min(decode(inv.name, 'End Date', eev.effective_end_date, fnd_date.canonical_to_date('4712/12/31 00:00:00')))) eff_date
1042: from pay_element_types_f elt,
1043: pay_element_entries_f ele,
1044: pay_input_values_f inv,
1045: pay_element_entry_values_f eev
1046: where elt.element_name = 'Student Loan'
1047: and ele.element_type_id = elt.element_type_id
1048: and ele.assignment_id = p_person_rec.assignment_id