APPS.GL_PARENT_SEGMENT_PKG dependencies on GL_REVAL_EXP_RANGES_GT

Line 509: -- in GL_REVAL_EXP_RANGES_GT overlap

505: -- PROCEDURE
506: -- check_overlapping
507: -- PURPOSE
508: -- It will check whether any expanded and merged account ranges
509: -- in GL_REVAL_EXP_RANGES_GT overlap
510: -- HISTORY
511: -- 08/29/03 L Poon Created
512: -- ARGUMENTS
513: -- debug_mode Debug Mode (Y or N)

Line 520: FROM GL_REVAL_EXP_RANGES_GT er1

516: is_overlapping OUT NOCOPY VARCHAR2) IS
517:
518: CURSOR acct_range_c IS
519: SELECT /*+ cardinality(er1 10) */ 1
520: FROM GL_REVAL_EXP_RANGES_GT er1
521: WHERE EXISTS(
522: SELECT /*+ no_unnest index(er2) */ 'Overlapping'
523: FROM gl_reval_exp_ranges_gt er2
524: WHERE er2.ROWID <> er1.rowid

Line 523: FROM gl_reval_exp_ranges_gt er2

519: SELECT /*+ cardinality(er1 10) */ 1
520: FROM GL_REVAL_EXP_RANGES_GT er1
521: WHERE EXISTS(
522: SELECT /*+ no_unnest index(er2) */ 'Overlapping'
523: FROM gl_reval_exp_ranges_gt er2
524: WHERE er2.ROWID <> er1.rowid
525: AND NVL(er2.segment30_low, 'X') <= NVL(er1.segment30_high, 'X')
526: AND NVL(er2.segment30_high, 'X') >= NVL(er1.segment30_low, 'X')
527: AND NVL(er2.segment29_low, 'X') <= NVL(er1.segment29_high, 'X')