Log File Initialized... 4/12/2024 2:51:17 AM 4/12/2024 2:51:17 AM: Session Started ...... 4/12/2024 2:51:17 AM: {} 4/12/2024 2:51:17 AM: SELECT rownum AS sr_no, a.batch_no, c.client_desc , a.gdh_doc_reference_no, b.agent_name, a.gross_contribution, a.commission_rate, commission_amount, received_amount contribution_received, comm_payble, payment_amount FROM comm_cycle_detail_t a INNER JOIN am_agent_t b ON ( b.agent_id = a.agent_code AND a.org_id = b.org_id ) INNER JOIN GLAS_CLIENT_SETUP_T c ON (c.ORG_ID=a.ORG_ID AND c.CLIENT_CODE=a.AGENT_CODE) WHERE a.org_id ='' AND a.BRANCH_ID ='' AND a.batch_no ='' AND a.record_type = 'O' 4/12/2024 3:11:35 AM: Session Ended ...... 4/12/2024 3:11:35 AM: {} 4/12/2024 4:03:04 AM: Session Started ...... 4/12/2024 4:03:04 AM: {} 4/12/2024 4:03:05 AM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/12/2024 4:03:05 AM: Session Ended ...... 4/12/2024 4:03:05 AM: {} 4/12/2024 8:36:40 AM: Applccation Started...... 4/12/2024 8:36:41 AM: Apis Configured ...... 4/12/2024 8:37:00 AM: Session Started ...... 4/12/2024 8:37:00 AM: {} 4/12/2024 8:57:20 AM: Session Ended ...... 4/12/2024 8:57:20 AM: {} 4/12/2024 9:07:47 AM: Applccation Started...... 4/12/2024 9:07:47 AM: Apis Configured ...... 4/12/2024 1:12:46 PM: Session Started ...... 4/12/2024 1:12:47 PM: {} 4/12/2024 1:12:47 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/12/2024 1:12:49 PM: select RELEASE_VERSION from SM_RELEASE_INFO_T order by SERIAL_NO desc 4/12/2024 1:12:49 PM: Session Ended ...... 4/12/2024 1:12:49 PM: {} 4/12/2024 1:12:51 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 1:12:51 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 1:13:27 PM: Session Started ...... 4/12/2024 1:13:27 PM: {} 4/12/2024 1:13:27 PM: Login btn Clicked 4/12/2024 1:13:27 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/12/2024 1:13:27 PM: **************************** User global.tips Login Request..... **************************** 4/12/2024 1:13:27 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME=global.tips 4/12/2024 1:13:27 PM: select nvl(max(SERIAL_NO),0)+1 from SM_USER_LOGIN_HIST_T 4/12/2024 1:13:27 PM: select to_char(sysdate,'dd/mm/yyyy hh24:mi:ss') from dual 4/12/2024 1:13:27 PM: insert into SM_USER_LOGIN_HIST_T (SERIAL_NO,USERNAME,PASSWORD,IP_ADDRESS,OTHER_INFO,STATUS_TAG,STATUS_MESSAGE,CREATION_DATE) values (:SERIAL_NO,:USERNAME,:PASSWORD,:IP_ADDRESS,:OTHER_INFO,:STATUS_TAG,:STATUS_MESSAGE,:CREATION_DATE) params: SERIAL_NO=3104, USERNAME=global.tips, PASSWORD=C+cN1j+Te7Wg8gx/jS+gp/Ji57PZ+7ZyPkNCweHd+N6KZTR3XyrYHQiNCpiSnOJK/mEr/5hinclGnxqZFHx7UcZfPWj17fDUz+3MSsQAo2qb5u/c+LhSZAqMFNdMt87P, IP_ADDRESS=119.155.173.69, OTHER_INFO=Chrome123-123.0-Unknown, STATUS_TAG=E, STATUS_MESSAGE=Invalid Credentials, CREATION_DATE=4/13/2024 1:13:26 AM 4/12/2024 1:13:27 PM: **************************** Error at Login Request for User global.tips, Message: Invalid Credentials **************************** 4/12/2024 1:13:27 PM: update SM_USERS_T set LOGIN_ATTEMPTS=nvl(LOGIN_ATTEMPTS,0)+1 where upper(USERNAME) = upper(:USERNAME) params: USERNAME=global.tips 4/12/2024 1:13:27 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 1:13:27 PM: select LOGIN_ATTEMPTS from SM_USERS_T where upper(USERNAME) = upper(:USERNAME) params: USERNAME=global.tips 4/12/2024 1:13:29 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 1:13:29 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 1:14:02 PM: Login btn Clicked 4/12/2024 1:14:02 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/12/2024 1:14:02 PM: **************************** User global.tips Login Request..... **************************** 4/12/2024 1:14:02 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME=global.tips 4/12/2024 1:14:03 PM: ************* Deleting Un-Used Tokens.. For User: global.tips ************* 4/12/2024 1:14:03 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME=global.tips 4/12/2024 1:14:03 PM: delete from SM_EMAIL_TOKENS_T where USERID=:USERID and nvl(TOKEN_USED,'N') = :TOKEN_USED params: USERID=417, TOKEN_USED=N 4/12/2024 1:14:03 PM: select nvl(to_char(PASSWORD_LAST_CHANGE_DATE,'mm/dd/yyyy'),'N'),nvl(PASS_CHANGE_WARNING,'N') from SM_USERS_T where upper(USERNAME) = upper(:USERID) params: USERID=global.tips 4/12/2024 1:14:03 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 1:14:03 PM: select a.ORG_ID, a.ORG_DESC from TK_ORGANIZATION_SETUP_T a, SM_USER_ORG_MAPPING_T b where a.ORG_ID=b.ORG_ID AND upper(b.USERID) = upper(:USERID) params: USERID=global.tips 4/12/2024 1:14:03 PM: select nvl(max(SERIAL_NO),0)+1 from SM_USER_LOGIN_HIST_T 4/12/2024 1:14:03 PM: select to_char(sysdate,'dd/mm/yyyy hh24:mi:ss') from dual 4/12/2024 1:14:03 PM: insert into SM_USER_LOGIN_HIST_T (SERIAL_NO,USERNAME,PASSWORD,IP_ADDRESS,OTHER_INFO,STATUS_TAG,STATUS_MESSAGE,CREATION_DATE) values (:SERIAL_NO,:USERNAME,:PASSWORD,:IP_ADDRESS,:OTHER_INFO,:STATUS_TAG,:STATUS_MESSAGE,:CREATION_DATE) params: SERIAL_NO=3105, USERNAME=global.tips, PASSWORD=/RdC5sChbCzMrp+OckL7t94l2dR3l31Z0361lMqJt7y00KSsYPupJPzhdIdCiIoSFGCCdwSXjenHA4Zjt4oajKRGF1eVDL5CDOuGYkXu0JGeoOOLWFuAAzkjDIwpUBu8, IP_ADDRESS=119.153.41.38, OTHER_INFO=Chrome123-123.0-Unknown, STATUS_TAG=S, STATUS_MESSAGE=success, CREATION_DATE=4/13/2024 1:14:02 AM 4/12/2024 1:14:03 PM: update SM_USERS_T set LOGIN_ATTEMPTS=0 where upper(USERNAME) = upper(:USERNAME) params: USERNAME=global.tips 4/12/2024 1:14:03 PM: update SM_USERS_T set LAST_LOGIN=sysdate where upper(USERNAME) = upper(:USERNAME) params: USERNAME=global.tips 4/12/2024 1:14:03 PM: **************************** User global.tips Logged in Successfully.. **************************** 4/12/2024 1:14:03 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='MASTER_ADMIN_ID' 4/12/2024 1:14:03 PM: select RELEASE_VERSION from SM_RELEASE_INFO_T order by SERIAL_NO desc 4/12/2024 1:14:03 PM: select to_char(CREATION_DATE,'dd/mm/yyyy') CREATION_DATE from SM_USERS_T where upper(USERID)=upper(:USERID) params: USERID=417 4/12/2024 1:14:03 PM: select APPLICATION_ID from SM_APPLICATION_USER_MAPPING_T where USERID=:USERID order by APPLICATION_ID params: USERID=417 4/12/2024 1:14:03 PM: select ORG_ID from SM_USER_ORG_MAPPING_T b where upper(USERID) = upper(:USERID) params: USERID=global.tips 4/12/2024 1:14:03 PM: select * from SM_USERS_T where USERID=:USERID params: USERID=417 4/12/2024 1:14:03 PM: select a.ORG_ID, a.ORG_DESC from TK_ORGANIZATION_SETUP_T a, SM_USER_ORG_MAPPING_T b where a.ORG_ID=b.ORG_ID AND upper(b.USERID) = upper(:USERID) params: USERID=global.tips 4/12/2024 1:14:11 PM: sid midq4lazdnwjq2sxwmuqacx4 4/12/2024 1:14:11 PM: sid cda714a1-c883-40cf-8da1-f2fef2375610 4/12/2024 1:14:11 PM: sid ZealERP.ZealSecurity.Models.NewSecurity.User 4/12/2024 1:14:12 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME= 4/12/2024 1:14:12 PM: select * from SM_USERS_T where USERID=:USERID params: USERID=417 4/12/2024 1:14:12 PM: ************* Deleting Un-Used Tokens.. For User: ************* 4/12/2024 1:14:12 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME= 4/12/2024 1:14:12 PM: select nvl(to_char(PASSWORD_LAST_CHANGE_DATE,'mm/dd/yyyy'),'N'),nvl(PASS_CHANGE_WARNING,'N') from SM_USERS_T where upper(USERNAME) = upper(:USERID) params: USERID=global.tips 4/12/2024 1:14:12 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 1:14:12 PM: select a.ORG_ID, a.ORG_DESC from TK_ORGANIZATION_SETUP_T a, SM_USER_ORG_MAPPING_T b where a.ORG_ID=b.ORG_ID AND upper(b.USERID) = upper(:USERID) params: USERID=global.tips 4/12/2024 1:14:12 PM: select a.ORG_ID, a.ORG_DESC from TK_ORGANIZATION_SETUP_T a, SM_USER_ORG_MAPPING_T b where a.ORG_ID=b.ORG_ID AND upper(b.USERID) = upper(:USERID) params: USERID=global.tips 4/12/2024 1:14:12 PM: select nvl(e.FIRSTNAME,'') AS FIRST_NAME_NEW,nvl(e.MIDDLENAME,'') AS MIDDLE_NAME_NEW,nvl(e.LASTNAME,'') AS LAST_NAME_NEW from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='global.tips' and e.ORG_ID='6' 4/12/2024 1:14:12 PM: select nvl(e.FIRSTNAME,'') AS FIRST_NAME_NEW,nvl(e.MIDDLENAME,'') AS MIDDLE_NAME_NEW,nvl(e.LASTNAME,'') AS LAST_NAME_NEW from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='global.tips' and e.ORG_ID='6' 4/12/2024 1:14:12 PM: select e.EMPLOYEENUMBER from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='global.tips' and e.ORG_ID='6' 4/12/2024 1:14:12 PM: select e.EMPLOYEENUMBER from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='global.tips' and e.ORG_ID='6' 4/12/2024 1:14:12 PM: select to_char(sysdate,'dd/mm/yyyy hh24:mi:ss') from dual 4/12/2024 1:14:12 PM: select e.*,e.EMPLOYEEID from employee e,sm_users_t u where u.email=e.OFFICIALEMAIL and e.org_id='6' and u.USERNAME='global.tips' 4/12/2024 1:14:12 PM: select APPLICATION_ID from SM_APPLICATION_USER_MAPPING_T where USERID= :USERID order by APPLICATION_ID params: USERID=417 4/12/2024 1:14:12 PM: select a.ORG_ID,a.ORG_DESC, b.BRANCH_ID, b.BRANCH_DESC from TK_ORGANIZATION_SETUP_T a, TK_BRANCH_SETUP_T b, SM_USER_BRANCH_MAPPING_T c where a.ORG_ID = b.ORG_ID and b.ORG_ID = c.ORG_ID and b.BRANCH_ID = c.BRANCH_ID and upper(USERID) = upper(:USERID) params: USERID=global.tips 4/12/2024 1:14:12 PM: select DEFAULT_MENU, MENU_URL from SM_APPLICATION_MENU_T where APPLICATION_ID=:APPLICATION_ID and DEFAULT_MENU ='Y' and MENU_ID in ( select a.MENU_ID from SM_APPLICATION_MENU_T a left outer join SM_APP_USER_MENU_EXCEPTIONS_T b on ( a.APPLICATION_ID = b.APPLICATION_ID and b.USERID=:USERID and a.MENU_ID = b.MENU_ID), SM_APP_MENU_ROLE_MAPPING_T c where a.APPLICATION_ID=:APPLICATION_ID2 and a.APPLICATION_ID = c.APPLICATION_ID and a.MENU_ID = c.MENU_ID and ((c.ROLE_ID in (select ROLE_ID from SM_USER_ROLE_MAPPING_T where USERID=:USERID2 and ROLE_START_DATE <= sysdate and ((ROLE_END_DATE > sysdate) or (ROLE_END_DATE is null)))) ) and c.ROLE_ID not in (select ROLE_ID from SM_ROLE_SETUP_T where APPLICATION_ID=:APPLICATION_ID3 and ROLE_END_DATE < sysdate) and nvl(b.EXCEPTION_TYPE,'Include')='Include' and a.ACTIVE='1' ) params: APPLICATION_ID=23, USERID=417, APPLICATION_ID2=23, USERID2=417, APPLICATION_ID3=23 4/12/2024 1:14:12 PM: select APPLICATION_DESC,BRANCH_REQUIRED from SM_APPLICATION_SETUPHD_T where APPLICATION_ID=:APPLICATION_ID params: APPLICATION_ID=23 4/12/2024 1:14:12 PM: select a.ORG_ID, a.ORG_DESC from TK_ORGANIZATION_SETUP_T a, SM_USER_ORG_MAPPING_T b where a.ORG_ID=b.ORG_ID AND upper(b.USERID) = upper(:USERID) params: USERID=global.tips 4/12/2024 1:14:12 PM: select a.APPLICATION_ID, a.MENU_ID, a.MENU_DESC, a.MENU_URL, a.MENU_CONTROLLER_NAME, a.MENU_ACTION_NAME , a.MENU_ICON, a.MENU_TYPE, a.PARENT_MENU_ID, a.DISPLAY_ORDER ,nvl(CONTROL_VIEW,'N') CONTROL_VIEW ,nvl(CONTROL_ADD,'N') CONTROL_ADD ,nvl(CONTROL_UPDATE,'N') CONTROL_UPDATE ,nvl(CONTROL_DELETE,'N') CONTROL_DELETE ,nvl(CONTROL_VERIFY,'N') CONTROL_VERIFY ,nvl(CONTROL_APPROVE,'N') CONTROL_APPROVE from SM_APPLICATION_MENU_T a left outer join SM_APP_USER_MENU_EXCEPTIONS_T b on ( a.APPLICATION_ID = b.APPLICATION_ID and b.USERID=:USERID and a.MENU_ID = b.MENU_ID), SM_APP_MENU_ROLE_MAPPING_T c where a.APPLICATION_ID=:APPLICATION_ID and a.APPLICATION_ID = c.APPLICATION_ID and a.MENU_ID = c.MENU_ID and ((c.ROLE_ID in (select ROLE_ID from SM_USER_ROLE_MAPPING_T where USERID=:USERID2 and ROLE_START_DATE <= sysdate and ((ROLE_END_DATE > sysdate) or (ROLE_END_DATE is null)))) ) and c.ROLE_ID not in (select ROLE_ID from SM_ROLE_SETUP_T where APPLICATION_ID=:APPLICATION_ID2 and ROLE_END_DATE < sysdate) and nvl(b.EXCEPTION_TYPE,'Include')='Include' and a.ACTIVE='1' order by DISPLAY_ORDER params: USERID=417, APPLICATION_ID=23, USERID2=417, APPLICATION_ID2=23 4/12/2024 1:14:12 PM: select RESTRICTION_ID,RESTRICTION_VALUE from SM_RESTRICTIONS_ROLE_MAPPING_T a where a.APPLICATION_ID=:APPLICATION_ID and ((ROLE_ID in (select ROLE_ID from SM_USER_ROLE_MAPPING_T where USERID=:USERID and ROLE_START_DATE <= sysdate and ((ROLE_END_DATE > sysdate) or (ROLE_END_DATE is null)))) ) and ROLE_ID not in (select ROLE_ID from SM_ROLE_SETUP_T where APPLICATION_ID=:APPLICATION_ID2 and ROLE_END_DATE < sysdate) order by RESTRICTION_ID params: APPLICATION_ID=23, USERID=417, APPLICATION_ID2=23 4/12/2024 1:14:12 PM: select a.APPLICATION_ID, a.MENU_ID, a.ROLE_ID, a.TAB_ID, TAB_DESC, TAB_HTML_ID ,nvl(CONTROL_VIEW,'N') CONTROL_VIEW ,nvl(CONTROL_ADD,'N') CONTROL_ADD ,nvl(CONTROL_UPDATE,'N') CONTROL_UPDATE ,nvl(CONTROL_DELETE,'N') CONTROL_DELETE ,nvl(CONTROL_VERIFY,'N') CONTROL_VERIFY ,nvl(CONTROL_APPROVE,'N') CONTROL_APPROVE from SM_APP_MENU_ROLE_TABS_T a, SM_APPLICATION_MENU_TABS_T b where a.APPLICATION_ID = b.APPLICATION_ID and a.MENU_ID = b.MENU_ID and a.TAB_ID = b.TAB_ID and a.APPLICATION_ID=:APPLICATION_ID and ((ROLE_ID in (select ROLE_ID from SM_USER_ROLE_MAPPING_T where USERID=:USERID and ROLE_START_DATE <= sysdate and ((ROLE_END_DATE > sysdate) or (ROLE_END_DATE is null)))) ) and ROLE_ID not in (select ROLE_ID from SM_ROLE_SETUP_T where APPLICATION_ID=:APPLICATION_ID2 and ROLE_END_DATE < sysdate) order by TAB_ID params: APPLICATION_ID=23, USERID=417, APPLICATION_ID2=23 4/12/2024 1:14:12 PM: select a.ORG_ID,a.ORG_DESC, b.BRANCH_ID, b.BRANCH_DESC from TK_ORGANIZATION_SETUP_T a, TK_BRANCH_SETUP_T b, SM_USER_BRANCH_MAPPING_T c where a.ORG_ID = b.ORG_ID and b.ORG_ID = c.ORG_ID and b.BRANCH_ID = c.BRANCH_ID and upper(USERID) = upper(:USERID) params: USERID=global.tips 4/12/2024 1:14:12 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='GENERAL_PARAMETER_APP_ID' 4/12/2024 1:14:12 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='AGENCY_MANAGEMENT_APP_ID' 4/12/2024 1:14:12 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='ZEAL_FINANCIAL_APP_ID' 4/12/2024 1:14:12 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='GLAS_APP_ID' 4/12/2024 1:14:12 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='ILAS_APP_ID' 4/12/2024 1:14:12 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='GHAS_APP_ID' 4/12/2024 1:14:12 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='IHAS_APP_ID' 4/12/2024 1:14:12 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='NEW_ADVICE_ENTRY' 4/12/2024 1:14:49 PM: select * from SM_APPLICATION_SETUPHD_T where ACTIVE='1' order by APPLICATION_ID 4/12/2024 1:14:49 PM: select * from SM_APPLICATION_USER_MAPPING_T order by APPLICATION_ID,USERID 4/12/2024 1:14:49 PM: select a.ORG_ID from SM_USER_ORG_MAPPING_T a where upper(a.USERID) = :USERID params: USERID=GLOBAL.TIPS 4/12/2024 1:14:49 PM: select a.BRANCH_ID, a.BRANCH_DESC from TK_BRANCH_SETUP_T a, SM_USER_BRANCH_MAPPING_T b where a.BRANCH_ID = b.BRANCH_ID and upper(USERID) = upper(:USERID) and b.ORG_ID=:ORG_ID and a.ORG_ID=b.ORG_ID order by a.BRANCH_DESC params: USERID=GLOBAL.TIPS, ORG_ID=6 4/12/2024 1:14:51 PM: select distinct a.CHANNEL_ID, a.CHANNEL_NAME from AM_DISTRIBUTION_CHANNEL_T a, AM_AGENT_CHANNEL_MODEL_T b where a.ORG_ID=b.ORG_ID and a.CHANNEL_ID = b.CHANNEL_ID and a.ORG_ID=:ORG_ID and b.AGENT_ID in (select AGENT_ID from AM_AGENT_T where username=:AGENT_ID) params: ORG_ID=6, AGENT_ID=global.tips 4/12/2024 1:14:52 PM: select distinct b.PARTNER_ID,b.PARTNER_NAME from AM_AGENT_PARTNER_T a left join AM_PARTNER_T b on a.ORG_ID=b.ORG_ID AND a.PARTNER_ID=b.PARTNER_ID WHERE a.ORG_ID=:ORG_ID and a.AGENT_ID in (select AGENT_ID from AM_AGENT_T where username=:AGENT_ID) params: ORG_ID=6, AGENT_ID=global.tips 4/12/2024 1:15:03 PM: select DEFAULT_MENU, MENU_URL from SM_APPLICATION_MENU_T where APPLICATION_ID=:APPLICATION_ID and DEFAULT_MENU ='Y' and MENU_ID in ( select a.MENU_ID from SM_APPLICATION_MENU_T a left outer join SM_APP_USER_MENU_EXCEPTIONS_T b on ( a.APPLICATION_ID = b.APPLICATION_ID and b.USERID=:USERID and a.MENU_ID = b.MENU_ID), SM_APP_MENU_ROLE_MAPPING_T c where a.APPLICATION_ID=:APPLICATION_ID2 and a.APPLICATION_ID = c.APPLICATION_ID and a.MENU_ID = c.MENU_ID and ((c.ROLE_ID in (select ROLE_ID from SM_USER_ROLE_MAPPING_T where USERID=:USERID2 and ROLE_START_DATE <= sysdate and ((ROLE_END_DATE > sysdate) or (ROLE_END_DATE is null)))) ) and c.ROLE_ID not in (select ROLE_ID from SM_ROLE_SETUP_T where APPLICATION_ID=:APPLICATION_ID3 and ROLE_END_DATE < sysdate) and nvl(b.EXCEPTION_TYPE,'Include')='Include' and a.ACTIVE='1' ) params: APPLICATION_ID=23, USERID=417, APPLICATION_ID2=23, USERID2=417, APPLICATION_ID3=23 4/12/2024 1:15:03 PM: select APPLICATION_DESC,BRANCH_REQUIRED from SM_APPLICATION_SETUPHD_T where APPLICATION_ID=:APPLICATION_ID params: APPLICATION_ID=23 4/12/2024 1:15:03 PM: select a.ORG_ID,a.ORG_DESC, b.BRANCH_ID, b.BRANCH_DESC from TK_ORGANIZATION_SETUP_T a, TK_BRANCH_SETUP_T b, SM_USER_BRANCH_MAPPING_T c where a.ORG_ID = b.ORG_ID and b.ORG_ID = c.ORG_ID and b.BRANCH_ID = c.BRANCH_ID and upper(USERID) = upper(:USERID) params: USERID=global.tips 4/12/2024 1:15:03 PM: select a.ORG_ID,a.ORG_DESC, b.BRANCH_ID, b.BRANCH_DESC from TK_ORGANIZATION_SETUP_T a, TK_BRANCH_SETUP_T b, SM_USER_BRANCH_MAPPING_T c where a.ORG_ID = b.ORG_ID and b.ORG_ID = c.ORG_ID and b.BRANCH_ID = c.BRANCH_ID and upper(USERID) = upper(:USERID) and b.BRANCH_ID=:BRANCH_ID params: USERID=global.tips, BRANCH_ID=1 4/12/2024 1:15:03 PM: select a.ORG_ID, a.ORG_DESC from TK_ORGANIZATION_SETUP_T a, SM_USER_ORG_MAPPING_T b where a.ORG_ID=b.ORG_ID AND upper(b.USERID) = upper(:USERID) params: USERID=global.tips 4/12/2024 1:15:03 PM: Select DEFAULT_CURRENCY,DEFAULT_COUNTRY From TK_BRANCH_SETUP_T where BRANCH_ID=:BRANCH_ID params: BRANCH_ID=1 4/12/2024 1:15:03 PM: select to_char(UNDWT_FREEZE_DATE,'dd-mon-yyyy') FROM TK_PERIOD_SETUP_T where UNDWT_FREEZE_TAG='Y' And ORG_ID = :ORG_ID ANd BRANCH_ID = :BRANCH_ID and APPLICATION_ID= :APPLICATION_ID params: ORG_ID=6, BRANCH_ID=1, APPLICATION_ID=23 4/12/2024 1:15:03 PM: select a.ORG_ID,a.ORG_DESC, b.BRANCH_ID, b.BRANCH_DESC from TK_ORGANIZATION_SETUP_T a, TK_BRANCH_SETUP_T b, SM_USER_BRANCH_MAPPING_T c where a.ORG_ID = b.ORG_ID and b.ORG_ID = c.ORG_ID and b.BRANCH_ID = c.BRANCH_ID and upper(USERID) = upper(:USERID) params: USERID=global.tips 4/12/2024 1:15:07 PM: select (select count(*) from LM_NOTIFICATIONS_T where ((FROM_EMPLOYEEID=e.EMPLOYEEID AND NOTF_TYPEID='INF') or (TO_EMPLOYEEID=e.EMPLOYEEID and NOTF_TYPEID='ACT')) and STATUS='OP') as NOTIFICATIONS, e.*,e.EMPLOYEEID from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='global.tips' and e.org_id='6' 4/12/2024 1:15:07 PM: select (select count(*) from LM_NOTIFICATIONS_T where ((FROM_EMPLOYEEID=e.EMPLOYEEID AND NOTF_TYPEID='INF') or (TO_EMPLOYEEID=e.EMPLOYEEID and NOTF_TYPEID='ACT')) and STATUS='OP') as NOTIFICATIONS, e.*,e.EMPLOYEEID from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='global.tips' and e.org_id='6' 4/12/2024 1:15:07 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='SECURITY_MODULE_APP_ID' 4/12/2024 1:15:07 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='HCM_APP_ID' 4/12/2024 1:15:07 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='ISSUE_DATE_EDITABLE' 4/12/2024 1:15:07 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='PROV_RECEIPT_VOUCHER_TYPE' 4/12/2024 1:15:07 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='KNOCKOFF_VOUCHER_ON_CURRENT_DATE' 4/12/2024 1:15:07 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='GLAS_BULK_POSTING' 4/12/2024 1:15:07 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='SHOW_WITHOUT_ACCOUNTING' 4/12/2024 1:15:07 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='NEW_VOUCHER_ENTRY' 4/12/2024 1:15:07 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='SUITE_ANALYSIS' 4/12/2024 1:15:07 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='NEED_ANALYSIS' 4/12/2024 1:15:07 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='OCC_ON_ILLUSTRATION' 4/12/2024 1:15:07 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='CBC_ON_PROPOSAL' 4/12/2024 1:15:09 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 1:15:09 PM: select Logo_image from TK_ORGANIZATION_SETUP_T where org_id='6' 4/12/2024 1:15:28 PM: select (select count(*) from LM_NOTIFICATIONS_T where ((FROM_EMPLOYEEID=e.EMPLOYEEID AND NOTF_TYPEID='INF') or (TO_EMPLOYEEID=e.EMPLOYEEID and NOTF_TYPEID='ACT')) and STATUS='OP') as NOTIFICATIONS, e.*,e.EMPLOYEEID from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='global.tips' and e.org_id='6' 4/12/2024 1:15:28 PM: select (select count(*) from LM_NOTIFICATIONS_T where ((FROM_EMPLOYEEID=e.EMPLOYEEID AND NOTF_TYPEID='INF') or (TO_EMPLOYEEID=e.EMPLOYEEID and NOTF_TYPEID='ACT')) and STATUS='OP') as NOTIFICATIONS, e.*,e.EMPLOYEEID from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='global.tips' and e.org_id='6' 4/12/2024 1:15:29 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 1:15:29 PM: select Logo_image from TK_ORGANIZATION_SETUP_T where org_id='6' 4/12/2024 1:15:32 PM: select TP_ID,PLAN_NAME from TRAVEl_PLAN_T WHERE ORG_ID=6 AND BRANCH_ID=1 4/12/2024 1:15:32 PM: select a.*,(b.FIRST_NAME||' '||B.LAST_NAME ||' ('||B.USERNAME ||')') AS USERNAME,CASE WHEN A.PARENT_AGENT IS NULL THEN ' 'ELSE (PA.FIRST_NAME||' '||PA.LAST_NAME ||' ('|| PA.USERNAME ||')') END AS PARENT_AGENT_NAME from AGENT_AUTHORITY_T a left join SM_USERS_T b ON a.USER_ID=b.USERID left join SM_USERS_T pa ON a.PARENT_AGENT=pa.USERID where a.ORG_ID=:ORG_ID AND A.BRANCH_ID=:BRANCH_ID params: ORG_ID=6, BRANCH_ID=1 4/12/2024 1:15:32 PM: select b.USERID,b.USERNAME as USER_1,(b.FIRST_NAME||' '||B.LAST_NAME ||' ('|| B.USERNAME||')') AS USERNAME from AGENT_REGISTRATION_T a left join SM_USERS_T b ON a.USERNAME = b.USERNAME left join SM_USER_ORG_MAPPING_T m ON m.USERID=a.USERNAME LEFT JOIN SM_USER_BRANCH_MAPPING_T branch on m.ORG_ID=branch.ORG_ID and a.USERNAME=branch.USERID WHERE IS_APPROVED = 'Y' AND m.ORG_ID=6 and branch.branch_id=1 4/12/2024 1:16:52 PM: select TP_ID FROM AGENT_PLAN_MAPPING WHERE ORG_ID=6 AND USER_ID='544' AND BRANCH_ID=1 4/12/2024 1:16:57 PM: select TP_ID FROM AGENT_PLAN_MAPPING WHERE ORG_ID=6 AND USER_ID='544' AND BRANCH_ID=1 4/12/2024 1:17:10 PM: select TP_ID FROM AGENT_PLAN_MAPPING WHERE ORG_ID=6 AND USER_ID='498' AND BRANCH_ID=1 4/12/2024 1:17:13 PM: select TP_ID FROM AGENT_PLAN_MAPPING WHERE ORG_ID=6 AND USER_ID='544' AND BRANCH_ID=1 4/12/2024 1:17:59 PM: delete from AGENT_PLAN_MAPPING WHERE ORG_ID=6 AND USER_ID='544' AND BRANCH_ID=1 4/12/2024 1:17:59 PM: insert into AGENT_PLAN_MAPPING(ORG_ID,TP_ID,PLAN_MAPPING_ID,USER_ID,BRANCH_ID) VALUES(6,3,1,544,1) 4/12/2024 1:17:59 PM: insert into AGENT_PLAN_MAPPING(ORG_ID,TP_ID,PLAN_MAPPING_ID,USER_ID,BRANCH_ID) VALUES(6,5,2,544,1) 4/12/2024 1:17:59 PM: insert into AGENT_PLAN_MAPPING(ORG_ID,TP_ID,PLAN_MAPPING_ID,USER_ID,BRANCH_ID) VALUES(6,7,3,544,1) 4/12/2024 1:17:59 PM: select to_char(sysdate,'dd/mm/yyyy hh24:mi:ss') from dual 4/12/2024 1:17:59 PM: update AGENT_AUTHORITY_T set UNLIMITED_CREDIT = :UNLIMITED_CREDIT , MAX_AMOUNT = :MAX_AMOUNT , NUMBER_OF_DAYS = :NUMBER_OF_DAYS , AGENT_COMISSION = :AGENT_COMISSION , PARENT_AGENT = :PARENT_AGENT , LAST_UPDATED_BY = :LAST_UPDATED_BY , LAST_UPDATE_DATE = :LAST_UPDATE_DATE where ORG_ID = :ORG_ID and BRANCH_ID = :BRANCH_ID and AGENT_AUTH_ID = :AGENT_AUTH_ID and USER_ID = :USER_ID params: UNLIMITED_CREDIT=, MAX_AMOUNT=120000, NUMBER_OF_DAYS=0, AGENT_COMISSION=50, PARENT_AGENT=417, LAST_UPDATED_BY=global.tips, LAST_UPDATE_DATE=4/13/2024 1:17:58 AM, ORG_ID=6, BRANCH_ID=1, AGENT_AUTH_ID=138, USER_ID=544 4/12/2024 1:17:59 PM: select nvl(max(SERIAL_NO),0)+1 from AUDIT_LOGS_T 4/12/2024 1:17:59 PM: insert into AUDIT_LOGS_T (SERIAL_NO,TABLENAME,USERID,LOG_DATE,SQL_QUERY) values ('12973','AGENT_AUTHORITY_T','global.tips',sysdate,'update AGENT_AUTHORITY_T set ORG_ID=''6'',BRANCH_ID=''1'',AGENT_AUTH_ID=''138'',UNLIMITED_CREDIT= null ,MAX_AMOUNT=''120000'',NUMBER_OF_DAYS=''0'',AGENT_COMISSION=''50'',USER_ID=''544'',PARENT_AGENT=''417'',LAST_UPDATED_BY=''global.tips'', LAST_UPDATE_DATE=sysdate where ORG_ID = :ORG_ID and BRANCH_ID = :BRANCH_ID and AGENT_AUTH_ID = :AGENT_AUTH_ID and USER_ID = :USER_ID') 4/12/2024 1:18:00 PM: select a.*,(b.FIRST_NAME||' '||B.LAST_NAME ||' ('||B.USERNAME ||')') AS USERNAME,CASE WHEN A.PARENT_AGENT IS NULL THEN ' 'ELSE (PA.FIRST_NAME||' '||PA.LAST_NAME ||' ('|| PA.USERNAME ||')') END AS PARENT_AGENT_NAME from AGENT_AUTHORITY_T a left join SM_USERS_T b ON a.USER_ID=b.USERID left join SM_USERS_T pa ON a.PARENT_AGENT=pa.USERID where a.ORG_ID=:ORG_ID AND A.BRANCH_ID=:BRANCH_ID params: ORG_ID=6, BRANCH_ID=1 4/12/2024 1:18:09 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/12/2024 1:18:09 PM: Session Ended ...... 4/12/2024 1:18:09 PM: {} 4/12/2024 1:18:09 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 1:18:09 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 2:05:29 PM: Applccation Started...... 4/12/2024 2:05:30 PM: Apis Configured ...... 4/12/2024 2:05:32 PM: Session Started ...... 4/12/2024 2:05:33 PM: {} 4/12/2024 3:23:37 PM: Session Started ...... 4/12/2024 3:23:37 PM: {} 4/12/2024 3:23:38 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/12/2024 3:23:39 PM: select RELEASE_VERSION from SM_RELEASE_INFO_T order by SERIAL_NO desc 4/12/2024 3:23:39 PM: Session Ended ...... 4/12/2024 3:23:39 PM: {} 4/12/2024 4:56:49 PM: Session Started ...... 4/12/2024 4:56:49 PM: {} 4/12/2024 4:56:49 PM: SELECT to_char(a.GDH_ISSUE_DATE,'dd-Mon-yyyy') ProposalIssueDate, to_char(a.GDH_EXPIRY_DATE,'dd-Mon-yyyy') ProposalValidity, nvl(e.CONTACT_NAME,'-') CONTACT_NAME, nvl(e.DESIGNATION,'-') DESIGNATION, nvl(e.LANDLINE_NO,'-') PHONE_NO, nvl(e.EMAIL,'-') EMAIL, e.MOBILE_NO CONTACT_NUMBER, nvl(ea.ADDRESS1,'') || ' ' || nvl(ea.ADDRESS2,'') COMPANYADDRESS, nvl(s.state_name, '-') State, nvl(t.city_name, '-') City, con.country_desc, a.GDH_DOC_REFERENCE_NO ProposalVersion, s.AGENT_NAME AgentBrokerName, c.client_desc PolicyHolder FROM TK_DOC_HEADER_T a LEFT OUTER JOIN GLAS_CLIENT_SETUP_T b on (a.ORG_ID = b.ORG_ID AND a.PPS_PARTY_CODE = b.CLIENT_CODE) LEFT OUTER JOIN GLAS_CLIENT_CONTACTPERSON_T e ON (e.ORG_ID = b.ORG_ID AND e.CLIENT_CODE = b.CLIENT_CODE ) left outer join ENTITY_ADDRESS_T ea ON (ea.ENTITY_TYPE='CLT' AND ea.ENTITY_CODE = a.PPS_PARTY_CODE AND ea.ORG_ID = a.ORG_ID) LEFT OUTER JOIN COUNTRY_STATE_T s ON ( a.org_id = ea.org_id AND s.STATE_CODE = ea.STATE_CODE) LEFT OUTER JOIN COUNTRY_CITY_T t ON (a.org_id = ea.org_id AND t.STATE_CODE = s.STATE_CODE AND t.CITY_CODE = ea.CITY_CODE) LEFT OUTER JOIN COUNTRY con ON (con.country_code = ea.country_code) left outer join GLAS_DOC_INSURED_ITEMS_T i ON (a.ORG_ID = i.ORG_ID and a.BRANCH_ID = i.BRANCH_ID and a.product_code = i.product_code and a.sub_product_code = i.sub_product_code and a.takaful_type = i.takaful_type and a.document_type = i.document_type and a.record_type = i.record_type) left outer join GLAS_CLIENT_SETUP_T c on (a.org_id = c.org_id and a.pps_party_code = c.client_code) left outer join AM_AGENT_T s on (a.org_id = s.org_id and a.producer_code = s.AGENT_ID) where a.org_id = '' and a.GDH_DOC_REFERENCE_NO ='' and a.Document_type = '' and a.ISSUE_COUNT = '' 4/12/2024 4:56:50 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='GENERAL_PARAMETER_APP_ID' 4/12/2024 4:56:50 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='ILAS_APP_ID' 4/12/2024 4:56:50 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='GHAS_APP_ID' 4/12/2024 4:56:50 PM: select nob3.description ContPayFreq, cs.CURRENCY_NAME Currency, ben.free_cover_limit FCL, (ben.age_from) || ' Years to ' || (a.MAX_AGE_LIMIT) || ' Years ' CovEntryAge, a.MAX_AGE_LIMIT +1 || ' Years ' CovExpiryAge, initcap(nvl(nob3.description,'-')) SchemeTerm, ben.age_to || ' Years ' FCLApplicableuptoAge FROM TK_DOC_HEADER_T a left outer join GLAS_DOC_BENEFIT_T Ben ON (a.ORG_ID = ben.ORG_ID and a.BRANCH_ID = ben.BRANCH_ID and a.product_code = ben.product_code and a.sub_product_code = ben.sub_product_code and a.takaful_type = ben.takaful_type and a.document_type = ben.document_type and a.record_type = ben.record_type and a.document_no = ben.document_no and a.document_year = ben.document_year and a.issue_count = ben.issue_count and a.endorsement_no = ben.endorsement_no and a.application_id = ben.application_id and ben.benefit_type = 'B') LEFT OUTER JOIN (SELECT e.APPLICATION_ID,e.ORG_ID,ABBREVIATION,DESCRIPTION FROM GEN_PARAM_SETUPHD_T e, GEN_PARAM_SETUP_DTL_T f where e.ORG_ID=f.ORG_ID and e.APPLICATION_ID=f.APPLICATION_ID and e.SETUP_ID=f.SETUP_ID and e.SETUP_NAME='PAYMENT MODE' ) nob3 ON (nob3.ORG_ID = a.org_id AND nob3.APPLICATION_ID = '12' AND nob3.ABBREVIATION = a.payment_mode) left outer join CURRENCY_SETUP_T cs on (a.currency_code = cs.currency_code) where a.org_id = '' and a.GDH_DOC_REFERENCE_NO ='' and a.Document_type = '' and a.ISSUE_COUNT = '' 4/12/2024 4:56:50 PM: select c.BENEFIT_DESC BenefitsRequired, CASE WHEN nob.description = 'Salary Factor' then nob.description || ' x '|| TRIM(TO_CHAR(to_number(ben.FLAT_AMOUNT), '999,999,999,999,999')) WHEN nob.description = 'Flat Amount for All' then nob.description || ' ('|| TRIM(TO_CHAR(to_number(ben.FLAT_AMOUNT), '999,999,999,999,999')) || ')' WHEN nob.description = 'Category and Salary Slab' then nob.description || ' Based' WHEN nob.description = 'Category' then nob.description || ' Based' WHEN nob.description = 'Salary Slab' then nob.description || ' Based' WHEN nob.description = 'Percent of Basic Benefit' THEN ben.PERCENT_OF_BASIC || ' Percent of Basic Benefit Min ' || ben.SA_FROM || ', Max ' || ben.SA_TO ELSE '-' END AS BasisofCoverage FROM TK_DOC_HEADER_T a left outer join GLAS_DOC_BENEFIT_T Ben ON (a.ORG_ID = ben.ORG_ID and a.BRANCH_ID = ben.BRANCH_ID and a.product_code = ben.product_code and a.sub_product_code = ben.sub_product_code and a.takaful_type = ben.takaful_type and a.document_type = ben.document_type and a.record_type = ben.record_type and a.document_no = ben.document_no and a.document_year = ben.document_year and a.issue_count = ben.issue_count and a.endorsement_no = ben.endorsement_no and a.application_id = ben.application_id) LEFT OUTER JOIN GLAS_BENEFIT_SETUP_T c ON (ben.benefit_code = c.benefit_code and ben.org_id = c.org_id and c.application_id = ben.application) LEFT OUTER JOIN (SELECT e.APPLICATION_ID,e.ORG_ID,ABBREVIATION,DESCRIPTION FROM GEN_PARAM_SETUPHD_T e, GEN_PARAM_SETUP_DTL_T f where e.ORG_ID=f.ORG_ID and e.APPLICATION_ID=f.APPLICATION_ID and e.SETUP_ID=f.SETUP_ID and e.SETUP_NAME='SUM INSURED BASIS' ) nob ON (nob.ORG_ID = a.org_id AND nob.APPLICATION_ID = '11' AND nob.ABBREVIATION = ben.SUM_INSURED_BASIS) where a.org_id = '' and a.GDH_DOC_REFERENCE_NO ='' and a.Document_type = '' and a.ISSUE_COUNT = '' order by c.benefit_desc asc 4/12/2024 7:57:33 PM: Session Started ...... 4/12/2024 7:57:33 PM: {} 4/12/2024 7:58:25 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/12/2024 7:58:25 PM: Session Ended ...... 4/12/2024 7:58:25 PM: {} 4/12/2024 8:34:17 PM: Applccation Started...... 4/12/2024 8:34:18 PM: Apis Configured ...... 4/12/2024 8:58:24 PM: Session Started ...... 4/12/2024 8:58:24 PM: {} 4/12/2024 8:58:24 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/12/2024 8:58:26 PM: select RELEASE_VERSION from SM_RELEASE_INFO_T order by SERIAL_NO desc 4/12/2024 8:58:26 PM: Session Ended ...... 4/12/2024 8:58:26 PM: {} 4/12/2024 9:01:15 PM: Session Started ...... 4/12/2024 9:01:15 PM: {} 4/12/2024 9:01:15 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/12/2024 9:01:15 PM: Session Ended ...... 4/12/2024 9:01:15 PM: {} 4/12/2024 10:16:28 PM: Session Started ...... 4/12/2024 10:16:28 PM: {} 4/12/2024 10:16:28 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/12/2024 10:16:28 PM: Session Ended ...... 4/12/2024 10:16:28 PM: {} 4/12/2024 10:16:37 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 10:16:37 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 10:32:10 PM: Session Started ...... 4/12/2024 10:32:10 PM: {} 4/12/2024 10:32:11 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/12/2024 10:32:11 PM: Session Ended ...... 4/12/2024 10:32:11 PM: {} 4/12/2024 11:12:53 PM: Session Started ...... 4/12/2024 11:12:53 PM: {} 4/12/2024 11:12:53 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/12/2024 11:12:53 PM: Session Ended ...... 4/12/2024 11:12:53 PM: {} 4/12/2024 11:13:01 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 11:13:01 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 11:13:13 PM: Session Started ...... 4/12/2024 11:13:13 PM: {} 4/12/2024 11:13:13 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/12/2024 11:13:13 PM: **************************** User alkhaliqair.travels Login Request..... **************************** 4/12/2024 11:13:13 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME=alkhaliqair.travels 4/12/2024 11:13:13 PM: ************* Deleting Un-Used Tokens.. For User: alkhaliqair.travels ************* 4/12/2024 11:13:13 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME=alkhaliqair.travels 4/12/2024 11:13:13 PM: delete from SM_EMAIL_TOKENS_T where USERID=:USERID and nvl(TOKEN_USED,'N') = :TOKEN_USED params: USERID=447, TOKEN_USED=N 4/12/2024 11:13:13 PM: select nvl(to_char(PASSWORD_LAST_CHANGE_DATE,'mm/dd/yyyy'),'N'),nvl(PASS_CHANGE_WARNING,'N') from SM_USERS_T where upper(USERNAME) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:13:13 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 11:13:13 PM: select a.ORG_ID, a.ORG_DESC from TK_ORGANIZATION_SETUP_T a, SM_USER_ORG_MAPPING_T b where a.ORG_ID=b.ORG_ID AND upper(b.USERID) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:13:13 PM: select nvl(max(SERIAL_NO),0)+1 from SM_USER_LOGIN_HIST_T 4/12/2024 11:13:13 PM: select to_char(sysdate,'dd/mm/yyyy hh24:mi:ss') from dual 4/12/2024 11:13:13 PM: insert into SM_USER_LOGIN_HIST_T (SERIAL_NO,USERNAME,PASSWORD,IP_ADDRESS,OTHER_INFO,STATUS_TAG,STATUS_MESSAGE,CREATION_DATE) values (:SERIAL_NO,:USERNAME,:PASSWORD,:IP_ADDRESS,:OTHER_INFO,:STATUS_TAG,:STATUS_MESSAGE,:CREATION_DATE) params: SERIAL_NO=3106, USERNAME=alkhaliqair.travels, PASSWORD=IhnFMWuus+Ci/xcNyJFGD5DRMcu7qUEdNpCUF1YncO2TRL+iWkAzcyWI7279Pb6XZI/w07c9koD36a0leoWsT2hb057x8Sl+bCbzg8ddLQ3aQaG2KU20PX0wa4UmIIMi, IP_ADDRESS=119.155.121.111, OTHER_INFO=Chrome109-109.0-WinNT, STATUS_TAG=S, STATUS_MESSAGE=success, CREATION_DATE=4/13/2024 11:13:13 AM 4/12/2024 11:13:13 PM: update SM_USERS_T set LOGIN_ATTEMPTS=0 where upper(USERNAME) = upper(:USERNAME) params: USERNAME=alkhaliqair.travels 4/12/2024 11:13:13 PM: update SM_USERS_T set LAST_LOGIN=sysdate where upper(USERNAME) = upper(:USERNAME) params: USERNAME=alkhaliqair.travels 4/12/2024 11:13:13 PM: **************************** User alkhaliqair.travels Logged in Successfully.. **************************** 4/12/2024 11:13:13 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='MASTER_ADMIN_ID' 4/12/2024 11:13:13 PM: select RELEASE_VERSION from SM_RELEASE_INFO_T order by SERIAL_NO desc 4/12/2024 11:13:13 PM: select to_char(CREATION_DATE,'dd/mm/yyyy') CREATION_DATE from SM_USERS_T where upper(USERID)=upper(:USERID) params: USERID=447 4/12/2024 11:13:13 PM: select APPLICATION_ID from SM_APPLICATION_USER_MAPPING_T where USERID=:USERID order by APPLICATION_ID params: USERID=447 4/12/2024 11:13:13 PM: select ORG_ID from SM_USER_ORG_MAPPING_T b where upper(USERID) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:13:13 PM: select * from SM_USERS_T where USERID=:USERID params: USERID=447 4/12/2024 11:13:13 PM: Request.IsSecureConnection True 4/12/2024 11:13:13 PM: select a.ORG_ID, a.ORG_DESC from TK_ORGANIZATION_SETUP_T a, SM_USER_ORG_MAPPING_T b where a.ORG_ID=b.ORG_ID AND upper(b.USERID) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:13:14 PM: sid a1jmcu3iny1ksykz3bydrlel 4/12/2024 11:13:14 PM: sid 172fa4c2-b88a-4109-92c0-d07b95be43b0 4/12/2024 11:13:14 PM: sid ZealERP.ZealSecurity.Models.NewSecurity.User 4/12/2024 11:13:16 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME= 4/12/2024 11:13:16 PM: select * from SM_USERS_T where USERID=:USERID params: USERID=447 4/12/2024 11:13:16 PM: ************* Deleting Un-Used Tokens.. For User: ************* 4/12/2024 11:13:16 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME= 4/12/2024 11:13:16 PM: select nvl(to_char(PASSWORD_LAST_CHANGE_DATE,'mm/dd/yyyy'),'N'),nvl(PASS_CHANGE_WARNING,'N') from SM_USERS_T where upper(USERNAME) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:13:16 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 11:13:16 PM: select a.ORG_ID, a.ORG_DESC from TK_ORGANIZATION_SETUP_T a, SM_USER_ORG_MAPPING_T b where a.ORG_ID=b.ORG_ID AND upper(b.USERID) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:13:16 PM: select a.ORG_ID, a.ORG_DESC from TK_ORGANIZATION_SETUP_T a, SM_USER_ORG_MAPPING_T b where a.ORG_ID=b.ORG_ID AND upper(b.USERID) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:13:16 PM: select nvl(e.FIRSTNAME,'') AS FIRST_NAME_NEW,nvl(e.MIDDLENAME,'') AS MIDDLE_NAME_NEW,nvl(e.LASTNAME,'') AS LAST_NAME_NEW from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='alkhaliqair.travels' and e.ORG_ID='6' 4/12/2024 11:13:16 PM: select nvl(e.FIRSTNAME,'') AS FIRST_NAME_NEW,nvl(e.MIDDLENAME,'') AS MIDDLE_NAME_NEW,nvl(e.LASTNAME,'') AS LAST_NAME_NEW from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='alkhaliqair.travels' and e.ORG_ID='6' 4/12/2024 11:13:16 PM: select e.EMPLOYEENUMBER from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='alkhaliqair.travels' and e.ORG_ID='6' 4/12/2024 11:13:16 PM: select e.EMPLOYEENUMBER from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='alkhaliqair.travels' and e.ORG_ID='6' 4/12/2024 11:13:16 PM: select to_char(sysdate,'dd/mm/yyyy hh24:mi:ss') from dual 4/12/2024 11:13:16 PM: select e.*,e.EMPLOYEEID from employee e,sm_users_t u where u.email=e.OFFICIALEMAIL and e.org_id='6' and u.USERNAME='alkhaliqair.travels' 4/12/2024 11:13:17 PM: select APPLICATION_ID from SM_APPLICATION_USER_MAPPING_T where USERID= :USERID order by APPLICATION_ID params: USERID=447 4/12/2024 11:13:17 PM: select a.ORG_ID,a.ORG_DESC, b.BRANCH_ID, b.BRANCH_DESC from TK_ORGANIZATION_SETUP_T a, TK_BRANCH_SETUP_T b, SM_USER_BRANCH_MAPPING_T c where a.ORG_ID = b.ORG_ID and b.ORG_ID = c.ORG_ID and b.BRANCH_ID = c.BRANCH_ID and upper(USERID) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:13:17 PM: select DEFAULT_MENU, MENU_URL from SM_APPLICATION_MENU_T where APPLICATION_ID=:APPLICATION_ID and DEFAULT_MENU ='Y' and MENU_ID in ( select a.MENU_ID from SM_APPLICATION_MENU_T a left outer join SM_APP_USER_MENU_EXCEPTIONS_T b on ( a.APPLICATION_ID = b.APPLICATION_ID and b.USERID=:USERID and a.MENU_ID = b.MENU_ID), SM_APP_MENU_ROLE_MAPPING_T c where a.APPLICATION_ID=:APPLICATION_ID2 and a.APPLICATION_ID = c.APPLICATION_ID and a.MENU_ID = c.MENU_ID and ((c.ROLE_ID in (select ROLE_ID from SM_USER_ROLE_MAPPING_T where USERID=:USERID2 and ROLE_START_DATE <= sysdate and ((ROLE_END_DATE > sysdate) or (ROLE_END_DATE is null)))) ) and c.ROLE_ID not in (select ROLE_ID from SM_ROLE_SETUP_T where APPLICATION_ID=:APPLICATION_ID3 and ROLE_END_DATE < sysdate) and nvl(b.EXCEPTION_TYPE,'Include')='Include' and a.ACTIVE='1' ) params: APPLICATION_ID=23, USERID=447, APPLICATION_ID2=23, USERID2=447, APPLICATION_ID3=23 4/12/2024 11:13:17 PM: select APPLICATION_DESC,BRANCH_REQUIRED from SM_APPLICATION_SETUPHD_T where APPLICATION_ID=:APPLICATION_ID params: APPLICATION_ID=23 4/12/2024 11:13:17 PM: select a.ORG_ID, a.ORG_DESC from TK_ORGANIZATION_SETUP_T a, SM_USER_ORG_MAPPING_T b where a.ORG_ID=b.ORG_ID AND upper(b.USERID) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:13:17 PM: select a.APPLICATION_ID, a.MENU_ID, a.MENU_DESC, a.MENU_URL, a.MENU_CONTROLLER_NAME, a.MENU_ACTION_NAME , a.MENU_ICON, a.MENU_TYPE, a.PARENT_MENU_ID, a.DISPLAY_ORDER ,nvl(CONTROL_VIEW,'N') CONTROL_VIEW ,nvl(CONTROL_ADD,'N') CONTROL_ADD ,nvl(CONTROL_UPDATE,'N') CONTROL_UPDATE ,nvl(CONTROL_DELETE,'N') CONTROL_DELETE ,nvl(CONTROL_VERIFY,'N') CONTROL_VERIFY ,nvl(CONTROL_APPROVE,'N') CONTROL_APPROVE from SM_APPLICATION_MENU_T a left outer join SM_APP_USER_MENU_EXCEPTIONS_T b on ( a.APPLICATION_ID = b.APPLICATION_ID and b.USERID=:USERID and a.MENU_ID = b.MENU_ID), SM_APP_MENU_ROLE_MAPPING_T c where a.APPLICATION_ID=:APPLICATION_ID and a.APPLICATION_ID = c.APPLICATION_ID and a.MENU_ID = c.MENU_ID and ((c.ROLE_ID in (select ROLE_ID from SM_USER_ROLE_MAPPING_T where USERID=:USERID2 and ROLE_START_DATE <= sysdate and ((ROLE_END_DATE > sysdate) or (ROLE_END_DATE is null)))) ) and c.ROLE_ID not in (select ROLE_ID from SM_ROLE_SETUP_T where APPLICATION_ID=:APPLICATION_ID2 and ROLE_END_DATE < sysdate) and nvl(b.EXCEPTION_TYPE,'Include')='Include' and a.ACTIVE='1' order by DISPLAY_ORDER params: USERID=447, APPLICATION_ID=23, USERID2=447, APPLICATION_ID2=23 4/12/2024 11:13:17 PM: select RESTRICTION_ID,RESTRICTION_VALUE from SM_RESTRICTIONS_ROLE_MAPPING_T a where a.APPLICATION_ID=:APPLICATION_ID and ((ROLE_ID in (select ROLE_ID from SM_USER_ROLE_MAPPING_T where USERID=:USERID and ROLE_START_DATE <= sysdate and ((ROLE_END_DATE > sysdate) or (ROLE_END_DATE is null)))) ) and ROLE_ID not in (select ROLE_ID from SM_ROLE_SETUP_T where APPLICATION_ID=:APPLICATION_ID2 and ROLE_END_DATE < sysdate) order by RESTRICTION_ID params: APPLICATION_ID=23, USERID=447, APPLICATION_ID2=23 4/12/2024 11:13:17 PM: select a.APPLICATION_ID, a.MENU_ID, a.ROLE_ID, a.TAB_ID, TAB_DESC, TAB_HTML_ID ,nvl(CONTROL_VIEW,'N') CONTROL_VIEW ,nvl(CONTROL_ADD,'N') CONTROL_ADD ,nvl(CONTROL_UPDATE,'N') CONTROL_UPDATE ,nvl(CONTROL_DELETE,'N') CONTROL_DELETE ,nvl(CONTROL_VERIFY,'N') CONTROL_VERIFY ,nvl(CONTROL_APPROVE,'N') CONTROL_APPROVE from SM_APP_MENU_ROLE_TABS_T a, SM_APPLICATION_MENU_TABS_T b where a.APPLICATION_ID = b.APPLICATION_ID and a.MENU_ID = b.MENU_ID and a.TAB_ID = b.TAB_ID and a.APPLICATION_ID=:APPLICATION_ID and ((ROLE_ID in (select ROLE_ID from SM_USER_ROLE_MAPPING_T where USERID=:USERID and ROLE_START_DATE <= sysdate and ((ROLE_END_DATE > sysdate) or (ROLE_END_DATE is null)))) ) and ROLE_ID not in (select ROLE_ID from SM_ROLE_SETUP_T where APPLICATION_ID=:APPLICATION_ID2 and ROLE_END_DATE < sysdate) order by TAB_ID params: APPLICATION_ID=23, USERID=447, APPLICATION_ID2=23 4/12/2024 11:13:17 PM: select a.ORG_ID,a.ORG_DESC, b.BRANCH_ID, b.BRANCH_DESC from TK_ORGANIZATION_SETUP_T a, TK_BRANCH_SETUP_T b, SM_USER_BRANCH_MAPPING_T c where a.ORG_ID = b.ORG_ID and b.ORG_ID = c.ORG_ID and b.BRANCH_ID = c.BRANCH_ID and upper(USERID) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:13:17 PM: select BRANCH_DESC from TK_BRANCH_SETUP_T where ORG_ID = :ORG_ID and BRANCH_ID = :BRANCH_ID params: ORG_ID=, BRANCH_ID=6 4/12/2024 11:13:17 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='GENERAL_PARAMETER_APP_ID' 4/12/2024 11:13:17 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='AGENCY_MANAGEMENT_APP_ID' 4/12/2024 11:13:17 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='ZEAL_FINANCIAL_APP_ID' 4/12/2024 11:13:17 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='GLAS_APP_ID' 4/12/2024 11:13:17 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='ILAS_APP_ID' 4/12/2024 11:13:17 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='GHAS_APP_ID' 4/12/2024 11:13:17 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='IHAS_APP_ID' 4/12/2024 11:13:17 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='NEW_ADVICE_ENTRY' 4/12/2024 11:13:24 PM: select * from SM_APPLICATION_SETUPHD_T where ACTIVE='1' order by APPLICATION_ID 4/12/2024 11:13:24 PM: select * from SM_APPLICATION_USER_MAPPING_T order by APPLICATION_ID,USERID 4/12/2024 11:13:24 PM: select a.ORG_ID from SM_USER_ORG_MAPPING_T a where upper(a.USERID) = :USERID params: USERID=ALKHALIQAIR.TRAVELS 4/12/2024 11:13:24 PM: select a.BRANCH_ID, a.BRANCH_DESC from TK_BRANCH_SETUP_T a, SM_USER_BRANCH_MAPPING_T b where a.BRANCH_ID = b.BRANCH_ID and upper(USERID) = upper(:USERID) and b.ORG_ID=:ORG_ID and a.ORG_ID=b.ORG_ID order by a.BRANCH_DESC params: USERID=ALKHALIQAIR.TRAVELS, ORG_ID=6 4/12/2024 11:13:25 PM: select distinct a.CHANNEL_ID, a.CHANNEL_NAME from AM_DISTRIBUTION_CHANNEL_T a, AM_AGENT_CHANNEL_MODEL_T b where a.ORG_ID=b.ORG_ID and a.CHANNEL_ID = b.CHANNEL_ID and a.ORG_ID=:ORG_ID and b.AGENT_ID in (select AGENT_ID from AM_AGENT_T where username=:AGENT_ID) params: ORG_ID=6, AGENT_ID=alkhaliqair.travels 4/12/2024 11:13:25 PM: select distinct b.PARTNER_ID,b.PARTNER_NAME from AM_AGENT_PARTNER_T a left join AM_PARTNER_T b on a.ORG_ID=b.ORG_ID AND a.PARTNER_ID=b.PARTNER_ID WHERE a.ORG_ID=:ORG_ID and a.AGENT_ID in (select AGENT_ID from AM_AGENT_T where username=:AGENT_ID) params: ORG_ID=6, AGENT_ID=alkhaliqair.travels 4/12/2024 11:13:50 PM: select DEFAULT_MENU, MENU_URL from SM_APPLICATION_MENU_T where APPLICATION_ID=:APPLICATION_ID and DEFAULT_MENU ='Y' and MENU_ID in ( select a.MENU_ID from SM_APPLICATION_MENU_T a left outer join SM_APP_USER_MENU_EXCEPTIONS_T b on ( a.APPLICATION_ID = b.APPLICATION_ID and b.USERID=:USERID and a.MENU_ID = b.MENU_ID), SM_APP_MENU_ROLE_MAPPING_T c where a.APPLICATION_ID=:APPLICATION_ID2 and a.APPLICATION_ID = c.APPLICATION_ID and a.MENU_ID = c.MENU_ID and ((c.ROLE_ID in (select ROLE_ID from SM_USER_ROLE_MAPPING_T where USERID=:USERID2 and ROLE_START_DATE <= sysdate and ((ROLE_END_DATE > sysdate) or (ROLE_END_DATE is null)))) ) and c.ROLE_ID not in (select ROLE_ID from SM_ROLE_SETUP_T where APPLICATION_ID=:APPLICATION_ID3 and ROLE_END_DATE < sysdate) and nvl(b.EXCEPTION_TYPE,'Include')='Include' and a.ACTIVE='1' ) params: APPLICATION_ID=23, USERID=447, APPLICATION_ID2=23, USERID2=447, APPLICATION_ID3=23 4/12/2024 11:13:50 PM: select APPLICATION_DESC,BRANCH_REQUIRED from SM_APPLICATION_SETUPHD_T where APPLICATION_ID=:APPLICATION_ID params: APPLICATION_ID=23 4/12/2024 11:13:50 PM: select a.ORG_ID,a.ORG_DESC, b.BRANCH_ID, b.BRANCH_DESC from TK_ORGANIZATION_SETUP_T a, TK_BRANCH_SETUP_T b, SM_USER_BRANCH_MAPPING_T c where a.ORG_ID = b.ORG_ID and b.ORG_ID = c.ORG_ID and b.BRANCH_ID = c.BRANCH_ID and upper(USERID) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:13:50 PM: select a.ORG_ID,a.ORG_DESC, b.BRANCH_ID, b.BRANCH_DESC from TK_ORGANIZATION_SETUP_T a, TK_BRANCH_SETUP_T b, SM_USER_BRANCH_MAPPING_T c where a.ORG_ID = b.ORG_ID and b.ORG_ID = c.ORG_ID and b.BRANCH_ID = c.BRANCH_ID and upper(USERID) = upper(:USERID) and b.BRANCH_ID=:BRANCH_ID params: USERID=alkhaliqair.travels, BRANCH_ID=1 4/12/2024 11:13:50 PM: select CHANNEL_NAME from AM_DISTRIBUTION_CHANNEL_T where ORG_ID = :ORG_ID and CHANNEL_ID = :CHANNEL_ID params: ORG_ID=6, CHANNEL_ID= 4/12/2024 11:13:50 PM: select MODEL_NAME from AM_CHANNEL_MODEL_T where ORG_ID = :ORG_ID and CHANNEL_ID = :CHANNEL_ID and MODEL_ID = :MODEL_ID params: ORG_ID=6, CHANNEL_ID=, MODEL_ID= 4/12/2024 11:13:50 PM: select AGENT_ID,AGENT_NAME from AM_AGENT_T where ORG_ID = :ORG_ID and USERNAME = :USERNAME params: ORG_ID=6, USERNAME=alkhaliqair.travels 4/12/2024 11:13:50 PM: select a.ORG_ID, a.ORG_DESC from TK_ORGANIZATION_SETUP_T a, SM_USER_ORG_MAPPING_T b where a.ORG_ID=b.ORG_ID AND upper(b.USERID) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:13:50 PM: Select DEFAULT_CURRENCY,DEFAULT_COUNTRY From TK_BRANCH_SETUP_T where BRANCH_ID=:BRANCH_ID params: BRANCH_ID=1 4/12/2024 11:13:50 PM: select to_char(UNDWT_FREEZE_DATE,'dd-mon-yyyy') FROM TK_PERIOD_SETUP_T where UNDWT_FREEZE_TAG='Y' And ORG_ID = :ORG_ID ANd BRANCH_ID = :BRANCH_ID and APPLICATION_ID= :APPLICATION_ID params: ORG_ID=6, BRANCH_ID=1, APPLICATION_ID=23 4/12/2024 11:13:50 PM: select a.ORG_ID,a.ORG_DESC, b.BRANCH_ID, b.BRANCH_DESC from TK_ORGANIZATION_SETUP_T a, TK_BRANCH_SETUP_T b, SM_USER_BRANCH_MAPPING_T c where a.ORG_ID = b.ORG_ID and b.ORG_ID = c.ORG_ID and b.BRANCH_ID = c.BRANCH_ID and upper(USERID) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:13:51 PM: select (select count(*) from LM_NOTIFICATIONS_T where ((FROM_EMPLOYEEID=e.EMPLOYEEID AND NOTF_TYPEID='INF') or (TO_EMPLOYEEID=e.EMPLOYEEID and NOTF_TYPEID='ACT')) and STATUS='OP') as NOTIFICATIONS, e.*,e.EMPLOYEEID from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='alkhaliqair.travels' and e.org_id='6' 4/12/2024 11:13:51 PM: select (select count(*) from LM_NOTIFICATIONS_T where ((FROM_EMPLOYEEID=e.EMPLOYEEID AND NOTF_TYPEID='INF') or (TO_EMPLOYEEID=e.EMPLOYEEID and NOTF_TYPEID='ACT')) and STATUS='OP') as NOTIFICATIONS, e.*,e.EMPLOYEEID from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='alkhaliqair.travels' and e.org_id='6' 4/12/2024 11:13:51 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='SECURITY_MODULE_APP_ID' 4/12/2024 11:13:51 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='HCM_APP_ID' 4/12/2024 11:13:51 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='ISSUE_DATE_EDITABLE' 4/12/2024 11:13:51 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='PROV_RECEIPT_VOUCHER_TYPE' 4/12/2024 11:13:51 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='KNOCKOFF_VOUCHER_ON_CURRENT_DATE' 4/12/2024 11:13:51 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='GLAS_BULK_POSTING' 4/12/2024 11:13:51 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='SHOW_WITHOUT_ACCOUNTING' 4/12/2024 11:13:51 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='NEW_VOUCHER_ENTRY' 4/12/2024 11:13:51 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='SUITE_ANALYSIS' 4/12/2024 11:13:51 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='NEED_ANALYSIS' 4/12/2024 11:13:51 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='OCC_ON_ILLUSTRATION' 4/12/2024 11:13:51 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='CBC_ON_PROPOSAL' 4/12/2024 11:13:53 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 11:13:53 PM: select Logo_image from TK_ORGANIZATION_SETUP_T where org_id='6' 4/12/2024 11:14:31 PM: select (select count(*) from LM_NOTIFICATIONS_T where ((FROM_EMPLOYEEID=e.EMPLOYEEID AND NOTF_TYPEID='INF') or (TO_EMPLOYEEID=e.EMPLOYEEID and NOTF_TYPEID='ACT')) and STATUS='OP') as NOTIFICATIONS, e.*,e.EMPLOYEEID from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='alkhaliqair.travels' and e.org_id='6' 4/12/2024 11:14:31 PM: select (select count(*) from LM_NOTIFICATIONS_T where ((FROM_EMPLOYEEID=e.EMPLOYEEID AND NOTF_TYPEID='INF') or (TO_EMPLOYEEID=e.EMPLOYEEID and NOTF_TYPEID='ACT')) and STATUS='OP') as NOTIFICATIONS, e.*,e.EMPLOYEEID from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='alkhaliqair.travels' and e.org_id='6' 4/12/2024 11:14:32 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 11:14:32 PM: select Logo_image from TK_ORGANIZATION_SETUP_T where org_id='6' 4/12/2024 11:14:39 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/12/2024 11:14:39 PM: Session Ended ...... 4/12/2024 11:14:39 PM: {} 4/12/2024 11:14:50 PM: Session Started ...... 4/12/2024 11:14:50 PM: {} 4/12/2024 11:14:50 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/12/2024 11:14:50 PM: Session Ended ...... 4/12/2024 11:14:50 PM: {} 4/12/2024 11:14:51 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 11:14:51 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 11:14:56 PM: Session Started ...... 4/12/2024 11:14:56 PM: {} 4/12/2024 11:14:56 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/12/2024 11:14:56 PM: **************************** User alkhaliqair.travels Login Request..... **************************** 4/12/2024 11:14:56 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME=alkhaliqair.travels 4/12/2024 11:14:56 PM: ************* Deleting Un-Used Tokens.. For User: alkhaliqair.travels ************* 4/12/2024 11:14:56 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME=alkhaliqair.travels 4/12/2024 11:14:56 PM: delete from SM_EMAIL_TOKENS_T where USERID=:USERID and nvl(TOKEN_USED,'N') = :TOKEN_USED params: USERID=447, TOKEN_USED=N 4/12/2024 11:14:56 PM: select nvl(to_char(PASSWORD_LAST_CHANGE_DATE,'mm/dd/yyyy'),'N'),nvl(PASS_CHANGE_WARNING,'N') from SM_USERS_T where upper(USERNAME) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:14:56 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 11:14:56 PM: select a.ORG_ID, a.ORG_DESC from TK_ORGANIZATION_SETUP_T a, SM_USER_ORG_MAPPING_T b where a.ORG_ID=b.ORG_ID AND upper(b.USERID) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:14:56 PM: select nvl(max(SERIAL_NO),0)+1 from SM_USER_LOGIN_HIST_T 4/12/2024 11:14:56 PM: select to_char(sysdate,'dd/mm/yyyy hh24:mi:ss') from dual 4/12/2024 11:14:56 PM: insert into SM_USER_LOGIN_HIST_T (SERIAL_NO,USERNAME,PASSWORD,IP_ADDRESS,OTHER_INFO,STATUS_TAG,STATUS_MESSAGE,CREATION_DATE) values (:SERIAL_NO,:USERNAME,:PASSWORD,:IP_ADDRESS,:OTHER_INFO,:STATUS_TAG,:STATUS_MESSAGE,:CREATION_DATE) params: SERIAL_NO=3107, USERNAME=alkhaliqair.travels, PASSWORD=iK2GQ8VhMrJ7PfdOc2f/p482L3bmYg9TC24u0WMUsEVwCwb/yFeV5FHh6j3E7Qn0CUsw8yIVodoCCchAOly15g3Qw+XFHKjRkRnimNtLO2zaz2wpgXvPOkrxnE72Bciv, IP_ADDRESS=119.155.121.111, OTHER_INFO=Chrome109-109.0-WinNT, STATUS_TAG=S, STATUS_MESSAGE=success, CREATION_DATE=4/13/2024 11:14:56 AM 4/12/2024 11:14:56 PM: update SM_USERS_T set LOGIN_ATTEMPTS=0 where upper(USERNAME) = upper(:USERNAME) params: USERNAME=alkhaliqair.travels 4/12/2024 11:14:56 PM: update SM_USERS_T set LAST_LOGIN=sysdate where upper(USERNAME) = upper(:USERNAME) params: USERNAME=alkhaliqair.travels 4/12/2024 11:14:56 PM: **************************** User alkhaliqair.travels Logged in Successfully.. **************************** 4/12/2024 11:14:56 PM: select RELEASE_VERSION from SM_RELEASE_INFO_T order by SERIAL_NO desc 4/12/2024 11:14:56 PM: select to_char(CREATION_DATE,'dd/mm/yyyy') CREATION_DATE from SM_USERS_T where upper(USERID)=upper(:USERID) params: USERID=447 4/12/2024 11:14:56 PM: select APPLICATION_ID from SM_APPLICATION_USER_MAPPING_T where USERID=:USERID order by APPLICATION_ID params: USERID=447 4/12/2024 11:14:56 PM: select ORG_ID from SM_USER_ORG_MAPPING_T b where upper(USERID) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:14:56 PM: select * from SM_USERS_T where USERID=:USERID params: USERID=447 4/12/2024 11:14:56 PM: Request.IsSecureConnection True 4/12/2024 11:14:56 PM: select a.ORG_ID, a.ORG_DESC from TK_ORGANIZATION_SETUP_T a, SM_USER_ORG_MAPPING_T b where a.ORG_ID=b.ORG_ID AND upper(b.USERID) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:14:57 PM: sid uy2qodgujzwezxyv5y5315o5 4/12/2024 11:14:57 PM: sid 8a681c15-eb3b-462f-b559-2a79b9ffd8ea 4/12/2024 11:14:57 PM: sid ZealERP.ZealSecurity.Models.NewSecurity.User 4/12/2024 11:14:57 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME= 4/12/2024 11:14:57 PM: select * from SM_USERS_T where USERID=:USERID params: USERID=447 4/12/2024 11:14:58 PM: ************* Deleting Un-Used Tokens.. For User: ************* 4/12/2024 11:14:58 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME= 4/12/2024 11:14:58 PM: select nvl(to_char(PASSWORD_LAST_CHANGE_DATE,'mm/dd/yyyy'),'N'),nvl(PASS_CHANGE_WARNING,'N') from SM_USERS_T where upper(USERNAME) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:14:58 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 11:14:58 PM: select a.ORG_ID, a.ORG_DESC from TK_ORGANIZATION_SETUP_T a, SM_USER_ORG_MAPPING_T b where a.ORG_ID=b.ORG_ID AND upper(b.USERID) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:14:59 PM: select a.ORG_ID, a.ORG_DESC from TK_ORGANIZATION_SETUP_T a, SM_USER_ORG_MAPPING_T b where a.ORG_ID=b.ORG_ID AND upper(b.USERID) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:14:59 PM: select nvl(e.FIRSTNAME,'') AS FIRST_NAME_NEW,nvl(e.MIDDLENAME,'') AS MIDDLE_NAME_NEW,nvl(e.LASTNAME,'') AS LAST_NAME_NEW from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='alkhaliqair.travels' and e.ORG_ID='6' 4/12/2024 11:14:59 PM: select nvl(e.FIRSTNAME,'') AS FIRST_NAME_NEW,nvl(e.MIDDLENAME,'') AS MIDDLE_NAME_NEW,nvl(e.LASTNAME,'') AS LAST_NAME_NEW from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='alkhaliqair.travels' and e.ORG_ID='6' 4/12/2024 11:14:59 PM: select e.EMPLOYEENUMBER from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='alkhaliqair.travels' and e.ORG_ID='6' 4/12/2024 11:14:59 PM: select e.EMPLOYEENUMBER from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='alkhaliqair.travels' and e.ORG_ID='6' 4/12/2024 11:14:59 PM: select to_char(sysdate,'dd/mm/yyyy hh24:mi:ss') from dual 4/12/2024 11:14:59 PM: select e.*,e.EMPLOYEEID from employee e,sm_users_t u where u.email=e.OFFICIALEMAIL and e.org_id='6' and u.USERNAME='alkhaliqair.travels' 4/12/2024 11:14:59 PM: select APPLICATION_ID from SM_APPLICATION_USER_MAPPING_T where USERID= :USERID order by APPLICATION_ID params: USERID=447 4/12/2024 11:14:59 PM: select a.ORG_ID,a.ORG_DESC, b.BRANCH_ID, b.BRANCH_DESC from TK_ORGANIZATION_SETUP_T a, TK_BRANCH_SETUP_T b, SM_USER_BRANCH_MAPPING_T c where a.ORG_ID = b.ORG_ID and b.ORG_ID = c.ORG_ID and b.BRANCH_ID = c.BRANCH_ID and upper(USERID) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:14:59 PM: select DEFAULT_MENU, MENU_URL from SM_APPLICATION_MENU_T where APPLICATION_ID=:APPLICATION_ID and DEFAULT_MENU ='Y' and MENU_ID in ( select a.MENU_ID from SM_APPLICATION_MENU_T a left outer join SM_APP_USER_MENU_EXCEPTIONS_T b on ( a.APPLICATION_ID = b.APPLICATION_ID and b.USERID=:USERID and a.MENU_ID = b.MENU_ID), SM_APP_MENU_ROLE_MAPPING_T c where a.APPLICATION_ID=:APPLICATION_ID2 and a.APPLICATION_ID = c.APPLICATION_ID and a.MENU_ID = c.MENU_ID and ((c.ROLE_ID in (select ROLE_ID from SM_USER_ROLE_MAPPING_T where USERID=:USERID2 and ROLE_START_DATE <= sysdate and ((ROLE_END_DATE > sysdate) or (ROLE_END_DATE is null)))) ) and c.ROLE_ID not in (select ROLE_ID from SM_ROLE_SETUP_T where APPLICATION_ID=:APPLICATION_ID3 and ROLE_END_DATE < sysdate) and nvl(b.EXCEPTION_TYPE,'Include')='Include' and a.ACTIVE='1' ) params: APPLICATION_ID=23, USERID=447, APPLICATION_ID2=23, USERID2=447, APPLICATION_ID3=23 4/12/2024 11:14:59 PM: select APPLICATION_DESC,BRANCH_REQUIRED from SM_APPLICATION_SETUPHD_T where APPLICATION_ID=:APPLICATION_ID params: APPLICATION_ID=23 4/12/2024 11:14:59 PM: select a.ORG_ID, a.ORG_DESC from TK_ORGANIZATION_SETUP_T a, SM_USER_ORG_MAPPING_T b where a.ORG_ID=b.ORG_ID AND upper(b.USERID) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:14:59 PM: select a.APPLICATION_ID, a.MENU_ID, a.MENU_DESC, a.MENU_URL, a.MENU_CONTROLLER_NAME, a.MENU_ACTION_NAME , a.MENU_ICON, a.MENU_TYPE, a.PARENT_MENU_ID, a.DISPLAY_ORDER ,nvl(CONTROL_VIEW,'N') CONTROL_VIEW ,nvl(CONTROL_ADD,'N') CONTROL_ADD ,nvl(CONTROL_UPDATE,'N') CONTROL_UPDATE ,nvl(CONTROL_DELETE,'N') CONTROL_DELETE ,nvl(CONTROL_VERIFY,'N') CONTROL_VERIFY ,nvl(CONTROL_APPROVE,'N') CONTROL_APPROVE from SM_APPLICATION_MENU_T a left outer join SM_APP_USER_MENU_EXCEPTIONS_T b on ( a.APPLICATION_ID = b.APPLICATION_ID and b.USERID=:USERID and a.MENU_ID = b.MENU_ID), SM_APP_MENU_ROLE_MAPPING_T c where a.APPLICATION_ID=:APPLICATION_ID and a.APPLICATION_ID = c.APPLICATION_ID and a.MENU_ID = c.MENU_ID and ((c.ROLE_ID in (select ROLE_ID from SM_USER_ROLE_MAPPING_T where USERID=:USERID2 and ROLE_START_DATE <= sysdate and ((ROLE_END_DATE > sysdate) or (ROLE_END_DATE is null)))) ) and c.ROLE_ID not in (select ROLE_ID from SM_ROLE_SETUP_T where APPLICATION_ID=:APPLICATION_ID2 and ROLE_END_DATE < sysdate) and nvl(b.EXCEPTION_TYPE,'Include')='Include' and a.ACTIVE='1' order by DISPLAY_ORDER params: USERID=447, APPLICATION_ID=23, USERID2=447, APPLICATION_ID2=23 4/12/2024 11:14:59 PM: select RESTRICTION_ID,RESTRICTION_VALUE from SM_RESTRICTIONS_ROLE_MAPPING_T a where a.APPLICATION_ID=:APPLICATION_ID and ((ROLE_ID in (select ROLE_ID from SM_USER_ROLE_MAPPING_T where USERID=:USERID and ROLE_START_DATE <= sysdate and ((ROLE_END_DATE > sysdate) or (ROLE_END_DATE is null)))) ) and ROLE_ID not in (select ROLE_ID from SM_ROLE_SETUP_T where APPLICATION_ID=:APPLICATION_ID2 and ROLE_END_DATE < sysdate) order by RESTRICTION_ID params: APPLICATION_ID=23, USERID=447, APPLICATION_ID2=23 4/12/2024 11:14:59 PM: select a.APPLICATION_ID, a.MENU_ID, a.ROLE_ID, a.TAB_ID, TAB_DESC, TAB_HTML_ID ,nvl(CONTROL_VIEW,'N') CONTROL_VIEW ,nvl(CONTROL_ADD,'N') CONTROL_ADD ,nvl(CONTROL_UPDATE,'N') CONTROL_UPDATE ,nvl(CONTROL_DELETE,'N') CONTROL_DELETE ,nvl(CONTROL_VERIFY,'N') CONTROL_VERIFY ,nvl(CONTROL_APPROVE,'N') CONTROL_APPROVE from SM_APP_MENU_ROLE_TABS_T a, SM_APPLICATION_MENU_TABS_T b where a.APPLICATION_ID = b.APPLICATION_ID and a.MENU_ID = b.MENU_ID and a.TAB_ID = b.TAB_ID and a.APPLICATION_ID=:APPLICATION_ID and ((ROLE_ID in (select ROLE_ID from SM_USER_ROLE_MAPPING_T where USERID=:USERID and ROLE_START_DATE <= sysdate and ((ROLE_END_DATE > sysdate) or (ROLE_END_DATE is null)))) ) and ROLE_ID not in (select ROLE_ID from SM_ROLE_SETUP_T where APPLICATION_ID=:APPLICATION_ID2 and ROLE_END_DATE < sysdate) order by TAB_ID params: APPLICATION_ID=23, USERID=447, APPLICATION_ID2=23 4/12/2024 11:14:59 PM: select a.ORG_ID,a.ORG_DESC, b.BRANCH_ID, b.BRANCH_DESC from TK_ORGANIZATION_SETUP_T a, TK_BRANCH_SETUP_T b, SM_USER_BRANCH_MAPPING_T c where a.ORG_ID = b.ORG_ID and b.ORG_ID = c.ORG_ID and b.BRANCH_ID = c.BRANCH_ID and upper(USERID) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:14:59 PM: select BRANCH_DESC from TK_BRANCH_SETUP_T where ORG_ID = :ORG_ID and BRANCH_ID = :BRANCH_ID params: ORG_ID=, BRANCH_ID=6 4/12/2024 11:15:00 PM: select * from SM_APPLICATION_SETUPHD_T where ACTIVE='1' order by APPLICATION_ID 4/12/2024 11:15:00 PM: select * from SM_APPLICATION_USER_MAPPING_T order by APPLICATION_ID,USERID 4/12/2024 11:15:00 PM: select a.ORG_ID from SM_USER_ORG_MAPPING_T a where upper(a.USERID) = :USERID params: USERID=ALKHALIQAIR.TRAVELS 4/12/2024 11:15:00 PM: select a.BRANCH_ID, a.BRANCH_DESC from TK_BRANCH_SETUP_T a, SM_USER_BRANCH_MAPPING_T b where a.BRANCH_ID = b.BRANCH_ID and upper(USERID) = upper(:USERID) and b.ORG_ID=:ORG_ID and a.ORG_ID=b.ORG_ID order by a.BRANCH_DESC params: USERID=ALKHALIQAIR.TRAVELS, ORG_ID=6 4/12/2024 11:15:01 PM: select distinct a.CHANNEL_ID, a.CHANNEL_NAME from AM_DISTRIBUTION_CHANNEL_T a, AM_AGENT_CHANNEL_MODEL_T b where a.ORG_ID=b.ORG_ID and a.CHANNEL_ID = b.CHANNEL_ID and a.ORG_ID=:ORG_ID and b.AGENT_ID in (select AGENT_ID from AM_AGENT_T where username=:AGENT_ID) params: ORG_ID=6, AGENT_ID=alkhaliqair.travels 4/12/2024 11:15:02 PM: select distinct b.PARTNER_ID,b.PARTNER_NAME from AM_AGENT_PARTNER_T a left join AM_PARTNER_T b on a.ORG_ID=b.ORG_ID AND a.PARTNER_ID=b.PARTNER_ID WHERE a.ORG_ID=:ORG_ID and a.AGENT_ID in (select AGENT_ID from AM_AGENT_T where username=:AGENT_ID) params: ORG_ID=6, AGENT_ID=alkhaliqair.travels 4/12/2024 11:15:05 PM: select * from SM_APPLICATION_SETUPHD_T where ACTIVE='1' order by APPLICATION_ID 4/12/2024 11:15:05 PM: select * from SM_APPLICATION_USER_MAPPING_T order by APPLICATION_ID,USERID 4/12/2024 11:15:05 PM: select a.ORG_ID from SM_USER_ORG_MAPPING_T a where upper(a.USERID) = :USERID params: USERID=ALKHALIQAIR.TRAVELS 4/12/2024 11:15:05 PM: select a.BRANCH_ID, a.BRANCH_DESC from TK_BRANCH_SETUP_T a, SM_USER_BRANCH_MAPPING_T b where a.BRANCH_ID = b.BRANCH_ID and upper(USERID) = upper(:USERID) and b.ORG_ID=:ORG_ID and a.ORG_ID=b.ORG_ID order by a.BRANCH_DESC params: USERID=ALKHALIQAIR.TRAVELS, ORG_ID=6 4/12/2024 11:15:06 PM: select distinct b.PARTNER_ID,b.PARTNER_NAME from AM_AGENT_PARTNER_T a left join AM_PARTNER_T b on a.ORG_ID=b.ORG_ID AND a.PARTNER_ID=b.PARTNER_ID WHERE a.ORG_ID=:ORG_ID and a.AGENT_ID in (select AGENT_ID from AM_AGENT_T where username=:AGENT_ID) params: ORG_ID=6, AGENT_ID=alkhaliqair.travels 4/12/2024 11:15:06 PM: select distinct a.CHANNEL_ID, a.CHANNEL_NAME from AM_DISTRIBUTION_CHANNEL_T a, AM_AGENT_CHANNEL_MODEL_T b where a.ORG_ID=b.ORG_ID and a.CHANNEL_ID = b.CHANNEL_ID and a.ORG_ID=:ORG_ID and b.AGENT_ID in (select AGENT_ID from AM_AGENT_T where username=:AGENT_ID) params: ORG_ID=6, AGENT_ID=alkhaliqair.travels 4/12/2024 11:15:15 PM: select DEFAULT_MENU, MENU_URL from SM_APPLICATION_MENU_T where APPLICATION_ID=:APPLICATION_ID and DEFAULT_MENU ='Y' and MENU_ID in ( select a.MENU_ID from SM_APPLICATION_MENU_T a left outer join SM_APP_USER_MENU_EXCEPTIONS_T b on ( a.APPLICATION_ID = b.APPLICATION_ID and b.USERID=:USERID and a.MENU_ID = b.MENU_ID), SM_APP_MENU_ROLE_MAPPING_T c where a.APPLICATION_ID=:APPLICATION_ID2 and a.APPLICATION_ID = c.APPLICATION_ID and a.MENU_ID = c.MENU_ID and ((c.ROLE_ID in (select ROLE_ID from SM_USER_ROLE_MAPPING_T where USERID=:USERID2 and ROLE_START_DATE <= sysdate and ((ROLE_END_DATE > sysdate) or (ROLE_END_DATE is null)))) ) and c.ROLE_ID not in (select ROLE_ID from SM_ROLE_SETUP_T where APPLICATION_ID=:APPLICATION_ID3 and ROLE_END_DATE < sysdate) and nvl(b.EXCEPTION_TYPE,'Include')='Include' and a.ACTIVE='1' ) params: APPLICATION_ID=23, USERID=447, APPLICATION_ID2=23, USERID2=447, APPLICATION_ID3=23 4/12/2024 11:15:15 PM: select APPLICATION_DESC,BRANCH_REQUIRED from SM_APPLICATION_SETUPHD_T where APPLICATION_ID=:APPLICATION_ID params: APPLICATION_ID=23 4/12/2024 11:15:15 PM: select a.ORG_ID,a.ORG_DESC, b.BRANCH_ID, b.BRANCH_DESC from TK_ORGANIZATION_SETUP_T a, TK_BRANCH_SETUP_T b, SM_USER_BRANCH_MAPPING_T c where a.ORG_ID = b.ORG_ID and b.ORG_ID = c.ORG_ID and b.BRANCH_ID = c.BRANCH_ID and upper(USERID) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:15:15 PM: select a.ORG_ID,a.ORG_DESC, b.BRANCH_ID, b.BRANCH_DESC from TK_ORGANIZATION_SETUP_T a, TK_BRANCH_SETUP_T b, SM_USER_BRANCH_MAPPING_T c where a.ORG_ID = b.ORG_ID and b.ORG_ID = c.ORG_ID and b.BRANCH_ID = c.BRANCH_ID and upper(USERID) = upper(:USERID) and b.BRANCH_ID=:BRANCH_ID params: USERID=alkhaliqair.travels, BRANCH_ID=1 4/12/2024 11:15:15 PM: select CHANNEL_NAME from AM_DISTRIBUTION_CHANNEL_T where ORG_ID = :ORG_ID and CHANNEL_ID = :CHANNEL_ID params: ORG_ID=6, CHANNEL_ID= 4/12/2024 11:15:15 PM: select MODEL_NAME from AM_CHANNEL_MODEL_T where ORG_ID = :ORG_ID and CHANNEL_ID = :CHANNEL_ID and MODEL_ID = :MODEL_ID params: ORG_ID=6, CHANNEL_ID=, MODEL_ID= 4/12/2024 11:15:15 PM: select AGENT_ID,AGENT_NAME from AM_AGENT_T where ORG_ID = :ORG_ID and USERNAME = :USERNAME params: ORG_ID=6, USERNAME=alkhaliqair.travels 4/12/2024 11:15:15 PM: select a.ORG_ID, a.ORG_DESC from TK_ORGANIZATION_SETUP_T a, SM_USER_ORG_MAPPING_T b where a.ORG_ID=b.ORG_ID AND upper(b.USERID) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:15:15 PM: Select DEFAULT_CURRENCY,DEFAULT_COUNTRY From TK_BRANCH_SETUP_T where BRANCH_ID=:BRANCH_ID params: BRANCH_ID=1 4/12/2024 11:15:15 PM: select to_char(UNDWT_FREEZE_DATE,'dd-mon-yyyy') FROM TK_PERIOD_SETUP_T where UNDWT_FREEZE_TAG='Y' And ORG_ID = :ORG_ID ANd BRANCH_ID = :BRANCH_ID and APPLICATION_ID= :APPLICATION_ID params: ORG_ID=6, BRANCH_ID=1, APPLICATION_ID=23 4/12/2024 11:15:15 PM: select a.ORG_ID,a.ORG_DESC, b.BRANCH_ID, b.BRANCH_DESC from TK_ORGANIZATION_SETUP_T a, TK_BRANCH_SETUP_T b, SM_USER_BRANCH_MAPPING_T c where a.ORG_ID = b.ORG_ID and b.ORG_ID = c.ORG_ID and b.BRANCH_ID = c.BRANCH_ID and upper(USERID) = upper(:USERID) params: USERID=alkhaliqair.travels 4/12/2024 11:15:15 PM: select (select count(*) from LM_NOTIFICATIONS_T where ((FROM_EMPLOYEEID=e.EMPLOYEEID AND NOTF_TYPEID='INF') or (TO_EMPLOYEEID=e.EMPLOYEEID and NOTF_TYPEID='ACT')) and STATUS='OP') as NOTIFICATIONS, e.*,e.EMPLOYEEID from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='alkhaliqair.travels' and e.org_id='6' 4/12/2024 11:15:15 PM: select (select count(*) from LM_NOTIFICATIONS_T where ((FROM_EMPLOYEEID=e.EMPLOYEEID AND NOTF_TYPEID='INF') or (TO_EMPLOYEEID=e.EMPLOYEEID and NOTF_TYPEID='ACT')) and STATUS='OP') as NOTIFICATIONS, e.*,e.EMPLOYEEID from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='alkhaliqair.travels' and e.org_id='6' 4/12/2024 11:15:16 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 11:15:16 PM: select Logo_image from TK_ORGANIZATION_SETUP_T where org_id='6' 4/12/2024 11:15:21 PM: select (select count(*) from LM_NOTIFICATIONS_T where ((FROM_EMPLOYEEID=e.EMPLOYEEID AND NOTF_TYPEID='INF') or (TO_EMPLOYEEID=e.EMPLOYEEID and NOTF_TYPEID='ACT')) and STATUS='OP') as NOTIFICATIONS, e.*,e.EMPLOYEEID from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='alkhaliqair.travels' and e.org_id='6' 4/12/2024 11:15:21 PM: select (select count(*) from LM_NOTIFICATIONS_T where ((FROM_EMPLOYEEID=e.EMPLOYEEID AND NOTF_TYPEID='INF') or (TO_EMPLOYEEID=e.EMPLOYEEID and NOTF_TYPEID='ACT')) and STATUS='OP') as NOTIFICATIONS, e.*,e.EMPLOYEEID from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='alkhaliqair.travels' and e.org_id='6' 4/12/2024 11:15:21 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 11:15:21 PM: select Logo_image from TK_ORGANIZATION_SETUP_T where org_id='6' 4/12/2024 11:15:34 PM: select (select count(*) from LM_NOTIFICATIONS_T where ((FROM_EMPLOYEEID=e.EMPLOYEEID AND NOTF_TYPEID='INF') or (TO_EMPLOYEEID=e.EMPLOYEEID and NOTF_TYPEID='ACT')) and STATUS='OP') as NOTIFICATIONS, e.*,e.EMPLOYEEID from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='alkhaliqair.travels' and e.org_id='6' 4/12/2024 11:15:34 PM: select (select count(*) from LM_NOTIFICATIONS_T where ((FROM_EMPLOYEEID=e.EMPLOYEEID AND NOTF_TYPEID='INF') or (TO_EMPLOYEEID=e.EMPLOYEEID and NOTF_TYPEID='ACT')) and STATUS='OP') as NOTIFICATIONS, e.*,e.EMPLOYEEID from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='alkhaliqair.travels' and e.org_id='6' 4/12/2024 11:15:34 PM: select * from SM_APPLICATION_SETUP_T 4/12/2024 11:15:34 PM: select Logo_image from TK_ORGANIZATION_SETUP_T where org_id='6' 4/12/2024 11:15:44 PM: select b.ABBREVIATION, case when nvl(b.MANDATORY_TAG,'N')='Y' then nvl(b.DESCRIPTION,'')||' (*)' else b.DESCRIPTION end as DESCRIPTION, DEFAULT_TAG, SHORT_CODE,b.MANDATORY_TAG from GEN_PARAM_SETUPHD_T a, GEN_PARAM_SETUP_DTL_T b where a.ORG_ID=b.ORG_ID and a.APPLICATION_ID=b.APPLICATION_ID and a.SETUP_ID=b.SETUP_ID and a.ORG_ID=:ORG_ID and a.APPLICATION_ID=:APPLICATION_ID and a.SETUP_NAME=:SETUP_NAME and nvl(b.ACTIVE,'N') ='Y' and nvl(a.ACTIVE,'N')='Y' order by b.DESCRIPTION params: ORG_ID=6, APPLICATION_ID=12, SETUP_NAME=Gender 4/12/2024 11:15:44 PM: select b.ABBREVIATION, case when nvl(b.MANDATORY_TAG,'N')='Y' then nvl(b.DESCRIPTION,'')||' (*)' else b.DESCRIPTION end as DESCRIPTION, DEFAULT_TAG, SHORT_CODE,b.MANDATORY_TAG from GEN_PARAM_SETUPHD_T a, GEN_PARAM_SETUP_DTL_T b where a.ORG_ID=b.ORG_ID and a.APPLICATION_ID=b.APPLICATION_ID and a.SETUP_ID=b.SETUP_ID and a.ORG_ID=:ORG_ID and a.APPLICATION_ID=:APPLICATION_ID and a.SETUP_NAME=:SETUP_NAME and nvl(b.ACTIVE,'N') ='Y' and nvl(a.ACTIVE,'N')='Y' order by b.DISPLAY_ORDER params: ORG_ID=6, APPLICATION_ID=12, SETUP_NAME=RELATION 4/12/2024 11:15:44 PM: select b.ABBREVIATION, case when nvl(b.MANDATORY_TAG,'N')='Y' then nvl(b.DESCRIPTION,'')||' (*)' else b.DESCRIPTION end as DESCRIPTION, DEFAULT_TAG, SHORT_CODE,b.MANDATORY_TAG from GEN_PARAM_SETUPHD_T a, GEN_PARAM_SETUP_DTL_T b where a.ORG_ID=b.ORG_ID and a.APPLICATION_ID=b.APPLICATION_ID and a.SETUP_ID=b.SETUP_ID and a.ORG_ID=:ORG_ID and a.APPLICATION_ID=:APPLICATION_ID and a.SETUP_NAME=:SETUP_NAME and nvl(b.ACTIVE,'N') ='Y' and nvl(a.ACTIVE,'N')='Y' order by b.DESCRIPTION params: ORG_ID=6, APPLICATION_ID=12, SETUP_NAME=TRAVEL PURPOSE 4/12/2024 11:15:44 PM: select USERID from SM_USERS_T where USERNAME='alkhaliqair.travels' 4/12/2024 11:15:44 PM: select B.ROLE_DESC from SM_USER_ROLE_MAPPING_T A LEFT JOIN SM_ROLE_SETUP_T B ON(B.ROLE_ID = A.ROLE_ID) LEFT JOIN SM_USERS_T U ON(U.USERID = A.USERID) WHERE A.APPLICATION_ID=23 AND U.USERNAME='alkhaliqair.travels' 4/12/2024 11:15:45 PM: select * from COUNTRY order by COUNTRY_CODE 4/12/2024 11:15:45 PM: SELECT VALUESET_ID,VALUE_ID,VALUE_DESC FROM pf_valueset_values_t where ACTIVE='1' order by VALUE_DESC 4/12/2024 11:15:45 PM: select b.ABBREVIATION, case when nvl(b.MANDATORY_TAG,'N')='Y' then nvl(b.DESCRIPTION,'')||' (*)' else b.DESCRIPTION end as DESCRIPTION, DEFAULT_TAG, SHORT_CODE,b.MANDATORY_TAG from GEN_PARAM_SETUPHD_T a, GEN_PARAM_SETUP_DTL_T b where a.ORG_ID=b.ORG_ID and a.APPLICATION_ID=b.APPLICATION_ID and a.SETUP_ID=b.SETUP_ID and a.ORG_ID=:ORG_ID and a.APPLICATION_ID=:APPLICATION_ID and a.SETUP_NAME=:SETUP_NAME and nvl(b.ACTIVE,'N') ='Y' and nvl(a.ACTIVE,'N')='Y' order by b.DESCRIPTION params: ORG_ID=6, APPLICATION_ID=12, SETUP_NAME=TRAVEL PLAN TYPE 4/12/2024 11:15:45 PM: SELECT a.TP_ID,b.PLAN_NAME FROM AGENT_PLAN_MAPPING a LEFT OUTER JOIN TRAVEL_PLAN_T b ON a.TP_ID = b.TP_ID AND A.BRANCH_ID=B.BRANCH_ID where a.USER_ID =:USER_ID AND a.ORG_ID = :ORG_ID AND A.BRANCH_ID=:BRANCH_ID params: USER_ID=447, ORG_ID=6, BRANCH_ID=1 4/12/2024 11:36:04 PM: Session Ended ...... 4/12/2024 11:36:04 PM: {}