APPS.GMF_GL_GET_BALANCES dependencies on FND_APPLICATION

Line 221: l_application_id fnd_application.application_id%TYPE;

217: l_segment_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%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:

Line 241: FROM fnd_application

237: /***** Bug 4066174 - Added the new queries below *****
238:
239: -- Newly added Query 1 for Bug 4066174
240: SELECT application_id INTO l_application_id
241: FROM fnd_application
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

Line 347: l_application_id fnd_application.application_id%TYPE;

343: l_segment_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%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:

Line 387: FROM fnd_application

383: /***** Bug 4066174 - Added the new queries below *****/
384:
385: -- Newly added Query 1 for Bug 4066174
386: SELECT application_id INTO l_application_id
387: FROM fnd_application
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