APPS.PA_CMT_UTILS dependencies on AP_PREPAY_APP_DISTS

Line 756: from ap_prepay_app_dists ppaydist

752: select sum( decode(p_denom_amt_flag, /* Bug 4015448. Added Dummy Sum */
753: 'Y', ppaydist.amount,
754: 'N', nvl(ppaydist.base_amount,ppaydist.amount)))
755: into l_prepay_amt
756: from ap_prepay_app_dists ppaydist
757: where ppaydist.invoice_distribution_id = p_inv_dist_id
758: and NVL(ppaydist.pa_addition_flag,'N') <> 'N' ;
759:
760: l_pay_amt := nvl(l_pay_amt,0) + ( nvl(l_prepay_amt,0) * -1 ) ;

Line 882: from ap_prepay_app_dists ppaydist

878: select sum( decode(p_denom_amt_flag, /* Bug 4015448. Added Dummy Sum */
879: 'Y', ppaydist.amount,
880: 'N', nvl(ppaydist.base_amount,ppaydist.amount)))
881: into l_prepay_amt
882: from ap_prepay_app_dists ppaydist
883: where ppaydist.invoice_distribution_id = p_inv_dist_id
884: and NVL(ppaydist.pa_addition_flag,'N') <> 'N' ;
885:
886: l_pay_amt := nvl(l_pay_amt,0) + ( nvl(l_prepay_amt,0) * -1 ) ;