APPS.OE_VALUE_TO_ID dependencies on RA_SALESREPS

Line 2979: FROM RA_SALESREPS

2975: END IF;
2976:
2977: SELECT SALESREP_ID
2978: INTO l_id
2979: FROM RA_SALESREPS
2980: WHERE NAME = p_salesrep;
2981:
2982: RETURN l_id;
2983:

Line 2992: FROM RA_SALESREPS

2988:
2989: BEGIN
2990: SELECT SALESREP_ID
2991: INTO l_id
2992: FROM RA_SALESREPS
2993: WHERE NAME = p_salesrep
2994: AND trunc(NVL(start_date_active, sysdate)) <= trunc(sysdate)
2995: AND trunc(NVL(end_date_active, sysdate)) >= trunc(sysdate);
2996: RETURN l_id;