SQL & PL/SQL :: Query Refinement Using Max Function

I have a table structure with test data.

desc tbl_female
Name Null Type
------------------- ---------- -----------------
ANI NOT NULL VARCHAR2(12)
CHAT_ID VARCHAR2(25)
AGE VARCHAR2(5)
RECORD_FILE VARCHAR2(25)
SUB_DATE_TIME DATE
STATUS VARCHAR2(15)
LOGIN_STATUS VARCHAR2(15)
CIRCLE_NAME VARCHAR2(10)
INTEREST VARCHAR2(10)
HOBBIES VARCHAR2(10)
OLD_ID VARCHAR2(25)
SORTED NUMBER
FAIL NUMBER
TIME NUMBER
FLAG NUMBER
POINT NUMBER
SF NUMBER
ACTIVE NUMBER

and Query depending on this table sometimes provide a row or sometimes not. Query is as follows which we are using

SELECT ANI INTO SUBANI FROM (SELECT ANI FROM TBL_FEMALE WHERE point=(select max(point) from tbl_female where circle_name in('pb','hr','hp','jk','pb','bir','dl','mp','mum','mh','gj') and sf=0 and login_status='LOGIN' and status in ('A','B') ) and circle_name in('pb','hr','hp','jk','pb','bir','dl','mum','mh') and sf=0 and login_status='LOGIN' and status in ('A','B') ORDER BY RANDOM.RAND_MAX(20)) WHERE ROWNUM = 1;