DBA Data[Home] [Help]

APPS.CN_PERIOD_QUOTAS_GRP dependencies on CN_QUOTAS

Line 39: l_quota_type_code cn_quotas.quota_type_code%TYPE;

35: l_quota_end_date DATE;
36: l_period_start_date DATE;
37: l_period_end_date DATE;
38: l_loading_status VARCHAR2 (80);
39: l_quota_type_code cn_quotas.quota_type_code%TYPE;
40: l_org_id NUMBER;
41: BEGIN
42: -- Initialize API return status to success
43: x_return_status := fnd_api.g_ret_sts_success;

Line 109: FROM cn_quotas_v

105: l_calc_formula_id,
106: l_quota_start_date,
107: l_quota_end_date,
108: l_quota_type_code
109: FROM cn_quotas_v
110: WHERE NAME = p_quota_name AND org_id = l_org_id;
111: EXCEPTION
112: WHEN NO_DATA_FOUND
113: THEN