APPS.ARI_SERVICE_CHARGE_PKG SQL Statements

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

Line: 12

SELECT PAYMENT_SCHEDULE_ID,
       PAYMENT_AMT,
       CUSTOMER_ID,
       ACCOUNT_NUMBER,
       CUSTOMER_TRX_ID,
       CURRENCY_CODE,
       STATUS
FROM  AR_IREC_PAYMENT_LIST_GT;

Line: 154

   THAT FOR WHICH INVOICE WE UPDATE THE CHARGE IN THE GLOBAL TABLE AND ALSO
   FOR WHICH INVOICE WE ADD THE AMOUNT.
2) IF THE SERVICE CHARGE IS CALCULATED FOR EVERY INVOICE,UPDATE the GLOBAL
   TABLE WITH THE SERVICE CHARGE
*/
   --------------------------------------------------------------------
   l_debug_info := 'Calculating service charge';