APPS.CN_PERIOD_QUOTAS_PKG dependencies on CN_QUOTAS

Line 102: FROM cn_quotas

98: l_object_version_number NUMBER;
99: BEGIN
100: SELECT org_id
101: INTO l_org_id
102: FROM cn_quotas
103: WHERE quota_id = x_quota_id;
104:
105: fnd_currency.get_info (cn_global_var.get_currency_code (p_org_id => l_org_id), g_precision, g_ext_precision, g_min_acct_unit);
106:

Line 192: FROM cn_acc_period_statuses_v p, cn_quotas q

188: p_last_update_login c12,
189: p_last_updated_by c13,
190: p_created_by c14,
191: q.org_id org_id
192: FROM cn_acc_period_statuses_v p, cn_quotas q
193: WHERE q.org_id = p.org_id
194: AND q.quota_id = p_quota_id
195: AND p.period_id = p_period_id
196: AND NOT EXISTS (SELECT 'this period_quota already exists'

Line 285: FROM cn_quotas q,

281: l_login_id c12,
282: l_user_id c13,
283: l_user_id c14,
284: q.org_id
285: FROM cn_quotas q,
286: cn_acc_period_statuses_v p
287: WHERE q.quota_id = x_quota_id
288: AND p.start_date >= previous_period (q.start_date, q.org_id)
289: AND p.end_date <= cn_api.next_period (NVL (q.end_date, p.end_date), q.org_id)

Line 318: cn_quotas_v where quota_id = x_quota_id;

314: l_login_id := fnd_global.login_id;
315: l_insert_flag := 'Y';
316:
317: select end_date, org_id into l_end_date, l_org_id from
318: cn_quotas_v where quota_id = x_quota_id;
319:
320: select min(start_date) into l_min_date from cn_acc_period_statuses_v
321: where period_status IN ('F', 'O') and org_id = l_org_id;
322:

Line 424: cn_quotas cq

420: p.performance_goal
421: FROM cn_period_quotas p,
422: cn_acc_period_statuses_v cp,
423: cn_cal_per_int_types cpit,
424: cn_quotas cq
425: WHERE p.quota_id = p_quota_id
426: AND p.quota_id = cq.quota_id
427: AND cq.org_id = p.org_id
428: AND p.period_id = cp.period_id

Line 446: cn_quotas cq

442: p.period_year period_year
443: FROM cn_period_quotas p,
444: cn_acc_period_statuses_v cp,
445: cn_cal_per_int_types cpit,
446: cn_quotas cq
447: WHERE p.quota_id = p_quota_id
448: AND p.quota_id = cq.quota_id
449: AND p.period_id = cp.period_id
450: AND cp.period_id = cpit.cal_period_id

Line 581: l_org_id cn_quotas.org_id%TYPE;

577: l_end_period_id NUMBER;
578: l_max_date cn_acc_period_statuses_v.end_date%TYPE;
579: l_min_date cn_acc_period_statuses_v.start_date%TYPE;
580: l_delete_all_flag CHAR(1);
581: l_org_id cn_quotas.org_id%TYPE;
582: BEGIN
583: -- get start date, end date for the pe
584: l_delete_all_flag := 'N';
585: select start_date, end_date, org_id

Line 587: cn_quotas_v where quota_id = x_quota_id;

583: -- get start date, end date for the pe
584: l_delete_all_flag := 'N';
585: select start_date, end_date, org_id
586: into l_start_date, l_end_date, l_org_id from
587: cn_quotas_v where quota_id = x_quota_id;
588: -- max date of open or future entry periods
589: select max(end_date) into l_max_date from cn_acc_period_statuses_v
590: where period_status IN ('F', 'O') and org_id = l_org_id;
591: -- min date of open or future entry periods

Line 713: FROM cn_quotas

709: AND period_quota_id = x_start_period_quota_id;
710:
711: SELECT interval_type_id, org_id
712: INTO l_interval_type_id, l_org_id
713: FROM cn_quotas
714: WHERE quota_id = x_quota_id;
715:
716: OPEN max_prev_period_csr (l_interval_type_id, l_start_period_id, l_org_id);
717:

Line 774: cn_quotas cq

770: p.performance_goal
771: FROM cn_period_quotas p,
772: cn_acc_period_statuses_v cp,
773: cn_cal_per_int_types cpit,
774: cn_quotas cq
775: WHERE p.quota_id = x_quota_id
776: AND p.quota_id = cq.quota_id
777: AND p.period_id = cp.period_id
778: AND cp.period_id = cpit.cal_period_id

Line 799: cn_quotas cq

795: p.period_year period_year
796: FROM cn_period_quotas p,
797: cn_acc_period_statuses_v cp,
798: cn_cal_per_int_types cpit,
799: cn_quotas cq
800: WHERE p.quota_id = x_quota_id
801: AND p.quota_id = cq.quota_id
802: AND p.period_id = cp.period_id
803: AND cp.period_id = cpit.cal_period_id