DBA Data[Home] [Help]

APPS.PAY_KW_MONTHLY_REPORTS dependencies on PAY_ELEMENT_ENTRIES_F

Line 442: FROM pay_element_entries_f pee

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

Line 1043: FROM pay_element_entries_f pee

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