APPS.PAY_KW_MONTHLY_REPORTS dependencies on PAY_RUN_RESULTS

Line 511: ,pay_run_results prr

507: l_deduction_amt := 0;
508: SELECT NVL(SUM(rrv.RESULT_VALUE),0)
509: INTO l_deduction_amt
510: FROM pay_element_entries_f pee
511: ,pay_run_results prr
512: ,pay_run_result_values rrv
513: ,pay_input_values_f piv
514: WHERE rrv.RUN_RESULT_ID = prr.RUN_RESULT_ID
515: AND prr.assignment_action_id = rec_get_assacts.assignment_action_id

Line 1195: ,pay_run_results prr

1191: /*Cursor for fetching deduction values*/
1192: CURSOR csr_get_ded_value(p_deduction_code VARCHAR2) IS
1193: SELECT NVL(SUM(rrv.RESULT_VALUE),0)
1194: FROM pay_element_entries_f pee
1195: ,pay_run_results prr
1196: ,pay_run_result_values rrv
1197: ,pay_input_values_f piv
1198: WHERE rrv.RUN_RESULT_ID = prr.RUN_RESULT_ID
1199: AND prr.assignment_action_id = rec_get_emp.assignment_action_id