APPS.GMF_GL_GET_BALANCES dependencies on GL_SETS_OF_BOOKS

Line 18: , l_currency_code gl_sets_of_books.currency_code%TYPE -- Bug 4066174 Added

14: , in_ytd_ptd number
15: , in_from_segments gmf_segment_values_tbl
16: , in_to_segments gmf_segment_values_tbl
17: , l_segment_delimiter VARCHAR2
18: , l_currency_code gl_sets_of_books.currency_code%TYPE -- Bug 4066174 Added
19: )
20: IS
21: SELECT /*+ index(glbal gl_balances_n1 ) */
22: in_set_of_books,

Line 158: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;

154: segment_where_clause VARCHAR2(4000);
155: l_from_segments gmf_segment_values_tbl;
156: l_to_segments gmf_segment_values_tbl;
157: l_application_id fnd_application.application_id%TYPE;
158: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
159: l_currency_code gl_sets_of_books.currency_code%TYPE;
160: l_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
161:
162: BEGIN

Line 159: l_currency_code gl_sets_of_books.currency_code%TYPE;

155: l_from_segments gmf_segment_values_tbl;
156: l_to_segments gmf_segment_values_tbl;
157: l_application_id fnd_application.application_id%TYPE;
158: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
159: l_currency_code gl_sets_of_books.currency_code%TYPE;
160: l_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
161:
162: BEGIN
163:

Line 160: l_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;

156: l_to_segments gmf_segment_values_tbl;
157: l_application_id fnd_application.application_id%TYPE;
158: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
159: l_currency_code gl_sets_of_books.currency_code%TYPE;
160: l_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
161:
162: BEGIN
163:
164: /***** Bug 4066174 - Added the new queries below *****/

Line 173: FROM gl_sets_of_books

169: WHERE application_short_name = 'SQLGL' ;
170:
171: SELECT currency_code,set_of_books_id, chart_of_accounts_id
172: INTO l_currency_code, l_set_of_books_id, l_chart_of_accounts_id
173: FROM gl_sets_of_books
174: WHERE set_of_books_id = in_set_of_books;
175:
176: SELECT fifstr.concatenated_segment_delimiter
177: INTO l_segment_delimiter