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_PAYMENT_WORKSHEET_PVT dependencies on CN_PAYMENT_TRANSACTIONS_ALL

Line 1456: FROM cn_payment_transactions_all pmt

1452: AND posting_status = 'UNPOSTED'
1453: AND srp_payee_assign_id IS NULL
1454: -- posting_status not set to posted yet
1455: AND NOT EXISTS (SELECT NULL
1456: FROM cn_payment_transactions_all pmt
1457: WHERE pmt.credited_salesrep_id = ccl.credited_salesrep_id
1458: AND pmt.commission_line_id = ccl.commission_line_id
1459: AND pmt.credit_type_id = ccl.credit_type_id
1460: AND pmt.incentive_type_code IN ('COMMISSION', 'BONUS')

Line 2685: FROM cn_payment_transactions_all cnpt

2681: AND srp.org_id = s.org_id
2682: AND srp.org_id = r.org_id
2683: AND srp.org_id = wksht_rec.org_id
2684: AND NOT EXISTS (SELECT 'X'
2685: FROM cn_payment_transactions_all cnpt
2686: WHERE cnpt.payrun_id = wksht_rec.payrun_id
2687: AND cnpt.credited_salesrep_id = wksht_rec.salesrep_id
2688: AND cnpt.quota_id = q.quota_id
2689: AND cnpt.incentive_type_code IN ('COMMISSION', 'BONUS')