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 865: from pay_input_values_f v,

861: to_number(max(decode(name,'Pay Previous',
862: fnd_number.canonical_to_number(result_value),NULL))) pay_previous,
863: to_number(max(decode(name,'Tax Previous',
864: fnd_number.canonical_to_number(result_value),NULL))) tax_previous
865: from pay_input_values_f v,
866: pay_run_result_values rrv
867: where rrv.run_result_id = l_run_result_id
868: and v.input_value_id = rrv.input_value_id
869: and v.element_type_id = l_element_type_id;

Line 879: pay_input_values_f iv,

875: max(decode(iv.name,'Pay Previous',screen_entry_value)) pay_previous,
876: max(decode(iv.name,'Tax Previous',screen_entry_value)) tax_previous
877: from pay_element_entries_f e,
878: pay_element_entry_values_f v,
879: pay_input_values_f iv,
880: pay_element_links_f link
881: where e.assignment_id = l_assignment_id
882: and link.element_type_id = l_paye_details_id
883: and e.element_link_id = link.element_link_id

Line 1245: pay_input_values_f inv,

1241: nvl(min(decode(inv.name, 'End Date', eev.screen_entry_value, null)),'4712/12/31 00:00:00') e_date,
1242: 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
1243: from pay_element_types_f elt,
1244: pay_element_entries_f ele,
1245: pay_input_values_f inv,
1246: pay_element_entry_values_f eev
1247: where elt.element_name = 'Student Loan'
1248: and ele.element_type_id = elt.element_type_id
1249: and ele.assignment_id = p_person_rec.assignment_id