DBA Data[Home] [Help]

APPS.EAM_ASSET_MOVE_PUB dependencies on ORG_ACCT_PERIODS

Line 1200: FROM ORG_ACCT_PERIODS

1196: organization_id= p_CURRENT_ORGANIZATION_ID;
1197:
1198: SELECT ACCT_PERIOD_ID
1199: INTO l_acc_per_id
1200: FROM ORG_ACCT_PERIODS
1201: WHERE PERIOD_CLOSE_DATE IS NULL
1202: AND ORGANIZATION_ID = l_org_id
1203: AND (SCHEDULE_CLOSE_DATE + 1) > l_sysdate
1204: AND PERIOD_START_DATE <= l_sysdate ;