233: AND ct.complete_flag = 'Y'
234: UNION ALL
235: SELECT count(*)
236: FROM
237: ar_adjustments_all adj,
238: ra_customer_trx_all ct
239: WHERE adj.last_update_date between p_from_date and p_to_date
240: AND nvl(adj.status, 'A') = 'A'
241: AND nvl(adj.postable,'Y') = 'Y'
331: AND ct.complete_flag = 'Y'
332: UNION ALL
333: SELECT count(*)
334: FROM
335: ar_adjustments_all adj,
336: ra_customer_trx_all ct
337: WHERE adj.last_update_date between p_from_date and p_to_date
338: AND nvl(adj.status, 'A') = 'A'
339: AND nvl(adj.postable,'Y') = 'Y'