DBA Data[Home] [Help]

APPS.AP_WITHHOLDING_PKG dependencies on AP_INVOICE_PAYMENTS

Line 3200: FROM AP_INVOICE_PAYMENTS_ALL AIP

3196:
3197: ELSIF (P_Calling_Module = 'VOID PAYMENT') THEN
3198: SELECT AIP.org_id
3199: INTO l_org_id
3200: FROM AP_INVOICE_PAYMENTS_ALL AIP
3201: WHERE AIP.invoice_payment_id = P_Parent_Id;
3202:
3203: END IF;
3204:

Line 3492: FROM ap_invoice_payments

3488: reversed_withholding NUMBER := -rec_awt_dists.amount;
3489:
3490: CURSOR c_payment_num (InvPaymId IN NUMBER) IS
3491: SELECT payment_num
3492: FROM ap_invoice_payments
3493: WHERE invoice_payment_id = InvPaymId;
3494:
3495: paym_num ap_invoice_payments.payment_num%TYPE;
3496:

Line 3495: paym_num ap_invoice_payments.payment_num%TYPE;

3491: SELECT payment_num
3492: FROM ap_invoice_payments
3493: WHERE invoice_payment_id = InvPaymId;
3494:
3495: paym_num ap_invoice_payments.payment_num%TYPE;
3496:
3497: CURSOR c_payment_sched (PaymNum IN NUMBER, InvId IN NUMBER) IS
3498:
3499: SELECT APS.gross_amount

Line 3601: FROM ap_invoices ai, ap_invoice_payments aip

3597: ELSIF (P_Calling_Module = 'VOID PAYMENT') THEN
3598:
3599: SELECT ai.exchange_rate
3600: INTO l_invoice_exchange_rate
3601: FROM ap_invoices ai, ap_invoice_payments aip
3602: WHERE ai.invoice_id = aip.invoice_id
3603: AND aip.invoice_payment_id = rec_awt_dists.awt_invoice_payment_id;
3604: END IF;
3605: