APPS.CN_CALC_SUBMISSION_PVT dependencies on CN_REPOSITORIES_ALL

Line 144: WHERE (period_set_id, period_type_id) = (SELECT period_set_id, period_type_id FROM cn_repositories_all

140:
141: CURSOR open_period_check(p_start_date DATE) IS
142: SELECT 1
143: FROM cn_period_statuses_all
144: WHERE (period_set_id, period_type_id) = (SELECT period_set_id, period_type_id FROM cn_repositories_all
145: WHERE org_id = p_sub_batch_rec.org_id)
146: AND period_status = 'O'
147: AND org_id = p_sub_batch_rec.org_id
148: AND trunc(p_start_date) BETWEEN trunc(start_date) AND trunc(end_date);