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

Line 454: FROM pay_assignment_actions paa, pay_payroll_actions ppa, pay_run_results prr, pay_run_result_values prrv

450: p_report_end_date DATE,
451: p_input_value_id NUMBER
452: ) IS
453: SELECT prrv.result_value start_date
454: FROM pay_assignment_actions paa, pay_payroll_actions ppa, pay_run_results prr, pay_run_result_values prrv
455: WHERE ppa.effective_date BETWEEN p_report_start_date AND p_report_end_date
456: AND ppa.payroll_action_id = paa.payroll_action_id
457: AND paa.assignment_id = p_assignment_id
458: AND paa.assignment_action_id = prr.assignment_action_id

Line 473: FROM pay_run_result_values prrv

469: p_report_end_date DATE
470:
471: ) IS
472: SELECT sum (fnd_number.canonical_to_number (result_value))
473: FROM pay_run_result_values prrv
474: WHERE input_value_id = p_input_value_id
475: AND run_result_id IN (SELECT prr.run_result_id
476: FROM pay_assignment_actions paa, pay_payroll_actions ppa,pay_run_result_values prrv1,
477: pay_run_results prr

Line 476: FROM pay_assignment_actions paa, pay_payroll_actions ppa,pay_run_result_values prrv1,

472: SELECT sum (fnd_number.canonical_to_number (result_value))
473: FROM pay_run_result_values prrv
474: WHERE input_value_id = p_input_value_id
475: AND run_result_id IN (SELECT prr.run_result_id
476: FROM pay_assignment_actions paa, pay_payroll_actions ppa,pay_run_result_values prrv1,
477: pay_run_results prr
478: WHERE ppa.effective_date BETWEEN p_report_start_date AND p_report_end_date
479: AND ppa.payroll_action_id = paa.payroll_action_id
480: AND paa.assignment_id = p_assignment_id