DBA Data[Home] [Help]

APPS.PER_BF_BALANCE_AMOUNTS_API dependencies on PAY_ELEMENT_TYPES_F

Line 23: FROM pay_element_types_f et

19: -- Cursor to retrieve the currency code from element type.
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