APPS.PAY_NZ_EMS_TAX_RATE dependencies on PAY_INPUT_VALUES_F

Line 28: l_input_value_id pay_input_values_f.input_value_id%TYPE;

24: )
25: RETURN VARCHAR2
26: IS
27:
28: l_input_value_id pay_input_values_f.input_value_id%TYPE;
29:
30: l_result number := NULL;
31:
32: CURSOR get_rate_input_value

Line 36: FROM pay_input_values_f pivf

32: CURSOR get_rate_input_value
33: (c_effective_date date)
34: IS
35: SELECT pivf.input_value_id
36: FROM pay_input_values_f pivf
37: WHERE pivf.element_type_id = (select distinct element_type_id
38: from pay_element_types_f
39: where legislation_code = 'NZ'
40: and element_name = 'PAYE Information'