APPS.PAY_BATCH_ELEMENT_ENTRY_API dependencies on PAY_INPUT_VALUES_F

Line 149: from pay_input_values_f inv

145: --
146: cursor csr_table_inp_ids(p_ele_type_id number
147: ,p_eff_date date) is
148: select inv.uom,inv.lookup_type,inv.value_set_id
149: from pay_input_values_f inv
150: where inv.element_type_id = p_ele_type_id
151: and p_eff_date between inv.effective_start_date
152: and inv.effective_end_date
153: order by inv.display_sequence

Line 156: l_uom pay_input_values_f.uom%TYPE;

152: and inv.effective_end_date
153: order by inv.display_sequence
154: , inv.name;
155: --
156: l_uom pay_input_values_f.uom%TYPE;
157: --
158: l_lookup_type pay_input_values_f.lookup_type%TYPE;
159: l_value_set_id pay_input_values_f.value_set_id%TYPE;
160: l_input_curr_code pay_element_types_f.input_currency_code%TYPE;

Line 158: l_lookup_type pay_input_values_f.lookup_type%TYPE;

154: , inv.name;
155: --
156: l_uom pay_input_values_f.uom%TYPE;
157: --
158: l_lookup_type pay_input_values_f.lookup_type%TYPE;
159: l_value_set_id pay_input_values_f.value_set_id%TYPE;
160: l_input_curr_code pay_element_types_f.input_currency_code%TYPE;
161: --
162: l_element_type_id pay_element_types_f.element_type_id%TYPE := null;

Line 159: l_value_set_id pay_input_values_f.value_set_id%TYPE;

155: --
156: l_uom pay_input_values_f.uom%TYPE;
157: --
158: l_lookup_type pay_input_values_f.lookup_type%TYPE;
159: l_value_set_id pay_input_values_f.value_set_id%TYPE;
160: l_input_curr_code pay_element_types_f.input_currency_code%TYPE;
161: --
162: l_element_type_id pay_element_types_f.element_type_id%TYPE := null;
163: l_element_name pay_element_types_f.element_name%TYPE := null;