APPS.AP_VOID_PKG dependencies on AP_PAYMENT_HISTORY

Line 272: l_transaction_type AP_PAYMENT_HISTORY_ALL.transaction_type%TYPE;

268: l_org_id NUMBER;
269:
270: l_netting_type VARCHAR2(30);
271: l_rev_pmt_hist_id NUMBER; -- Bug 5015973
272: l_transaction_type AP_PAYMENT_HISTORY_ALL.transaction_type%TYPE;
273:
274: /* Introduced following variables for IL BOE project - Bug 11661879 */
275: l_il_patch_level VARCHAR2(1);
276: l_ap_patch_level VARCHAR2(1);

Line 851: FROM AP_Payment_History APH

847: -- Commented for Bug 6953346
848: /*
849: SELECT MAX(Payment_History_ID)
850: INTO l_rev_pmt_hist_id
851: FROM AP_Payment_History APH
852: WHERE APH.Check_ID = P_Check_ID
853: AND APH.Transaction_Type = 'PAYMENT CREATED';
854: */
855:

Line 861: FROM AP_Payment_History APH

857:
858: IF(l_transaction_type = 'PAYMENT CANCELLED') THEN
859: SELECT MAX(Payment_History_ID)
860: INTO l_rev_pmt_hist_id
861: FROM AP_Payment_History APH
862: WHERE APH.Check_ID = P_Check_ID
863: AND APH.Transaction_Type = 'PAYMENT CREATED';
864:
865: ELSE

Line 868: FROM AP_Payment_History APH

864:
865: ELSE
866: SELECT MAX(Payment_History_ID)
867: INTO l_rev_pmt_hist_id
868: FROM AP_Payment_History APH
869: WHERE APH.Check_ID = P_Check_ID
870: AND APH.Transaction_Type = 'REFUND RECORDED';
871:
872: END IF;