DBA Data[Home] [Help]

APPS.JA_CN_JE_EXPORT_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 88: ln_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;

84: ln_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
85: NO_DATA EXCEPTION;
86:
87: lv_message VARCHAR2(300);
88: ln_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
89: l_account_segment ja_cn_journal_lines.account_segment%TYPE;
90: l_ja_cn_subsidiary_gbl_tmp_row ja_cn_subsidiary_gt%ROWTYPE;
91: lv_sql_stmt VARCHAR2(30000) := '';
92: l_journal_number ja_cn_journal_lines_gt.journal_number%TYPE := '';

Line 415: FROM fnd_id_flex_segments s

411:
412: --Fetch flex_value_set_id
413: SELECT s.flex_value_set_id
414: INTO ln_flex_value_set_id
415: FROM fnd_id_flex_segments s
416: WHERE s.application_id = 101
417: AND s.id_flex_num = pn_coa_id--l_chart_of_accounts_id
418: AND s.id_flex_code = 'GL#'
419: AND s.application_column_name =