APPS.IGI_EXP_HOLDS dependencies on AP_INVOICES_ALL

Line 622: FROM AP_INVOICES_ALL a

618: a.temp_cancelled_amount
619: INTO l_source,
620: l_cancelled_date,
621: l_temp_cancelled_amount
622: FROM AP_INVOICES_ALL a
623: WHERE a.invoice_id = l_invoice_id;
624:
625: -- =============== START DEBUG LOG ================
626: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg4',

Line 721: FROM AP_INVOICES_ALL a

717: a.temp_cancelled_Amount
718: INTO l_source,
719: l_cancelled_date,
720: l_temp_cancelled_amount
721: FROM AP_INVOICES_ALL a
722: WHERE a.invoice_id = l_invoice_id;
723:
724: -- =============== START DEBUG LOG ================
725: Debug_log_string (l_proc_level, 'Igi_Exp_Ap_Inv_Dist_T2.Msg4',

Line 825: FROM AP_INVOICES_ALL a

821: l_cancelled_date,
822: l_temp_cancelled_amount,
823: l_approval_status_code,
824: l_invoice_type_lookup_code
825: FROM AP_INVOICES_ALL a
826: WHERE a.invoice_id = l_invoice_id;
827:
828: -- =============== START DEBUG LOG ================
829: Debug_log_string (l_proc_level, 'Igi_Exp_Ap_Inv_Line_T2.Msg4',

Line 906: CURSOR cur_get_SIA_Hold(p_inv_id ap_invoices_all.invoice_id%type)

902: l_inv_dist_amt NUMBER;
903: l_temp_cancelled_amount NUMBER;
904: l_inv_line_amt NUMBER;
905:
906: CURSOR cur_get_SIA_Hold(p_inv_id ap_invoices_all.invoice_id%type)
907: IS
908: Select hold_lookup_code
909: From AP_HOLDS_ALL
910: Where invoice_id = p_inv_id