DBA Data[Home] [Help]

APPS.PAY_KW_MONTHLY_REPORTS dependencies on PAY_INPUT_VALUES_F

Line 513: ,pay_input_values_f piv

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
516: AND prr.element_entry_id = pee.element_entry_id
517: AND pee.assignment_id = rec_get_assacts.assignment_id

Line 1197: ,pay_input_values_f piv

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
1200: AND prr.element_entry_id = pee.element_entry_id
1201: AND pee.assignment_id = rec_get_emp.assignment_id