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 884: FROM ra_salesreps

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

Line 1516: FROM ra_salesreps

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

Line 1534: FROM ra_salesreps

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