APPS.OE_INVOICE_PUB dependencies on RA_SALESREP_TERRITORIES

Line 7070: FROM ra_salesrep_territories rst

7066:
7067: IF (l_territory_code = 'SALES') THEN
7068: SELECT max(nvl(rst.territory_id, 0))
7069: INTO p_x_interface_line_rec.territory_id
7070: FROM ra_salesrep_territories rst
7071: WHERE rst.salesrep_id = nvl(p_line_rec.salesrep_id, p_header_rec.salesrep_id)
7072: AND sysdate between nvl(start_date_active, sysdate)
7073: AND nvl(end_date_active, sysdate);
7074: ELSIF (l_territory_code = 'BILL' AND p_line_rec.invoice_to_org_id IS NOT NULL) THEN