DBA Data[Home] [Help]

APPS.IGI_IAC_REBASE_PKG dependencies on GL_SETS_OF_BOOKS

Line 82: Cursor cur_get_precision(p_sob_id gl_sets_of_books.set_of_books_id%type) Is

78: where start_date =l_date_from and end_date = l_date_to and
79: calendar_type= calendar;
80:
81: /* Cursor to get the precision */
82: Cursor cur_get_precision(p_sob_id gl_sets_of_books.set_of_books_id%type) Is
83: select curr.precision
84: from fnd_currencies curr, gl_sets_of_books sob
85: where curr.currency_code = sob.currency_code
86: and sob.set_of_books_id = p_sob_id;

Line 84: from fnd_currencies curr, gl_sets_of_books sob

80:
81: /* Cursor to get the precision */
82: Cursor cur_get_precision(p_sob_id gl_sets_of_books.set_of_books_id%type) Is
83: select curr.precision
84: from fnd_currencies curr, gl_sets_of_books sob
85: where curr.currency_code = sob.currency_code
86: and sob.set_of_books_id = p_sob_id;
87:
88: l_link_id igi_iac_cal_price_indexes.cal_price_index_link_id%type;

Line 108: l_sob_id gl_sets_of_books.set_of_books_id%type;

104:
105: l_cal_price_indexes_rec c_get_cal_price_indexes%rowtype;
106:
107: l_rowcount number;
108: l_sob_id gl_sets_of_books.set_of_books_id%type;
109: l_precision number;
110:
111: IGI_IAC_INDEX_PERIOD_NOT_FOUND Exception;
112: IGI_IAC_PRICE_INDEX_ZERO Exception;