DBA Data[Home] [Help]

APPS.CN_TRANSACTION_LOAD_PKG dependencies on CN_PERIOD_STATUSES_ALL

Line 1203: FROM cn_period_statuses_all

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