APPS.CN_ADJ_DISP_PUB dependencies on CN_QUOTAS

Line 74: from cn_quotas

70:
71: -- get credit type ID from the quota_id
72: cursor get_credit_type_id (l_quota_id in number) is
73: select nvl(credit_type_id, -1000)
74: from cn_quotas
75: where quota_id = l_quota_id;
76:
77: query VARCHAR2(20000) := '
78: SELECT

Line 644: FROM cn_quotas WHERE quota_id = adj.quota_id;

640: x_adj_tbl(x_adj_count).quota_id := adj.quota_id;
641: IF adj.quota_id IS NOT NULL THEN
642: BEGIN
643: SELECT name INTO l_quota_name
644: FROM cn_quotas WHERE quota_id = adj.quota_id;
645: x_adj_tbl(x_adj_count).quota_name := l_quota_name;
646: EXCEPTION
647: WHEN no_data_found THEN
648: x_adj_tbl(x_adj_count).quota_name := NULL;