APPS.GMF_GL_GET_BALANCES dependencies on GL_SETS_OF_BOOKS

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

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

Line 222: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;

218: segment_where_clause VARCHAR2(4000);
219: l_from_segments gmf_segment_values_tbl;
220: l_to_segments gmf_segment_values_tbl;
221: l_application_id fnd_application.application_id%TYPE;
222: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
223: l_currency_code gl_sets_of_books.currency_code%TYPE;
224: l_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
225:
226: /*Bug#12600219 - START *

Line 223: l_currency_code gl_sets_of_books.currency_code%TYPE;

219: l_from_segments gmf_segment_values_tbl;
220: l_to_segments gmf_segment_values_tbl;
221: l_application_id fnd_application.application_id%TYPE;
222: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
223: l_currency_code gl_sets_of_books.currency_code%TYPE;
224: l_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
225:
226: /*Bug#12600219 - START *
227: l_start_segments_ccid number;

Line 224: l_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;

220: l_to_segments gmf_segment_values_tbl;
221: l_application_id fnd_application.application_id%TYPE;
222: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
223: l_currency_code gl_sets_of_books.currency_code%TYPE;
224: l_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
225:
226: /*Bug#12600219 - START *
227: l_start_segments_ccid number;
228: l_to_segments_ccid number;

Line 246: FROM gl_sets_of_books

242: WHERE application_short_name = 'SQLGL' ;
243:
244: SELECT currency_code,set_of_books_id, chart_of_accounts_id
245: INTO l_currency_code, l_set_of_books_id, l_chart_of_accounts_id
246: FROM gl_sets_of_books
247: WHERE set_of_books_id = in_set_of_books;
248:
249: SELECT fifstr.concatenated_segment_delimiter
250: INTO l_segment_delimiter

Line 348: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;

344: segment_where_clause VARCHAR2(4000);
345: l_from_segments gmf_segment_values_tbl;
346: l_to_segments gmf_segment_values_tbl;
347: l_application_id fnd_application.application_id%TYPE;
348: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
349: l_currency_code gl_sets_of_books.currency_code%TYPE;
350: l_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
351:
352: /*Bug#12600219 - START */

Line 349: l_currency_code gl_sets_of_books.currency_code%TYPE;

345: l_from_segments gmf_segment_values_tbl;
346: l_to_segments gmf_segment_values_tbl;
347: l_application_id fnd_application.application_id%TYPE;
348: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
349: l_currency_code gl_sets_of_books.currency_code%TYPE;
350: l_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
351:
352: /*Bug#12600219 - START */
353: l_start_segments_ccid number;

Line 350: l_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;

346: l_to_segments gmf_segment_values_tbl;
347: l_application_id fnd_application.application_id%TYPE;
348: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
349: l_currency_code gl_sets_of_books.currency_code%TYPE;
350: l_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
351:
352: /*Bug#12600219 - START */
353: l_start_segments_ccid number;
354: l_to_segments_ccid number;

Line 392: FROM gl_sets_of_books

388: WHERE application_short_name = 'SQLGL' ;
389:
390: SELECT currency_code,set_of_books_id, chart_of_accounts_id
391: INTO l_currency_code, l_set_of_books_id, l_chart_of_accounts_id
392: FROM gl_sets_of_books
393: WHERE set_of_books_id = in_set_of_books;
394:
395: SELECT fifstr.concatenated_segment_delimiter
396: INTO l_segment_delimiter