46: ,0))
47: ,0) CURRENT_YEAR_CUSTOMER_COUNT
48: INTO CURRENT_CUSTOMER_COUNT,PRIOR_CUSTOMER_COUNT,CURRENT_YEAR_CUSTOMER_COUNT
49: FROM
50: HZ_CUST_ACCOUNTS C,
51: GL_PERIOD_STATUSES GPS
52: WHERE C.CREATION_DATE BETWEEN GPS.START_DATE
53: AND GPS.END_DATE
54: AND GPS.APPLICATION_ID = 222