APPS.JAI_RCV_UTILS_PKG dependencies on GL_SETS_OF_BOOKS

Line 91: v_set_of_books_id gl_sets_of_books.set_of_books_id % type;

87: PROCEDURE get_func_curr (p_organization_id number,
88: p_func_currency OUT NOCOPY varchar2,
89: p_gl_set_of_books_id OUT NOCOPY number)
90: IS
91: v_set_of_books_id gl_sets_of_books.set_of_books_id % type;
92: v_func_currency gl_sets_of_books.currency_code % type;
93: v_currency_conversion_rate rcv_transactions.currency_conversion_type % type;
94:
95: /* Bug 5243532. Added by Lakshmi Gopalsami

Line 92: v_func_currency gl_sets_of_books.currency_code % type;

88: p_func_currency OUT NOCOPY varchar2,
89: p_gl_set_of_books_id OUT NOCOPY number)
90: IS
91: v_set_of_books_id gl_sets_of_books.set_of_books_id % type;
92: v_func_currency gl_sets_of_books.currency_code % type;
93: v_currency_conversion_rate rcv_transactions.currency_conversion_type % type;
94:
95: /* Bug 5243532. Added by Lakshmi Gopalsami
96: * Defined variable for implementing caching logic.

Line 114: FROM gl_sets_of_books

110:
111: ELSE
112: FND_PROFILE.GET('GL_SET_OF_BKS_ID', v_set_of_books_id);
113: For org_rec IN (SELECT currency_code
114: FROM gl_sets_of_books
115: WHERE set_of_books_id = v_set_of_books_id)
116: LOOP
117: v_func_currency := org_rec.currency_code;
118: END LOOP;