46: FROM XTR_REVALUATION_DETAILS
47: WHERE batch_id = p_batch_id
48: AND complete_flag = 'N';
49:
50: l_amount_type XTR_AMOUNT_TYPES.AMOUNT_TYPE%TYPE;
51: l_curr_amount_type XTR_AMOUNT_TYPES.AMOUNT_TYPE%TYPE;
52: row_id VARCHAR2(64);
53: l_dnm_id NUMBER;
54: l_count NUMBER;
47: WHERE batch_id = p_batch_id
48: AND complete_flag = 'N';
49:
50: l_amount_type XTR_AMOUNT_TYPES.AMOUNT_TYPE%TYPE;
51: l_curr_amount_type XTR_AMOUNT_TYPES.AMOUNT_TYPE%TYPE;
52: row_id VARCHAR2(64);
53: l_dnm_id NUMBER;
54: l_count NUMBER;
55: