DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PVT dependencies on ORG_ACCT_PERIODS

Line 705: FROM ORG_ACCT_PERIODS

701:
702: /* Commented for bug 9691823 to have same logic same as that of BaseTransaction
703: SELECT ACCT_PERIOD_ID
704: INTO l_acct_period_id
705: FROM ORG_ACCT_PERIODS
706: WHERE PERIOD_CLOSE_DATE IS NULL
707: AND ORGANIZATION_ID = p_mtl_trx_tbl(i).organization_id
708: AND TRUNC(SCHEDULE_CLOSE_DATE) >=
709: TRUNC(nvl(p_mtl_trx_tbl(i).transaction_date,SYSDATE))

Line 717: FROM org_acct_periods

713:
714: /* Added following statement for bug 9691823 */
715: SELECT acct_period_id
716: INTO l_acct_period_id
717: FROM org_acct_periods
718: WHERE period_close_date IS NULL
719: AND organization_id = p_mtl_trx_tbl(i).organization_id
720: AND (schedule_close_date + 1) >
721: inv_le_timezone_pub.get_le_day_for_inv_org(nvl(p_mtl_trx_tbl(i).transaction_date,SYSDATE),