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: 157

   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';

Line: 192

      SELECT ATTRIBUTE1 INTO L_SERVICE_CHRG_PRCNT from ar_lookups where lookup_type = upper(L_LOOKUP_TYPE) AND lookup_code = upper(P_LOOKUP_CODE)
      AND ENABLED_FLAG='Y' and sysdate between start_date_active and nvl(end_date_active,sysdate);