DBA Data[Home] [Help]

APPS.GLXRVSUB_PKG dependencies on GL_REVAL_ACCOUNT_RANGES

Line 218: FROM gl_reval_account_ranges

214: CURSOR check_overlaps IS
215: SELECT 'Overlapping'
216: FROM DUAL
217: WHERE EXISTS( SELECT 'X'
218: FROM gl_reval_account_ranges
219: WHERE revaluation_id = x_revaluation_id
220: AND ( x_row_id IS NULL
221: OR x_row_id <> ROWID)
222: AND NVL(segment30_low, 'X') <=

Line 439: FROM gl_reval_account_ranges

435: r_id NUMBER(30);
436:
437: CURSOR check_range_exist IS
438: SELECT revaluation_id
439: FROM gl_reval_account_ranges
440: WHERE revaluation_id = r_id AND ROWNUM = 1;
441: BEGIN
442: r_id := reval_id;
443: OPEN check_range_exist;