APPS.AR_DEPOSIT_LIB_PVT dependencies on RA_SALESREP_TERRITORIES

Line 459: FROM ra_salesrep_territories st

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