APPS.CN_COMP_GRP_HIER_PUB dependencies on CN_PERIOD_STATUSES

Line 137: FROM cn_repositories r, cn_period_statuses ps

133: -- Get the period year which will be passed to YTD Summary
134: BEGIN
135: SELECT period_year
136: INTO x_period_year
137: FROM cn_repositories r, cn_period_statuses ps
138: WHERE r.period_type_id = ps.period_type_id
139: AND r.period_set_id = ps.period_set_id
140: AND period_status IN ('O','C')
141: AND p_date BETWEEN start_date AND end_date;