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_SRP_PAY_GROUPS

Line 2213: cn_srp_pay_groups cnspg,

2209: CURSOR c_payrun_srp(c_payrun_id cn_payruns.payrun_id%TYPE, c_batch_sz number) IS
2210: SELECT salesrep_id,ceil(rownum / c_batch_sz) FROM (SELECT DISTINCT cns.salesrep_id salesrep_id,
2211: cns.NAME salesrep_name
2212: FROM cn_payruns cnp,
2213: cn_srp_pay_groups cnspg,
2214: cn_salesreps cns,
2215: cn_period_statuses cnps
2216: WHERE cnp.payrun_id = c_payrun_id
2217: AND cnp.status = 'UNPAID'

Line 2298: cn_srp_pay_groups cnspg,

2294: BULK COLLECT INTO salesrep_t
2295: FROM (SELECT DISTINCT cns.salesrep_id salesrep_id,
2296: cns.NAME salesrep_name
2297: FROM cn_payruns cnp,
2298: cn_srp_pay_groups cnspg,
2299: cn_salesreps cns,
2300: cn_period_statuses cnps
2301: WHERE cnp.payrun_id = l_payrun_id
2302: AND cnp.status = 'UNPAID'