APPS.CN_SCA_CREDITS_BATCH_PUB dependencies on CN_ACC_PERIOD_STATUSES_V

Line 2733: FROM cn_acc_period_statuses_v acc

2729: l_count := 0;
2730:
2731: SELECT COUNT(*)
2732: INTO l_count
2733: FROM cn_acc_period_statuses_v acc
2734: WHERE TRUNC(l_start_date) BETWEEN TRUNC(acc.start_date) AND TRUNC(acc.end_date)
2735: AND acc.period_status = 'O'
2736: AND acc.org_id = p_org_id
2737: AND ROWNUM = 1;

Line 2751: FROM cn_acc_period_statuses_v acc

2747: l_count := 0;
2748:
2749: SELECT COUNT(*)
2750: INTO l_count
2751: FROM cn_acc_period_statuses_v acc
2752: WHERE TRUNC(l_end_date) BETWEEN TRUNC(acc.start_date) AND TRUNC(acc.end_date)
2753: AND acc.period_status = 'O'
2754: AND acc.org_id = p_org_id
2755: AND ROWNUM = 1;