9479: ,c_payroll_id IN NUMBER
9480: ,c_from_date IN DATE
9481: ,c_to_date IN DATE) IS
9482: SELECT NVL(SUM(a.result_value),0) result_value
9483: FROM pay_run_result_values a
9484: ,pay_element_types_f b
9485: ,pay_assignment_actions d
9486: ,pay_payroll_actions e
9487: ,per_time_periods g
9677: ,p_assignment_id IN NUMBER
9678: ,p_payroll_id IN NUMBER
9679: ,p_first_pymt IN VARCHAR2) IS
9680: SELECT a.result_value
9681: FROM pay_run_result_values a
9682: ,pay_element_types_f b
9683: ,pay_assignment_actions d
9684: ,pay_payroll_actions e
9685: ,per_time_periods g