APPS.AR_DEPOSIT_LIB_PVT dependencies on RA_SALESREPS

Line 34: FROM RA_SALESREPS

30: SELECT name,
31: salesrep_number
32: INTO l_default_srep_name,
33: l_default_srep_number
34: FROM RA_SALESREPS
35: WHERE SALESREP_ID = p_default_salesrep_id
36: AND NVL(status,'A') ='A'
37: AND p_deposit_date between nvl(start_date_active, p_deposit_date) and
38: nvl(end_date_active, p_deposit_date);

Line 886: FROM ra_salesreps

882: THEN
883:
884: SELECT salesrep_id
885: INTO l_selected_id
886: FROM ra_salesreps
887: WHERE name = p_value;
888:
889: ELSIF ( p_entity = 'BATCH_SOURCE_NAME' )
890: THEN

Line 1518: FROM ra_salesreps

1514: THEN
1515: begin
1516: SELECT salesrep_id
1517: INTO x_salesrep_id
1518: FROM ra_salesreps
1519: WHERE name = p_salesrep_name and
1520: NVL(status,'A') ='A' and
1521: p_deposit_date between nvl(start_date_active, p_deposit_date) and
1522: nvl(end_date_active, p_deposit_date);

Line 1536: FROM ra_salesreps

1532:
1533: begin
1534: SELECT salesrep_id
1535: INTO x_salesrep_id
1536: FROM ra_salesreps
1537: WHERE salesrep_id = x_salesrep_id and
1538: NVL(status,'A') ='A' and
1539: p_deposit_date between nvl(start_date_active, p_deposit_date) and
1540: nvl(end_date_active, p_deposit_date);