DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_PROCESS dependencies on AP_WEB_PAYMENTS_PKG

Line 789: 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

785: AND AI.invoice_type_lookup_code = 'PREPAYMENT'
786: AND AI.earliest_settlement_date <= sysdate
787: AND AI.payment_status_flag = 'Y'
788: AND AI.invoice_currency_code = XH.payment_currency_code
789: 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
790: );
791: EXCEPTION
792: WHEN NO_DATA_FOUND THEN
793: adv_not_applied_flag := 'N';