DBA Data[Home] [Help]

APPS.PER_BF_BALANCE_AMOUNTS_API dependencies on PAY_INPUT_VALUES_F

Line 24: , pay_input_values_f iv

20: CURSOR csr_et_currency_code (p_input_value_id NUMBER )IS
21: SELECT et.input_currency_code
22: , iv.uom
23: FROM pay_element_types_f et
24: , pay_input_values_f iv
25: WHERE iv.input_value_id = p_input_value_id
26: AND iv.element_type_id = et.element_type_id
27: AND p_effective_date BETWEEN
28: iv.effective_start_date AND iv.effective_end_date