DBA Data[Home] [Help]

APPS.INV_GMI_MIGRATION dependencies on ORG_ACCT_PERIODS

Line 2330: FROM org_acct_periods_v

2326: SELECT period_name, period_year,
2327: period_number , end_date
2328: INTO l_period_name, l_period_year,
2329: l_period_number, l_period_end_date
2330: FROM org_acct_periods_v
2331: WHERE rec_type = 'GL_PERIOD' AND
2332: period_set_name = l_period_set_name AND
2333: accounted_period_type = l_accounted_period_type AND
2334: end_date > l_last_scheduled_close_date AND

Line 2446: FROM org_acct_periods

2442: l_skip_to_next_whse := 0;
2443:
2444: SELECT NVL(MAX(schedule_close_date), sysdate)
2445: INTO l_last_scheduled_close_date
2446: FROM org_acct_periods
2447: WHERE organization_id = l_organization_id;
2448:
2449: -- Open all future periods till the sysdate
2450: FOR fp IN c_future_periods LOOP