APPS.AP_WITHHOLDING_PKG dependencies on AP_INVOICE_PAYMENTS

Line 4649: FROM AP_INVOICE_PAYMENTS_ALL AIP

4645:
4646: ELSIF (P_Calling_Module = 'VOID PAYMENT') THEN
4647: SELECT AIP.org_id
4648: INTO l_org_id
4649: FROM AP_INVOICE_PAYMENTS_ALL AIP
4650: WHERE AIP.invoice_payment_id = P_Parent_Id;
4651:
4652: END IF;
4653:

Line 4826: FROM ap_invoices ai, ap_invoice_payments aip

4822: ELSIF (P_Calling_Module = 'VOID PAYMENT') THEN
4823:
4824: SELECT ai.exchange_rate
4825: INTO l_invoice_exchange_rate
4826: FROM ap_invoices ai, ap_invoice_payments aip
4827: WHERE ai.invoice_id = aip.invoice_id
4828: AND aip.invoice_payment_id =rec_awt_gross_dists.awt_invoice_payment_id;
4829:
4830: END IF;

Line 5255: FROM ap_invoice_payments

5251: reversed_withholding NUMBER := -rec_awt_dists.amount;
5252:
5253: CURSOR c_payment_num (InvPaymId IN NUMBER) IS
5254: SELECT payment_num
5255: FROM ap_invoice_payments
5256: WHERE invoice_payment_id = InvPaymId;
5257:
5258: paym_num ap_invoice_payments.payment_num%TYPE;
5259:

Line 5258: paym_num ap_invoice_payments.payment_num%TYPE;

5254: SELECT payment_num
5255: FROM ap_invoice_payments
5256: WHERE invoice_payment_id = InvPaymId;
5257:
5258: paym_num ap_invoice_payments.payment_num%TYPE;
5259:
5260: CURSOR c_payment_sched (PaymNum IN NUMBER, InvId IN NUMBER) IS
5261:
5262: SELECT APS.gross_amount

Line 5404: FROM ap_invoices ai, ap_invoice_payments aip

5400: ELSIF (P_Calling_Module = 'VOID PAYMENT') THEN
5401:
5402: SELECT ai.exchange_rate
5403: INTO l_invoice_exchange_rate
5404: FROM ap_invoices ai, ap_invoice_payments aip
5405: WHERE ai.invoice_id = aip.invoice_id
5406: AND aip.invoice_payment_id = rec_awt_dists.awt_invoice_payment_id;
5407: END IF;
5408: