APPS.IGI_EXP_BALANCE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 21

   SELECT distinct third_party_id
   FROM igi_exp_dial_unit_def
   WHERE trans_unit_id = p_transmission_unit_id;

Line: 27

   SELECT third_party_id
   FROM igi_exp_dial_unit_def
   WHERE dial_unit_id = p_dialogue_unit_id;

Line: 32

   SELECT distinct asic.vendor_id
   FROM   ap_selected_invoice_checks asic
   WHERE  asic.checkrun_name = p_checkrun_name;

Line: 37

   SELECT NVL(SUM(aps.amount_due_remaining),0)
   FROM ra_customer_trx rct,
        ar_payment_schedules aps
   WHERE  aps.customer_trx_id = rct.customer_trx_id
   AND    rct.bill_to_customer_id = l_customer_id
   AND    aps.class = 'INV'
   AND    aps.due_date <= trunc(sysdate);

Line: 46

SELECT PARTY_NAME
FROM HZ_CUST_ACCOUNTS acct,HZ_PARTIES party
WHERE acct.PARTY_ID=party.PARTY_ID
AND   acct.cust_account_id = l_customer_id;

Line: 52

 SELECT rc.customer_name
 FROM   ra_customers    rc
 WHERE  rc.customer_id = l_customer_id;