APPS.AP_OPEN_ITEMS_REVAL_PKG dependencies on GL_SETS_OF_BOOKS

Line 797: FUNCTION get_currency_code(l_currency_code IN gl_sets_of_books.currency_code%type)

793: ';
794:
795: -- for getting the currency code
796: /*Bug 14136626*/
797: FUNCTION get_currency_code(l_currency_code IN gl_sets_of_books.currency_code%type)
798: RETURN VARCHAR2 IS
799: l_derive_type gl_sets_of_books.currency_code%type;
800: BEGIN
801: -- Get derive type for currency

Line 799: l_derive_type gl_sets_of_books.currency_code%type;

795: -- for getting the currency code
796: /*Bug 14136626*/
797: FUNCTION get_currency_code(l_currency_code IN gl_sets_of_books.currency_code%type)
798: RETURN VARCHAR2 IS
799: l_derive_type gl_sets_of_books.currency_code%type;
800: BEGIN
801: -- Get derive type for currency
802: SELECT nvl(derive_type,l_currency_code)
803: INTO l_derive_type

Line 816: function get_revaluation_rate(l_currency_code IN gl_sets_of_books.currency_code%type,

812: END get_currency_code;
813:
814: -- for getting the revaluation rate
815: /*Bug 14136626*/
816: function get_revaluation_rate(l_currency_code IN gl_sets_of_books.currency_code%type,
817: l_pay_cross_rate_type IN gl_sets_of_books.currency_code%type)
818: return number is
819:
820: l_fixed_rate BOOLEAN;

Line 817: l_pay_cross_rate_type IN gl_sets_of_books.currency_code%type)

813:
814: -- for getting the revaluation rate
815: /*Bug 14136626*/
816: function get_revaluation_rate(l_currency_code IN gl_sets_of_books.currency_code%type,
817: l_pay_cross_rate_type IN gl_sets_of_books.currency_code%type)
818: return number is
819:
820: l_fixed_rate BOOLEAN;
821: l_multiply_factor NUMBER := 1;

Line 957: from gl_sets_of_books gsob,

953: g_base_precision,
954: g_base_min_acct_unit,
955: g_base_currency_desc,
956: g_coa_id
957: from gl_sets_of_books gsob,
958: ap_system_parameters_all asp,
959: fnd_currencies_vl fc
960: where gsob.set_of_books_id = asp.set_of_books_id
961: and fc.currency_code = gsob.currency_code