DBA Data[Home] [Help]

APPS.GL_FLEXFIELDS_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 47: FROM fnd_id_flex_segments fs,

43:
44: FUNCTION get_account_segment(coa_id NUMBER) RETURN VARCHAR2 IS
45: CURSOR get_acct_seg IS
46: SELECT fs.segment_name
47: FROM fnd_id_flex_segments fs,
48: fnd_segment_attribute_values av
49: WHERE fs.application_column_name = av.application_column_name
50: AND av.id_flex_code = 'GL#'
51: AND fs.id_flex_code = av.id_flex_code

Line 178: FROM fnd_id_flex_segments

174: x_ieaseg_left_prompt IN OUT NOCOPY VARCHAR2) IS
175:
176: CURSOR seg_count IS
177: SELECT segment_num, application_column_name
178: FROM fnd_id_flex_segments
179: WHERE application_id = 101
180: AND id_flex_code = 'GL#'
181: AND enabled_flag = 'Y'
182: AND id_flex_num = x_chart_of_accounts_id

Line 348: FROM FND_ID_FLEX_SEGMENTS S,

344: SELECT S.flex_value_set_id,
345: VS.validation_type
346: INTO v_vsid,
347: v_type
348: FROM FND_ID_FLEX_SEGMENTS S,
349: FND_FLEX_VALUE_SETS VS
350: WHERE S.id_flex_num = x_coa_id
351: AND S.application_id = 101
352: AND S.id_flex_code = 'GL#'