DBA Data[Home] [Help]

APPS.INV_DETAIL_UTIL_PVT dependencies on INV_LE_TIMEZONE_PUB

Line 3050: AND INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Nvl(p_date, Sysdate),p_organization_id)

3046: SELECT acct_period_id
3047: FROM org_acct_periods
3048: WHERE period_close_date IS NULL
3049: AND organization_id = p_organization_id
3050: AND INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Nvl(p_date, Sysdate),p_organization_id)
3051: BETWEEN trunc(period_start_date) and trunc(schedule_close_date)
3052: ORDER BY period_start_date DESC, schedule_close_date ASC;
3053: l_val NUMBER;
3054: BEGIN