584: into l_exists
585: from dual
586: where exists
587: (select 'Active invoice distributions'
588: from ap_invoice_distributions
589: where po_distribution_id = p_distribution_id
590: and nvl(cancellation_flag,'N') <> 'Y'
591: and nvl(reversal_flag,'N') <> 'Y');
592: