DBA Data[Home] [Help]

APPS.IGI_EXP_UTILS dependencies on IGI_EXP_AR_TRANS

Line 781: , igi_exp_ar_trans i

777: , rct.trx_number
778: , rctt.name
779: , arl.meaning
780: FROM ra_customer_trx_all rct
781: , igi_exp_ar_trans i
782: , ar_lookups arl
783: , ra_cust_trx_types_all rctt
784: WHERE i.du_id = pv_du_id
785: AND rct.customer_trx_id = i.customer_trx_id

Line 882: FROM igi_exp_ar_trans_all

878: --dbms_output.put_line(l_debug_info);
879: ----------------------------------
880: SELECT COUNT(1)
881: INTO l_ar_trans
882: FROM igi_exp_ar_trans_all
883: WHERE du_id = p_du_id;
884:
885: IF l_ar_trans > 0 THEN -- there are AR transactions within the AP Dialog unit
886: RAISE e_ar_trans;

Line 980: -- are all within the igi_exp_ar_trans table

976:
977: ELSIF p_app_id = 222 THEN -- this is an AR Dialog Unit
978: -------------------------------------------------------
979: -- Check the documents contained within the Dialog Unit
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