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_KW_MONTHLY_REPORTS dependencies on PAY_RUN_RESULTS

Line 443: ,pay_run_results prr

439: l_deduction_amt := 0;
440: SELECT NVL(SUM(rrv.RESULT_VALUE),0)
441: INTO l_deduction_amt
442: FROM pay_element_entries_f pee
443: ,pay_run_results prr
444: ,pay_run_result_values rrv
445: ,pay_input_values_f piv
446: WHERE rrv.RUN_RESULT_ID = prr.RUN_RESULT_ID
447: AND prr.assignment_action_id = rec_get_assacts.assignment_action_id

Line 1044: ,pay_run_results prr

1040: /*Cursor for fetching deduction values*/
1041: CURSOR csr_get_ded_value(p_deduction_code VARCHAR2) IS
1042: SELECT NVL(SUM(rrv.RESULT_VALUE),0)
1043: FROM pay_element_entries_f pee
1044: ,pay_run_results prr
1045: ,pay_run_result_values rrv
1046: ,pay_input_values_f piv
1047: WHERE rrv.RUN_RESULT_ID = prr.RUN_RESULT_ID
1048: AND prr.assignment_action_id = rec_get_emp.assignment_action_id