DBA Data[Home] [Help]

APPS.GMF_GL_GET_BALANCES dependencies on FND_ID_FLEX_STRUCTURES

Line 217: l_segment_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;

213: , in_actual_flag in varchar2
214: , in_ytd_ptd in number
215: )
216: IS
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;

Line 251: FROM fnd_id_flex_structures fifstr

247: WHERE set_of_books_id = in_set_of_books;
248:
249: SELECT fifstr.concatenated_segment_delimiter
250: INTO l_segment_delimiter
251: FROM fnd_id_flex_structures fifstr
252: WHERE fifstr.id_flex_code = 'GL#'
253: AND fifstr.application_id = l_application_id
254: AND fifstr.id_flex_num = l_chart_of_accounts_id; --in_chart_of_accounts;
255:

Line 343: l_segment_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;

339: to_segments_ccid out NOCOPY number, /*Bug#12600219*/
340: cur_gl_get_balances in out NOCOPY GMF_GL_GET_BALANCES.cur_gl_get_balances_rc
341: ) IS
342:
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;

Line 397: FROM fnd_id_flex_structures fifstr

393: WHERE set_of_books_id = in_set_of_books;
394:
395: SELECT fifstr.concatenated_segment_delimiter
396: INTO l_segment_delimiter
397: FROM fnd_id_flex_structures fifstr
398: WHERE fifstr.id_flex_code = 'GL#'
399: AND fifstr.application_id = l_application_id
400: AND fifstr.id_flex_num = l_chart_of_accounts_id; --in_chart_of_accounts;
401: