APPS.AR_DEPOSIT_LIB_PVT dependencies on RA_SALESREP_TERRITORIES

Line 461: FROM ra_salesrep_territories st

457: l_territory_default VARCHAR2(50);
458: l_territory_id NUMBER;
459: cursor c_salesrep_territory IS
460: SELECT st.territory_id territory_id
461: FROM ra_salesrep_territories st
462: WHERE st.salesrep_id = p_salesrep_id
463: AND 'A' = NVL(st.status(+), 'A')
464: AND p_deposit_date BETWEEN NVL(st.start_date_active(+), p_deposit_date )
465: AND NVL(st.end_date_active(+), p_deposit_date );