eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_QUOTA_PAY_ELEMENTS_PVT dependencies on CN_SALESREPS

Line 93: cn_salesreps cs,

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
96: AND pt.pay_period_id = ps.period_id
97: AND pt.pay_element_type_id = qpe.pay_element_type_id

Line 115: cn_salesreps cs,

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
118: AND pt.pay_period_id = ps.period_id
119: AND pt.pay_element_type_id = qpe.pay_element_type_id

Line 161: cn_salesreps cs,

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
164: AND pt.pay_period_id = ps.period_id
165: AND pt.pay_element_type_id = qpe.pay_element_type_id

Line 183: cn_salesreps cs,

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
186: AND pt.pay_period_id = ps.period_id
187: AND pt.pay_element_type_id = qpe.pay_element_type_id