DBA Data[Home] [Help]

APPS.OM_SETUP_VALID_PKG dependencies on ORG_ACCT_PERIODS_V

Line 2668: FROM ORG_ACCT_PERIODS_V

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

Line 2673: FROM ORG_ACCT_PERIODS_V

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