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_PMT_TRANS_PKG dependencies on CN_SALESREPS

Line 245: l_status cn_salesreps.status%TYPE ;

241: l_quota_id cn_payment_transactions.quota_id%TYPE;
242:
243: l_payroll_flag cn_repositories.payroll_flag%TYPE;
244: l_org_id cn_repositories.org_id%TYPE ;
245: l_status cn_salesreps.status%TYPE ;
246: l_period_set_id cn_repositories.period_set_id%TYPE ;
247: l_period_type_id cn_repositories.period_type_id%TYPE ;
248:
249: BEGIN

Line 253: FROM cn_salesreps s, cn_repositories_all r, cn_payruns_all pr

249: BEGIN
250:
251: SELECT s.org_id, s.status, r.period_set_id, r.period_type_id, NVL(r.payroll_flag,'N')
252: INTO l_org_id, l_status, l_period_set_id, l_period_type_id, l_payroll_flag
253: FROM cn_salesreps s, cn_repositories_all r, cn_payruns_all pr
254: WHERE s.salesrep_id = p_salesrep_id
255: AND s.org_id = r.org_id
256: AND pr.org_id = r.org_id
257: AND pr.payrun_id = p_payrun_id