APPS.IGI_EXP_UTILS dependencies on IGI_EXP_AP_TRANS

Line 769: FROM igi_exp_ap_trans i,

765: SELECT a.invoice_id,
766: a.source,
767: a.cancelled_date,
768: a.gl_date -- shsaxena bug2777575.
769: FROM igi_exp_ap_trans i,
770: ap_invoices_all a
771: WHERE i.invoice_id = a.invoice_id
772: AND i.du_id = pv_du_id;
773:

Line 874: -- are all within the igi_exp_ap_trans table

870: IF p_app_id = 200 THEN -- this is a AP Dialog Unit
871:
872: -------------------------------------------------------
873: -- Check the documents contained within the Dialog Unit
874: -- are all within the igi_exp_ap_trans table
875: -------------------------------------------------------
876: -----------------------------
877: l_debug_info := 'p_app_id = 200';
878: --dbms_output.put_line(l_debug_info);

Line 984: FROM igi_exp_ap_trans

980: -- are all within the igi_exp_ar_trans table
981: -------------------------------------------------------
982: SELECT COUNT(1)
983: INTO l_ap_trans
984: FROM igi_exp_ap_trans
985: WHERE du_id = p_du_id;
986:
987: IF l_ap_trans > 0 THEN -- there are AP transactions within the AR Dialog unit
988: RAISE e_ap_trans;