28: spq.quarter_num,
29: spq.period_year
30: FROM cn_period_quotas spq,
31: cn_acc_period_statuses_v cp,
32: cn_cal_per_int_types cpit,
33: cn_quotas cq
34: WHERE spq.quota_id = p_quota_id
35: AND spq.quota_id = cq.quota_id
36: AND spq.period_id = cp.period_id
50: cpit.interval_number interval_number,
51: spq.period_year period_year
52: FROM cn_period_quotas spq,
53: cn_acc_period_statuses_v cp,
54: cn_cal_per_int_types cpit,
55: cn_quotas cq
56: WHERE spq.quota_id = p_quota_id
57: AND spq.quota_id = cq.quota_id
58: AND spq.period_id = cp.period_id