3189: CURSOR l_chk_start_date_csr IS
3190: SELECT 1
3191: FROM DUAL
3192: WHERE EXISTS(SELECT 1
3193: FROM cn_acc_period_statuses_v
3194: WHERE period_status = 'O' AND org_id = l_org_id AND p_start_date >= start_date);
3195:
3196: CURSOR l_chk_end_date_csr IS
3197: SELECT 1
3196: CURSOR l_chk_end_date_csr IS
3197: SELECT 1
3198: FROM DUAL
3199: WHERE EXISTS(SELECT 1
3200: FROM cn_acc_period_statuses_v
3201: WHERE period_status = 'O' AND org_id = l_org_id AND p_end_date <= end_date);
3202:
3203: CURSOR l_batch_name_csr IS
3204: SELECT 1