DBA Data[Home] [Help]

APPS.AP_CANCEL_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 595: FROM ap_invoice_distributions_all aid

591: AND APR.Registration_Event_Type = 'INVOICE_CANCELLED';
592:
593: cursor dist_debug_cur is
594: Select *
595: FROM ap_invoice_distributions_all aid
596: WHERE aid.invoice_id = p_invoice_id;
597:
598: l_inv_line_rec_list Inv_Line_Tab_Type;
599: l_ok_to_cancel BOOLEAN := FALSE;

Line 629: l_Accounting_event_ID AP_INVOICE_DISTRIBUTIONS_ALL.accounting_event_id%TYPE;

625: l_self_assess_tax_count NUMBER := 0 ; -- Bug 6694536
626: l_tax_dist_count NUMBER := 0; -- Bug 6815172
627:
628: -- Bug 4748638
629: l_Accounting_event_ID AP_INVOICE_DISTRIBUTIONS_ALL.accounting_event_id%TYPE;
630: l_cancel_dist_exists NUMBER := 0;
631: l_open_gl_date AP_INVOICES_ALL.gl_date%type;
632: l_funds_return_code VARCHAR2(30); -- 4276409 (3462325)
633:

Line 1002: FROM ap_invoice_distributions_all

998:
999: ---7428195 starts
1000: SELECT 1
1001: INTO l_check_encumbrance
1002: FROM ap_invoice_distributions_all
1003: WHERE invoice_id = P_invoice_id
1004: AND encumbered_flag = 'Y'
1005: AND rownum < 2;
1006: