DBA Data[Home] [Help]

APPS.INV_DETAIL_UTIL_PVT dependencies on ORG_ACCT_PERIODS

Line 3047: FROM org_acct_periods

3043: ( p_organization_id IN NUMBER, p_date IN DATE)
3044: RETURN NUMBER IS
3045: CURSOR l_cur IS
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)