DBA Data[Home] [Help]

APPS.CN_IMP_TRXAPI_PVT dependencies on CN_QUOTAS

Line 184: l_quota_id cn_quotas.quota_id%TYPE;

180: l_rev_class_id cn_revenue_classes.revenue_class_id%TYPE;
181: l_role_id cn_roles.role_id%TYPE;
182: l_period_id cn_acc_period_statuses_v.period_id%TYPE;
183: l_rollup_period_id cn_acc_period_statuses_v.period_id%TYPE;
184: l_quota_id cn_quotas.quota_id%TYPE;
185: l_comp_group_id cn_comp_groups.comp_group_id%TYPE;
186: l_meaning cn_lookups.meaning%TYPE;
187:
188: l_processed_row NUMBER := 0;

Line 386: FROM cn_quotas_v

382: IF l_trxapi_imp.plan_element_name IS NOT NULL THEN
383: BEGIN
384: SELECT quota_id
385: INTO l_quota_id
386: FROM cn_quotas_v
387: WHERE name = l_trxapi_imp.plan_element_name and org_id = p_org_id
388: ;
389: EXCEPTION
390: WHEN no_data_found THEN