DBA Data[Home] [Help]

APPS.INV_GMI_MIGRATION dependencies on ORG_ACCT_PERIODS

Line 2216: FROM org_acct_periods_v

2212: SELECT period_name, period_year,
2213: period_number , end_date
2214: INTO l_period_name, l_period_year,
2215: l_period_number, l_period_end_date
2216: FROM org_acct_periods_v
2217: WHERE rec_type = 'GL_PERIOD' AND
2218: period_set_name = l_period_set_name AND
2219: accounted_period_type = l_accounted_period_type AND
2220: end_date > l_last_scheduled_close_date AND

Line 2332: FROM org_acct_periods

2328: l_skip_to_next_whse := 0;
2329:
2330: SELECT NVL(MAX(schedule_close_date), sysdate)
2331: INTO l_last_scheduled_close_date
2332: FROM org_acct_periods
2333: WHERE organization_id = l_organization_id;
2334:
2335: -- Open all future periods till the sysdate
2336: FOR fp IN c_future_periods LOOP