DBA Data[Home] [Help]

APPS.PAY_KW_MONTHLY_REPORTS dependencies on PAY_ELEMENT_ENTRIES_F

Line 510: FROM pay_element_entries_f pee

506: EXIT WHEN csr_get_assacts%NOTFOUND;
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

Line 1194: FROM pay_element_entries_f pee

1190:
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