APPS.PAY_NZ_EMS_TAX_RATE dependencies on PAY_RUN_RESULT_VALUES

Line 46: (c_run_result_id pay_run_result_values.run_result_id%TYPE

42: AND upper(pivf.name) = 'TAX RATE'
43: AND c_effective_date between pivf.effective_start_date and pivf.effective_end_date;
44:
45: CURSOR get_rate_result_value
46: (c_run_result_id pay_run_result_values.run_result_id%TYPE
47: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
48: IS
49: SELECT prrv.result_value
50: FROM pay_run_result_values prrv

Line 47: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)

43: AND c_effective_date between pivf.effective_start_date and pivf.effective_end_date;
44:
45: CURSOR get_rate_result_value
46: (c_run_result_id pay_run_result_values.run_result_id%TYPE
47: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
48: IS
49: SELECT prrv.result_value
50: FROM pay_run_result_values prrv
51: WHERE prrv.run_result_id = c_run_result_id

Line 50: FROM pay_run_result_values prrv

46: (c_run_result_id pay_run_result_values.run_result_id%TYPE
47: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
48: IS
49: SELECT prrv.result_value
50: FROM pay_run_result_values prrv
51: WHERE prrv.run_result_id = c_run_result_id
52: AND prrv.input_value_id = c_input_value_id;
53:
54: BEGIN