APPS.OE_INVOICE_PUB dependencies on RA_SALESREP_TERRITORIES

Line 6785: FROM ra_salesrep_territories rst

6781:
6782: IF (l_territory_code = 'SALES') THEN
6783: SELECT max(nvl(rst.territory_id, 0))
6784: INTO p_x_interface_line_rec.territory_id
6785: FROM ra_salesrep_territories rst
6786: WHERE rst.salesrep_id = nvl(p_line_rec.salesrep_id, p_header_rec.salesrep_id)
6787: AND sysdate between nvl(start_date_active, sysdate)
6788: AND nvl(end_date_active, sysdate);
6789: ELSIF (l_territory_code = 'BILL' AND p_line_rec.invoice_to_org_id IS NOT NULL) THEN