DBA Data[Home] [Help]

APPS.JA_CN_AB_EXP_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 80: l_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;

76: -- l_set_of_books_id ja_cn_system_parameters_all.legal_entity_id%TYPE;
77: l_functional_currency fnd_currencies_vl.NAME%TYPE;
78: l_functional_currency_code fnd_currencies_vl.CURRENCY_CODE%TYPE;
79: --l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
80: l_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
81: l_ja_cn_dff_assignments_row ja_cn_dff_assignments%ROWTYPE;
82: l_context_code ja_cn_dff_assignments.context_code%TYPE;
83: l_attribute_column4cost_center ja_cn_dff_assignments.attribute_column%TYPE;
84: l_attribute_column4third_party ja_cn_dff_assignments.attribute_column%TYPE;

Line 371: FROM fnd_id_flex_segments s

367:
368: --fetch flex_value_set_id
369: SELECT s.flex_value_set_id
370: INTO l_flex_value_set_id
371: FROM fnd_id_flex_segments s
372: WHERE s.application_id = 101
373: AND s.id_flex_num = p_coa_id--l_chart_of_accounts_id
374: AND s.id_flex_code = 'GL#'
375: AND s.application_column_name =