DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_PROCESS dependencies on AP_WEB_PAYMENTS_PKG

Line 725: AND AP_WEB_PAYMENTS_PKG.get_prepay_amount_remaining(AI.invoice_id,AI.invoice_num,PV.employee_id,XH.default_currency_code,null,null,200) > 0

721: AND AI.invoice_type_lookup_code = 'PREPAYMENT'
722: AND AI.earliest_settlement_date <= sysdate
723: AND AI.payment_status_flag = 'Y'
724: AND AI.invoice_currency_code = XH.payment_currency_code
725: AND AP_WEB_PAYMENTS_PKG.get_prepay_amount_remaining(AI.invoice_id,AI.invoice_num,PV.employee_id,XH.default_currency_code,null,null,200) > 0
726: );
727: EXCEPTION
728: WHEN NO_DATA_FOUND THEN
729: adv_not_applied_flag := 'N';