DBA Data[Home] [Help]

APPS.CN_GET_COMM_SUMM_DATA dependencies on CN_ACC_PERIOD_STATUSES_V

Line 306: FROM cn_acc_period_statuses_v

302: -- Get the min and max date of the period year which the
303: -- given P_PERIOD_ID is in.
304: SELECT min(period_id), max(period_id)
305: INTO l_min_period_id, l_max_period_id
306: FROM cn_acc_period_statuses_v
307: WHERE period_year = mod(floor(p_period_id/1000),10000);
308:
309: x_total_rows := 0;
310: