APPS.PA_CMT_UTILS dependencies on AP_PREPAY_APP_DISTS

Line 658: from ap_prepay_app_dists ppaydist

654: select sum( decode(p_denom_amt_flag, /* Bug 4015448. Added Dummy Sum */
655: 'Y', ppaydist.amount,
656: 'N', nvl(ppaydist.base_amount,ppaydist.amount)))
657: into l_prepay_amt
658: from ap_prepay_app_dists ppaydist
659: where ppaydist.invoice_distribution_id = p_inv_dist_id
660: and NVL(ppaydist.pa_addition_flag,'N') <> 'N' ;
661:
662: l_pay_amt := nvl(l_pay_amt,0) + ( nvl(l_prepay_amt,0) * -1 ) ;

Line 771: from ap_prepay_app_dists ppaydist

767: select sum( decode(p_denom_amt_flag, /* Bug 4015448. Added Dummy Sum */
768: 'Y', ppaydist.amount,
769: 'N', nvl(ppaydist.base_amount,ppaydist.amount)))
770: into l_prepay_amt
771: from ap_prepay_app_dists ppaydist
772: where ppaydist.invoice_distribution_id = p_inv_dist_id
773: and NVL(ppaydist.pa_addition_flag,'N') <> 'N' ;
774:
775: l_pay_amt := nvl(l_pay_amt,0) + ( nvl(l_prepay_amt,0) * -1 ) ;