DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PVT dependencies on INV_LE_TIMEZONE_PUB

Line 721: inv_le_timezone_pub.get_le_day_for_inv_org(nvl(p_mtl_trx_tbl(i).transaction_date,SYSDATE),

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) ;

Line 724: inv_le_timezone_pub.get_le_day_for_inv_org(nvl(p_mtl_trx_tbl(i).transaction_date,SYSDATE),

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