APPS.AP_VOID_PKG dependencies on AP_PAYMENT_HISTORY

Line 258: l_transaction_type AP_PAYMENT_HISTORY_ALL.transaction_type%TYPE;

254: l_org_id NUMBER;
255:
256: l_netting_type VARCHAR2(30);
257: l_rev_pmt_hist_id NUMBER; -- Bug 5015973
258: l_transaction_type AP_PAYMENT_HISTORY_ALL.transaction_type%TYPE;
259:
260: BEGIN
261:
262: l_curr_calling_sequence := 'AP_VOID_PKG.AP_REVERSE_CHECK<-'||

Line 697: FROM AP_Payment_History APH

693: -- Commented for Bug 6953346
694: /*
695: SELECT MAX(Payment_History_ID)
696: INTO l_rev_pmt_hist_id
697: FROM AP_Payment_History APH
698: WHERE APH.Check_ID = P_Check_ID
699: AND APH.Transaction_Type = 'PAYMENT CREATED';
700: */
701:

Line 707: FROM AP_Payment_History APH

703:
704: IF(l_transaction_type = 'PAYMENT CANCELLED') THEN
705: SELECT MAX(Payment_History_ID)
706: INTO l_rev_pmt_hist_id
707: FROM AP_Payment_History APH
708: WHERE APH.Check_ID = P_Check_ID
709: AND APH.Transaction_Type = 'PAYMENT CREATED';
710:
711: ELSE

Line 714: FROM AP_Payment_History APH

710:
711: ELSE
712: SELECT MAX(Payment_History_ID)
713: INTO l_rev_pmt_hist_id
714: FROM AP_Payment_History APH
715: WHERE APH.Check_ID = P_Check_ID
716: AND APH.Transaction_Type = 'REFUND RECORDED';
717:
718: END IF;