APPS.ASP_INVOICE_ALERT_AGENT SQL Statements

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

Line: 77

    SELECT
      PARTY.PARTY_ID as customer_id
    FROM
       AR_PAYMENT_SCHEDULES_ALL PS
      ,HZ_CUST_ACCOUNTS_ALL CUST_ACCT
      ,HZ_PARTIES PARTY
      ,IEX_DEL_ALERTS_PUB_V DEL
    WHERE
        PS.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID
    AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
    AND PS.PAYMENT_SCHEDULE_ID = DEL.PAYMENT_SCHEDULE_ID
    AND DEL.DELINQUENCY_ID = c_delinquency_id
    AND rownum < 2;