[Home] [Help]
188: end if;
189: END;
190: BEGIN
191: if (upper(p_batch) <> 'ALL' and p_batch is not null) then
192: SELECT ap_batches.batch_id
193: INTO l_batchid
194: FROM ap_batches
195: where batch_name = p_batch;
196: C_BATCH_ID := to_char(l_batchid);
190: BEGIN
191: if (upper(p_batch) <> 'ALL' and p_batch is not null) then
192: SELECT ap_batches.batch_id
193: INTO l_batchid
194: FROM ap_batches
195: where batch_name = p_batch;
196: C_BATCH_ID := to_char(l_batchid);
197: end if;
198: EXCEPTION