2664: FOR j IN 1..shiporgs.COUNT
2665: LOOP
2666: SELECT COUNT(ORGANIZATION_ID)
2667: INTO opencnt
2668: FROM ORG_ACCT_PERIODS_V
2669: WHERE ORGANIZATION_ID = shiporgs(j)
2670: AND STATUS = 'Open';
2671: SELECT COUNT(ORGANIZATION_ID)
2672: INTO currcnt
2669: WHERE ORGANIZATION_ID = shiporgs(j)
2670: AND STATUS = 'Open';
2671: SELECT COUNT(ORGANIZATION_ID)
2672: INTO currcnt
2673: FROM ORG_ACCT_PERIODS_V
2674: WHERE ORGANIZATION_ID = shiporgs(j)
2675: AND SYSDATE >= START_DATE
2676: AND SYSDATE < END_DATE
2677: AND STATUS = 'Open';