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),
722: p_mtl_trx_tbl(i).organization_id)
723: AND period_start_date <=
724: inv_le_timezone_pub.get_le_day_for_inv_org(nvl(p_mtl_trx_tbl(i).transaction_date,SYSDATE),
725: 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),
722: p_mtl_trx_tbl(i).organization_id)
723: AND period_start_date <=
724: inv_le_timezone_pub.get_le_day_for_inv_org(nvl(p_mtl_trx_tbl(i).transaction_date,SYSDATE),
725: p_mtl_trx_tbl(i).organization_id) ;
726:
727: EXCEPTION
728: WHEN NO_DATA_FOUND THEN