APPS.CN_TRANSACTION_LOAD_PKG dependencies on CN_ACC_PERIOD_STATUSES_V

Line 1291: FROM cn_comm_lines_api api, cn_acc_period_statuses_v acc

1287: , acc.period_id period_id
1288: , acc.start_date start_date
1289: , acc.end_date end_date
1290: , COUNT(*) trx_count
1291: FROM cn_comm_lines_api api, cn_acc_period_statuses_v acc
1292: WHERE api.load_status = 'UNLOADED'
1293: AND api.trx_type <> 'FORECAST'
1294: AND (adjust_status <> 'SCA_PENDING' OR adjust_status IS NULL)
1295: AND api.processed_date >= TRUNC(l_start_date)