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 819: FROM AP_INVOICES_ALL a

815: a.temp_cancelled_Amount
816: INTO l_source,
817: l_cancelled_date,
818: l_temp_cancelled_amount
819: FROM AP_INVOICES_ALL a
820: WHERE a.invoice_id = l_invoice_id;
821:
822: -- =============== START DEBUG LOG ================
823: Debug_log_string (l_proc_level, 'Igi_Exp_Ap_Inv_Line_T2.Msg4',

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

892: l_inv_dist_amt NUMBER;
893: l_temp_cancelled_amount NUMBER;
894: l_inv_line_amt NUMBER;
895:
896: CURSOR cur_get_SIA_Hold(p_inv_id ap_invoices_all.invoice_id%type)
897: IS
898: Select hold_lookup_code
899: From AP_HOLDS_ALL
900: Where invoice_id = p_inv_id