APPS.CN_SRP_PERIODS_PVT dependencies on CN_ACC_PERIOD_STATUSES_V
Line 38: FROM cn_acc_period_statuses_v
34:
35: BEGIN
36: SELECT MIN(start_date), MAX(end_date)
37: INTO l_start_date, l_end_date 38: FROM cn_acc_period_statuses_v 39: WHERE period_status IN ('O','F')
40: AND org_id = p_org_id
41: AND ( ( p_end_date IS NOT NULL AND start_date <= p_end_date
42: AND end_date >= p_start_date )