APPS.CN_PRD_QUOTA_PUB dependencies on CN_ACC_PERIOD_STATUSES_V

Line 31: cn_acc_period_statuses_v cp,

27: spq.quota_id,
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

Line 53: cn_acc_period_statuses_v cp,

49: SELECT COUNT (spq.period_quota_id) interval_count,
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