APPS.CN_PROCESS_TAE_TRX_PUB dependencies on CN_SALESREPS

Line 491: cn_salesreps CS

487: ORDER BY b.resource_id) rn
488: FROM cn_comm_lines_api a,
489: JTF_TAE_1001_SC_WINNERS b,
490: jtf_rs_roles_vl JR,
491: cn_salesreps CS
492: WHERE a.comm_lines_api_id = b.trans_object_id
493: AND NVL(a.org_id, -777) = NVL(b.org_id, -777)
494: AND b.org_id=CS.org_id
495: AND JR.role_code = b.role