APPS.XLA_JE_VALIDATION_PKG dependencies on FND_ID_FLEX_SEGMENTS_VL

Line 253: FROM FND_ID_FLEX_SEGMENTS_VL

249: CURSOR c_seg_number (p_seg_col_name VARCHAR2, p_coa_id INTEGER) IS
250: SELECT display_order
251: FROM (SELECT ROWNUM display_order, application_column_name
252: FROM ( SELECT application_column_name
253: FROM FND_ID_FLEX_SEGMENTS_VL
254: WHERE ID_FLEX_NUM = p_coa_id
255: AND ID_FLEX_CODE = 'GL#'
256: AND APPLICATION_ID = 101
257: order by decode(enabled_flag, 'Y', 1, 'N', 2), segment_num))

Line 5724: FROM FND_ID_FLEX_SEGMENTS_VL

5720: CURSOR c_seg_number (p_seg_col_name VARCHAR2, p_coa_id INTEGER) IS
5721: SELECT display_order
5722: FROM (SELECT ROWNUM display_order, application_column_name
5723: FROM ( SELECT application_column_name
5724: FROM FND_ID_FLEX_SEGMENTS_VL
5725: WHERE ID_FLEX_NUM = p_coa_id
5726: AND ID_FLEX_CODE = 'GL#'
5727: AND APPLICATION_ID = 101
5728: order by decode(enabled_flag, 'Y', 1, 'N', 2), segment_num))

Line 6449: FROM FND_ID_FLEX_SEGMENTS_VL

6445: CURSOR c_seg_number (p_seg_col_name VARCHAR2, p_coa_id INTEGER) IS
6446: SELECT display_order
6447: FROM (SELECT ROWNUM display_order, application_column_name
6448: FROM ( SELECT application_column_name
6449: FROM FND_ID_FLEX_SEGMENTS_VL
6450: WHERE ID_FLEX_NUM = p_coa_id
6451: AND ID_FLEX_CODE = 'GL#'
6452: AND APPLICATION_ID = 101
6453: order by decode(enabled_flag, 'Y', 1, 'N', 2), segment_num))

Line 7939: FROM FND_ID_FLEX_SEGMENTS_VL

7935: CURSOR c_seg_number (p_seg_col_name VARCHAR2, p_coa_id INTEGER) IS
7936: SELECT display_order
7937: FROM (SELECT ROWNUM display_order, application_column_name
7938: FROM ( SELECT application_column_name
7939: FROM FND_ID_FLEX_SEGMENTS_VL
7940: WHERE ID_FLEX_NUM = p_coa_id
7941: AND ID_FLEX_CODE = 'GL#'
7942: AND APPLICATION_ID = 101
7943: order by decode(enabled_flag, 'Y', 1, 'N', 2), segment_num))

Line 9374: FROM FND_ID_FLEX_SEGMENTS_VL

9370:
9371: l_stmt2 := ' ';
9372:
9373: FOR l_rec IN (SELECT application_column_name
9374: FROM FND_ID_FLEX_SEGMENTS_VL
9375: WHERE id_flex_num = g_ledger_coa_id
9376: AND id_flex_code = 'GL#'
9377: AND application_id = 101
9378: AND enabled_flag = 'Y'

Line 9381: FROM FND_ID_FLEX_SEGMENTS_VL

9377: AND application_id = 101
9378: AND enabled_flag = 'Y'
9379: MINUS
9380: SELECT g_bal_seg_column_name
9381: FROM FND_ID_FLEX_SEGMENTS_VL
9382: WHERE rownum=1
9383: )
9384: LOOP
9385: l_stmt2 := l_stmt2 || 'nc.' || l_rec.application_column_name || ' = ' || 'sc.' || l_rec.application_column_name || ' AND ';