APPS.AP_PO_GAPLESS_SBI_PKG dependencies on AP_HISTORY_INVOICES_ALL

Line 14: l_dup_history AP_HISTORY_INVOICES_ALL.invoice_num%TYPE;

10: l_vendor_id AP_INVOICES_ALL.vendor_id%TYPE;
11: l_org_id number(15);
12: l_dup_invoices AP_INVOICES_ALL.invoice_num%TYPE;
13: l_dup_interface AP_INVOICES_INTERFACE.invoice_num%TYPE;
14: l_dup_history AP_HISTORY_INVOICES_ALL.invoice_num%TYPE;
15:
16: BEGIN
17:
18: -- Deriving the Value of the Vendor_Id

Line 61: -- Checking for duplicates in AP_HISTORY_INVOICES_ALL table

57: End;
58:
59: END IF;
60:
61: -- Checking for duplicates in AP_HISTORY_INVOICES_ALL table
62:
63: IF (l_dup_interface is Null AND l_dup_invoices is Null) THEN
64: Begin
65:

Line 68: FROM AP_HISTORY_INVOICES_ALL

64: Begin
65:
66: SELECT invoice_num
67: INTO l_dup_history
68: FROM AP_HISTORY_INVOICES_ALL
69: WHERE invoice_num = p_invoice_num
70: AND vendor_id = l_vendor_id
71: AND org_id = l_org_id;
72: Exception