APPS.PAY_APAC_PAYSLIP_ARCHIVE dependencies on PAY_INPUT_VALUES_F_TL

Line 145: pay_input_values_f_tl pivtl

141: IS
142: SELECT piv.uom,
143: pivtl.name
144: FROM pay_input_values_f piv,
145: pay_input_values_f_tl pivtl
146: WHERE piv.input_value_id = p_input_value_id
147: AND pivtl.input_value_id = piv.input_value_id
148: AND pivtl.language = userenv('LANG')
149: AND p_effective_date BETWEEN piv.effective_start_date