APPS.CN_QUOTA_PAY_ELEMENTS_PVT dependencies on CN_PAYMENT_TRANSACTIONS

Line 91: cn_payment_transactions pt,

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
95: WHERE pt.credited_salesrep_id = cs.salesrep_id

Line 113: cn_payment_transactions pt,

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
117: WHERE pt.credited_salesrep_id = cs.salesrep_id

Line 159: cn_payment_transactions pt,

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
163: WHERE pt.credited_salesrep_id = cs.salesrep_id

Line 181: cn_payment_transactions pt,

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
185: WHERE pt.credited_salesrep_id = cs.salesrep_id