[Home] [Help]
2252: BULK COLLECT INTO salesrep_t
2253: FROM (SELECT DISTINCT cns.salesrep_id salesrep_id,
2254: cns.NAME salesrep_name
2255: FROM cn_payruns cnp,
2256: cn_srp_pay_groups cnspg,
2257: cn_salesreps cns,
2258: cn_period_statuses cnps
2259: WHERE cnp.payrun_id = l_payrun_id
2260: AND cnp.status = 'UNPAID'