304: HZ_CUST_SITE_USES HCSU,
305: HZ_LOCATIONS HL,
306: HZ_CUST_ACCT_SITES HCAS,
307: AR_CASH_RECEIPTS CR,
308: AR_CASH_RECEIPT_HISTORY CRH,
309: HZ_PARTY_SITES HPS
310: WHERE HP.PARTY_ID = HCA.PARTY_ID
311: AND ( HP.PARTY_NAME >= C_FROM
312: AND HP.PARTY_NAME <= C_TO )
338: AND exists (
339: SELECT
340: CRH.CASH_RECEIPT_ID
341: FROM
342: AR_CASH_RECEIPT_HISTORY CRH
343: WHERE CRH.STATUS = 'CLEARED'
344: AND CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID );
345: C_CUST NUMBER;
346: C_CURRENCY VARCHAR2(3);