APPS.JA_CN_JE_EXP_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 74: l_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;

70: l_module_name CONSTANT VARCHAR2(300) := 'JA_CN_JE_EXP_PKG.Run_Export';
71: l_message VARCHAR2(300);
72: --l_set_of_books_id ja_cn_system_parameters_all.legal_entity_id%TYPE;
73: --l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
74: l_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
75: l_ja_cn_dff_assignments_row ja_cn_dff_assignments%ROWTYPE;
76: l_context_code ja_cn_dff_assignments.context_code%TYPE;
77: l_attribute_column4cost_center ja_cn_dff_assignments.attribute_column%TYPE;
78: l_attribute_column4third_party ja_cn_dff_assignments.attribute_column%TYPE;

Line 375: FROM fnd_id_flex_segments s

371:
372: --fetch flex_value_set_id
373: SELECT s.flex_value_set_id
374: INTO l_flex_value_set_id
375: FROM fnd_id_flex_segments s
376: WHERE s.application_id = 101
377: AND s.id_flex_num = p_coa_id--l_chart_of_accounts_id
378: AND s.id_flex_code = 'GL#'
379: AND s.application_column_name =