APPS.CN_PROCESS_TAE_TRX_PUB dependencies on JTF_RS_ROLES_VL

Line 490: jtf_rs_roles_vl JR,

486: ROW_NUMBER() OVER (PARTITION BY a.comm_lines_api_id
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