3191: l_count := 0;
3192:
3193: SELECT COUNT(*)
3194: INTO l_count
3195: FROM cn_acc_period_statuses_v acc
3196: WHERE TRUNC(l_start_date) BETWEEN TRUNC(acc.start_date) AND TRUNC(acc.end_date)
3197: AND acc.period_status = 'O'
3198: AND acc.org_id = p_org_id
3199: AND ROWNUM = 1;
3209: l_count := 0;
3210:
3211: SELECT COUNT(*)
3212: INTO l_count
3213: FROM cn_acc_period_statuses_v acc
3214: WHERE TRUNC(l_end_date) BETWEEN TRUNC(acc.start_date) AND TRUNC(acc.end_date)
3215: AND acc.period_status = 'O'
3216: AND acc.org_id = p_org_id
3217: AND ROWNUM = 1;