DBA Data[Home] [Help]

APPS.EAM_ASSET_MOVE_PUB dependencies on ORG_ACCT_PERIODS

Line 1340: FROM ORG_ACCT_PERIODS

1336: organization_id= p_CURRENT_ORGANIZATION_ID;
1337:
1338: SELECT ACCT_PERIOD_ID
1339: INTO l_acc_per_id
1340: FROM ORG_ACCT_PERIODS
1341: WHERE PERIOD_CLOSE_DATE IS NULL
1342: AND ORGANIZATION_ID = l_org_id
1343: AND (SCHEDULE_CLOSE_DATE + 1) > l_sysdate
1344: AND PERIOD_START_DATE <= l_sysdate ;

Line 1488: FROM ORG_ACCT_PERIODS

1484: AND organization_id =p_ORGANIZATION_ID;
1485:
1486: SELECT ACCT_PERIOD_ID
1487: INTO l_acc_per_id
1488: FROM ORG_ACCT_PERIODS
1489: WHERE PERIOD_CLOSE_DATE IS NULL
1490: AND ORGANIZATION_ID = p_ORGANIZATION_ID
1491: AND (SCHEDULE_CLOSE_DATE + 1) > l_sysdate
1492: AND PERIOD_START_DATE <= l_sysdate ;