[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT gl_carryforward_ranges_s.NEXTVAL
FROM sys.dual;
SELECT 'Overlapping'
FROM GL_CARRYFORWARD_RANGES
WHERE carryforward_range_id = x_carryforward_range_id AND
(NVL(SEGMENT30_LOW,'X') <= NVL(X_SEGMENT30_HIGH,'X') AND
NVL(SEGMENT30_HIGH,'X') >= NVL(X_SEGMENT30_LOW,'X')) AND
NVL(SEGMENT29_LOW,'X') <= NVL(X_SEGMENT29_HIGH,'X') AND
NVL(SEGMENT29_HIGH,'X') >= NVL(X_SEGMENT29_LOW,'X') AND
NVL(SEGMENT28_LOW,'X') <= NVL(X_SEGMENT28_HIGH,'X') AND
NVL(SEGMENT28_HIGH,'X') >= NVL(X_SEGMENT28_LOW,'X') AND
NVL(SEGMENT27_LOW,'X') <= NVL(X_SEGMENT27_HIGH,'X') AND
NVL(SEGMENT27_HIGH,'X') >= NVL(X_SEGMENT27_LOW,'X') AND
NVL(SEGMENT26_LOW,'X') <= NVL(X_SEGMENT26_HIGH,'X') AND
NVL(SEGMENT26_HIGH,'X') >= NVL(X_SEGMENT26_LOW,'X') AND
NVL(SEGMENT25_LOW,'X') <= NVL(X_SEGMENT25_HIGH,'X') AND
NVL(SEGMENT25_HIGH,'X') >= NVL(X_SEGMENT25_LOW,'X') AND
NVL(SEGMENT24_LOW,'X') <= NVL(X_SEGMENT24_HIGH,'X') AND
NVL(SEGMENT24_HIGH,'X') >= NVL(X_SEGMENT24_LOW,'X') AND
NVL(SEGMENT23_LOW,'X') <= NVL(X_SEGMENT23_HIGH,'X') AND
NVL(SEGMENT23_HIGH,'X') >= NVL(X_SEGMENT23_LOW,'X') AND
NVL(SEGMENT22_LOW,'X') <= NVL(X_SEGMENT22_HIGH,'X') AND
NVL(SEGMENT22_HIGH,'X') >= NVL(X_SEGMENT22_LOW,'X') AND
NVL(SEGMENT21_LOW,'X') <= NVL(X_SEGMENT21_HIGH,'X') AND
NVL(SEGMENT21_HIGH,'X') >= NVL(X_SEGMENT21_LOW,'X') AND
NVL(SEGMENT20_LOW,'X') <= NVL(X_SEGMENT20_HIGH,'X') AND
NVL(SEGMENT20_HIGH,'X') >= NVL(X_SEGMENT20_LOW,'X') AND
NVL(SEGMENT19_LOW,'X') <= NVL(X_SEGMENT19_HIGH,'X') AND
NVL(SEGMENT19_HIGH,'X') >= NVL(X_SEGMENT19_LOW,'X') AND
NVL(SEGMENT18_LOW,'X') <= NVL(X_SEGMENT18_HIGH,'X') AND
NVL(SEGMENT18_HIGH,'X') >= NVL(X_SEGMENT18_LOW,'X') AND
NVL(SEGMENT17_LOW,'X') <= NVL(X_SEGMENT17_HIGH,'X') AND
NVL(SEGMENT17_HIGH,'X') >= NVL(X_SEGMENT17_LOW,'X') AND
NVL(SEGMENT16_LOW,'X') <= NVL(X_SEGMENT16_HIGH,'X') AND
NVL(SEGMENT16_HIGH,'X') >= NVL(X_SEGMENT16_LOW,'X') AND
NVL(SEGMENT15_LOW,'X') <= NVL(X_SEGMENT15_HIGH,'X') AND
NVL(SEGMENT15_HIGH,'X') >= NVL(X_SEGMENT15_LOW,'X') AND
NVL(SEGMENT14_LOW,'X') <= NVL(X_SEGMENT14_HIGH,'X') AND
NVL(SEGMENT14_HIGH,'X') >= NVL(X_SEGMENT14_LOW,'X') AND
NVL(SEGMENT13_LOW,'X') <= NVL(X_SEGMENT13_HIGH,'X') AND
NVL(SEGMENT13_HIGH,'X') >= NVL(X_SEGMENT13_LOW,'X') AND
NVL(SEGMENT12_LOW,'X') <= NVL(X_SEGMENT12_HIGH,'X') AND
NVL(SEGMENT12_HIGH,'X') >= NVL(X_SEGMENT12_LOW,'X') AND
NVL(SEGMENT11_LOW,'X') <= NVL(X_SEGMENT11_HIGH,'X') AND
NVL(SEGMENT11_HIGH,'X') >= NVL(X_SEGMENT11_LOW,'X') AND
NVL(SEGMENT10_LOW,'X') <= NVL(X_SEGMENT10_HIGH,'X') AND
NVL(SEGMENT10_HIGH,'X') >= NVL(X_SEGMENT10_LOW,'X') AND
NVL(SEGMENT9_LOW,'X') <= NVL(X_SEGMENT9_HIGH,'X') AND
NVL(SEGMENT9_HIGH,'X') >= NVL(X_SEGMENT9_LOW,'X') AND
NVL(SEGMENT8_LOW,'X') <= NVL(X_SEGMENT8_HIGH,'X') AND
NVL(SEGMENT8_HIGH,'X') >= NVL(X_SEGMENT8_LOW,'X') AND
NVL(SEGMENT7_LOW,'X') <= NVL(X_SEGMENT7_HIGH,'X') AND
NVL(SEGMENT7_HIGH,'X') >= NVL(X_SEGMENT7_LOW,'X') AND
NVL(SEGMENT6_LOW,'X') <= NVL(X_SEGMENT6_HIGH,'X') AND
NVL(SEGMENT6_HIGH,'X') >= NVL(X_SEGMENT6_LOW,'X') AND
NVL(SEGMENT5_LOW,'X') <= NVL(X_SEGMENT5_HIGH,'X') AND
NVL(SEGMENT5_HIGH,'X') >= NVL(X_SEGMENT5_LOW,'X') AND
NVL(SEGMENT4_LOW,'X') <= NVL(X_SEGMENT4_HIGH,'X') AND
NVL(SEGMENT4_HIGH,'X') >= NVL(X_SEGMENT4_LOW,'X') AND
NVL(SEGMENT3_LOW,'X') <= NVL(X_SEGMENT3_HIGH,'X') AND
NVL(SEGMENT3_HIGH,'X') >= NVL(X_SEGMENT3_LOW,'X') AND
NVL(SEGMENT2_LOW,'X') <= NVL(X_SEGMENT2_HIGH,'X') AND
NVL(SEGMENT2_HIGH,'X') >= NVL(X_SEGMENT2_LOW,'X') AND
NVL(SEGMENT1_LOW,'X') <= NVL(X_SEGMENT1_HIGH,'X') AND
NVL(SEGMENT1_HIGH,'X') >= NVL(X_SEGMENT1_LOW,'X') AND
(row_id is NULL OR rowid <> row_id );