APPS.CN_TRANSACTION_LOAD_PKG dependencies on CN_ACC_PERIOD_STATUSES_V

Line 1295: FROM cn_comm_lines_api api, cn_acc_period_statuses_v acc

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