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_IE_MEDICAL_ADJUST dependencies on PAY_RUN_RESULT_VALUES

Line 212: pay_run_result_values prrv,

208: select paa.assignment_id, sum(fnd_number.canonical_to_number(prrv1.result_value)) result_value --paa.assignment_action_id, paa.payroll_action_id
209: from pay_assignment_actions paa,
210: pay_payroll_actions ppa,
211: pay_run_results prr,
212: pay_run_result_values prrv,
213: pay_run_result_values prrv1
214: where paa.action_status = 'C'
215: and paa.payroll_action_id = ppa.payroll_action_id
216: and paa.assignment_id = nvl(p_assig_id, paa.assignment_id)

Line 213: pay_run_result_values prrv1

209: from pay_assignment_actions paa,
210: pay_payroll_actions ppa,
211: pay_run_results prr,
212: pay_run_result_values prrv,
213: pay_run_result_values prrv1
214: where paa.action_status = 'C'
215: and paa.payroll_action_id = ppa.payroll_action_id
216: and paa.assignment_id = nvl(p_assig_id, paa.assignment_id)
217: and paa.assignment_action_id = prr.assignment_action_id

Line 234: select result_value from pay_run_result_values where

230: -- Cursor to get result values
231: cursor csr_get_value (p_ele_type_id in number,
232: p_input_val_id in number,
233: p_assg_act_id in number) IS
234: select result_value from pay_run_result_values where
235: input_value_id = p_input_val_id
236: and run_result_id in (select run_result_id from pay_run_results
237: where assignment_action_id = p_assg_act_id
238: and element_type_id = p_ele_type_id) ;