APPS.CN_TRANSACTION_LOAD_PKG dependencies on CN_PERIOD_STATUSES_ALL

Line 1199: FROM cn_period_statuses_all

1195:
1196: /* verify that parameter end date is within an open acc period */
1197: l_open_period := 0;
1198: SELECT COUNT(*) INTO l_open_period
1199: FROM cn_period_statuses_all
1200: WHERE period_status = 'O'
1201: AND org_id = p_org_id
1202: AND (period_set_id, period_type_id) =
1203: (SELECT period_set_id, period_type_id