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

Line 678: cn_payruns_all prun, cn_payment_transactions_all pmttrans

674: --***********************************************************************
675:
676: SELECT COUNT(1) INTO l_dummy
677: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,
678: cn_payruns_all prun, cn_payment_transactions_all pmttrans
679: WHERE w.salesrep_id = p_salesrep_id
680: AND w.salesrep_id = pmttrans.credited_salesrep_id
681: AND pmttrans.incentive_type_code = 'PMTPLN'
682: AND prun.pay_period_id = prd.period_id

Line 2334: cn_payruns_all prun, cn_payment_transactions_all pmttrans

2330:
2331:
2332: SELECT COUNT(1) INTO l_dummy
2333: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,
2334: cn_payruns_all prun, cn_payment_transactions_all pmttrans
2335: WHERE w.salesrep_id = l_spp_rec.salesrep_id
2336: AND w.salesrep_id = pmttrans.credited_salesrep_id
2337: AND pmttrans.incentive_type_code = 'PMTPLN'
2338: AND prun.pay_period_id = prd.period_id