DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PVT dependencies on ORG_ACCT_PERIODS

Line 702: FROM ORG_ACCT_PERIODS

698:
699: BEGIN
700: SELECT ACCT_PERIOD_ID
701: INTO l_acct_period_id
702: FROM ORG_ACCT_PERIODS
703: WHERE PERIOD_CLOSE_DATE IS NULL
704: AND ORGANIZATION_ID = p_mtl_trx_tbl(i).organization_id
705: AND TRUNC(SCHEDULE_CLOSE_DATE) >=
706: TRUNC(nvl(p_mtl_trx_tbl(i).transaction_date,SYSDATE))