APPS.CN_QUOTA_PAY_ELEMENTS_PVT dependencies on CN_PERIOD_STATUSES

Line 90: FROM cn_period_statuses ps,

86: FROM
87: (--Quota_id is -1000 as carry over and regular quota_id as in cn_quotas
88: SELECT qpe.quota_pay_element_id,qpe.quota_id,qpe.pay_element_type_id,qpe.status,
89: MIN(ps.start_date) start_date, MAX(ps.end_date) end_date
90: FROM cn_period_statuses ps,
91: cn_payment_transactions pt,
92: cn_quota_pay_elements qpe,
93: cn_salesreps cs,
94: cn_quotas cq

Line 112: FROM cn_period_statuses ps,

108: UNION ALL
109: --Quota_id is -1001 as 'PMTPLN_REC' type.
110: SELECT qpe.quota_pay_element_id,qpe.quota_id,qpe.pay_element_type_id,qpe.status,
111: MIN(ps.start_date) start_date, MAX(ps.end_date) end_date
112: FROM cn_period_statuses ps,
113: cn_payment_transactions pt,
114: cn_quota_pay_elements qpe,
115: cn_salesreps cs,
116: cn_quotas cq

Line 158: FROM cn_period_statuses ps,

154: FROM
155: (--Quota_id is -1000 as carry over and regular quota_id as in cn_quotas
156: SELECT qpe.quota_pay_element_id,qpe.quota_id,qpe.pay_element_type_id,qpe.status,
157: MIN(ps.start_date) start_date, MAX(ps.end_date) end_date
158: FROM cn_period_statuses ps,
159: cn_payment_transactions pt,
160: cn_quota_pay_elements qpe,
161: cn_salesreps cs,
162: cn_quotas cq

Line 180: FROM cn_period_statuses ps,

176: UNION ALL
177: --Quota_id is -1001 as 'PMTPLN_REC' type.
178: SELECT qpe.quota_pay_element_id,qpe.quota_id,qpe.pay_element_type_id,qpe.status,
179: MIN(ps.start_date) start_date, MAX(ps.end_date) end_date
180: FROM cn_period_statuses ps,
181: cn_payment_transactions pt,
182: cn_quota_pay_elements qpe,
183: cn_salesreps cs,
184: cn_quotas cq