APPS.CN_PURGE_TABLES_PUB dependencies on CN_PERIODS

Line 134: FROM cn_periods

130:
131: CURSOR get_start_period_id
132: IS
133: SELECT period_id
134: FROM cn_periods
135: WHERE period_name = p_start_period_name
136: AND org_id = p_org_id AND closing_status in ('C', 'P') ;
137:
138: CURSOR get_end_period_id

Line 141: FROM cn_periods

137:
138: CURSOR get_end_period_id
139: IS
140: SELECT period_id
141: FROM cn_periods
142: WHERE period_name = p_end_period_name
143: AND org_id = p_org_id AND closing_status in ('C', 'P') ;
144:
145: l_api_name CONSTANT VARCHAR2(30) := 'purge_cn_tables';