APPS.CN_COMP_GRP_HIER_PUB dependencies on CN_REPOSITORIES
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;