Log File Initialized... 4/10/2024 1:49:03 AM 4/10/2024 1:49:03 AM: Applccation Started...... 4/10/2024 1:49:04 AM: Apis Configured ...... 4/10/2024 1:49:07 AM: Session Started ...... 4/10/2024 1:49:07 AM: {} 4/10/2024 1:49:08 AM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 1:49:10 AM: select RELEASE_VERSION from SM_RELEASE_INFO_T order by SERIAL_NO desc 4/10/2024 1:49:10 AM: Session Ended ...... 4/10/2024 1:49:10 AM: {} 4/10/2024 2:51:01 AM: Session Started ...... 4/10/2024 2:51:01 AM: {} 4/10/2024 2:51:01 AM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 2:51:01 AM: Session Ended ...... 4/10/2024 2:51:01 AM: {} 4/10/2024 2:51:11 AM: select * from SM_APPLICATION_SETUP_T 4/10/2024 2:51:11 AM: select * from SM_APPLICATION_SETUP_T 4/10/2024 2:51:24 AM: Session Started ...... 4/10/2024 2:51:24 AM: {} 4/10/2024 3:11:41 AM: Session Ended ...... 4/10/2024 3:11:41 AM: {} 4/10/2024 3:21:02 AM: Session Started ...... 4/10/2024 3:21:02 AM: {} 4/10/2024 3:29:29 AM: Session Started ...... 4/10/2024 3:29:29 AM: {} 4/10/2024 3:29:41 AM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 3:29:41 AM: Session Ended ...... 4/10/2024 3:29:41 AM: {} 4/10/2024 3:50:06 AM: Session Started ...... 4/10/2024 3:50:06 AM: {} 4/10/2024 4:10:23 AM: Session Ended ...... 4/10/2024 4:10:23 AM: {} 4/10/2024 4:12:36 AM: Session Started ...... 4/10/2024 4:12:36 AM: {} 4/10/2024 4:12:36 AM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 4:12:36 AM: Session Ended ...... 4/10/2024 4:12:36 AM: {} 4/10/2024 4:21:08 AM: Session Started ...... 4/10/2024 4:21:08 AM: {} 4/10/2024 4:21:08 AM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 4:21:08 AM: Session Ended ...... 4/10/2024 4:21:08 AM: {} 4/10/2024 4:51:10 AM: Session Started ...... 4/10/2024 4:51:10 AM: {} 4/10/2024 4:51:11 AM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 4:51:11 AM: Session Ended ...... 4/10/2024 4:51:11 AM: {} 4/10/2024 5:35:25 AM: Session Started ...... 4/10/2024 5:35:25 AM: {} 4/10/2024 5:35:26 AM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 5:35:26 AM: Session Ended ...... 4/10/2024 5:35:26 AM: {} 4/10/2024 6:34:45 AM: Session Started ...... 4/10/2024 6:34:45 AM: {} 4/10/2024 6:34:46 AM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 6:34:46 AM: Session Ended ...... 4/10/2024 6:34:46 AM: {} 4/10/2024 8:33:19 AM: Applccation Started...... 4/10/2024 8:33:20 AM: Apis Configured ...... 4/10/2024 10:58:18 AM: Session Started ...... 4/10/2024 10:58:18 AM: {} 4/10/2024 10:58:19 AM: SELECT CHANN.CHANNEL_ID, CHANN.CHANNEL_NAME, a.CANCELLATION_REMARKS, TO_CHAR (a.CANCEL_DATE, 'DD-MON-YYYY') CANCEL_DATE, TO_CHAR (a.COMM_DATE, 'DD-MON-YYYY') COMM_DATE, TO_CHAR (a.ISSUE_DATE, 'DD-MON-YYYY') ISSUE_DATE, a.MASTER_REF_NO, a.DOC_REFERENCE_NO, a.TOPUP_AMOUNT, a.BASIC_CONTRIBUTION_MODAL, a.PAYMENT_TERM, a.POLICY_TERM, TO_CHAR (a.POST_DATE, 'DD-MON-YYYY') POST_DATE, NVL (ow.first_name, '') || ' ' || NVL (ow.middle_name, '') || ' ' || NVL (ow.last_name, '') AS OwnerName, cty.CITY_NAME, INS.INSTALLMENT_NO, TO_CHAR (INS.DUE_DATE, 'DD-MON-YYYY') DUE_DATE, GRP.GROUP_NAME, rn.PARTNER_REGION_NAME, AR.PARTNER_AREA_NAME, dss.STATUS_DESC, AGT.AGENT_NAME, apbt.PARTNER_BRANCH_NAME, apbt.PARTNER_BRANCH_ID FROM il_doc_header_t a LEFT OUTER JOIN am_agent_t AGT ON (AGT.ORG_ID = a.ORG_ID AND AGT.AGENT_ID = a.AGENT_ID) LEFT OUTER JOIN AM_DISTRIBUTION_CHANNEL_T CHANN ON (CHANN.ORG_ID = a.ORG_ID AND CHANN.CHANNEL_ID = a.CHANNEL_ID) LEFT OUTER JOIN IL_DOC_CLIENT_PERS_INFO_T ow ON ( ow.ORG_ID = a.ORG_ID AND ow.BRANCH_ID = a.BRANCH_ID AND ow.MAIN_PRODUCT_CODE = a.MAIN_PRODUCT_CODE AND ow.SUB_PRODUCT_CODE = a.SUB_PRODUCT_CODE AND ow.TAKAFUL_TYPE = a.TAKAFUL_TYPE AND ow.DOCUMENT_TYPE = a.DOCUMENT_TYPE AND ow.RECORD_TYPE = a.RECORD_TYPE AND ow.DOCUMENT_YEAR = a.DOCUMENT_YEAR AND ow.ISSUE_COUNT = a.ISSUE_COUNT AND ow.ENDORSEMENT_NO = a.ENDORSEMENT_NO AND ow.APPLICATION_ID = a.APPLICATION_ID AND ow.DOCUMENT_NO = a.DOCUMENT_NO AND ow.client_code = a.client_code) LEFT OUTER JOIN il_doc_address_t b ON ( a.ORG_ID = b.ORG_ID AND a.BRANCH_ID = b.BRANCH_ID AND a.MAIN_PRODUCT_CODE = b.MAIN_PRODUCT_CODE AND a.SUB_PRODUCT_CODE = b.SUB_PRODUCT_CODE AND a.TAKAFUL_TYPE = b.TAKAFUL_TYPE AND a.DOCUMENT_TYPE = b.DOCUMENT_TYPE AND a.RECORD_TYPE = b.RECORD_TYPE AND a.DOCUMENT_YEAR = b.DOCUMENT_YEAR AND a.ISSUE_COUNT = b.ISSUE_COUNT AND a.ENDORSEMENT_NO = b.ENDORSEMENT_NO AND a.APPLICATION_ID = b.APPLICATION_ID AND a.DOCUMENT_NO = b.DOCUMENT_NO AND b.CORRESPONDENCE_TAG = 'Y' AND b.ENTRY_TYPE = CASE NVL (a.PAYER_SAME_TAG, 'N') WHEN 'Y' THEN 'CL' ELSE 'PY' END) LEFT OUTER JOIN COUNTRY_city_t CTY ON ( CTY.COUNTRY_CODE = B.COUNTRY_CODE AND CTY.STATE_CODE = B.STATE_CODE AND CTY.CITY_CODE = B.CITY_CODE) LEFT OUTER JOIN IL_DOC_INSTALLMENTS_T INS ON ( a.ORG_ID = INS.ORG_ID AND a.BRANCH_ID = INS.BRANCH_ID AND a.MAIN_PRODUCT_CODE = INS.MAIN_PRODUCT_CODE AND a.SUB_PRODUCT_CODE = INS.SUB_PRODUCT_CODE AND a.TAKAFUL_TYPE = INS.TAKAFUL_TYPE AND a.DOCUMENT_TYPE = INS.DOCUMENT_TYPE AND a.RECORD_TYPE = INS.RECORD_TYPE AND a.DOCUMENT_YEAR = INS.DOCUMENT_YEAR AND a.ISSUE_COUNT = INS.ISSUE_COUNT AND a.ENDORSEMENT_NO = INS.ENDORSEMENT_NO AND a.APPLICATION_ID = INS.APPLICATION_ID AND a.DOCUMENT_NO = INS.DOCUMENT_NO) LEFT OUTER JOIN AM_CHANNEL_MODEL_T MOD ON ( A.ORG_ID = MOD.ORG_ID AND A.CHANNEL_ID = MOD.CHANNEL_ID AND A.MODEL_ID = MOD.MODEL_ID) LEFT OUTER JOIN AM_PARTNER_T amt ON (a.ORG_ID = amt.ORG_ID AND a.partner_id = amt.partner_id) LEFT OUTER JOIN AM_PARTNER_BRANCHES_T apbt ON ( apbt.ORG_ID = A.ORG_ID AND apbt.partner_id = A.partner_id AND APBT.PARTNER_BRANCH_ID = A.PARTNER_BRANCH_ID) LEFT OUTER JOIN AM_PARTNER_GROUP_T GRP ON ( apbt.ORG_ID = GRP.ORG_ID AND apbt.PARTNER_ID = GRP.PARTNER_ID AND apbt.GROUP_ID = GRP.PARTNER_GROUP_ID) LEFT OUTER JOIN AM_PARTNER_REGION_T RN ON ( apbt.ORG_ID = RN.ORG_ID AND apbt.PARTNER_ID = RN.PARTNER_ID AND apbt.GROUP_ID = RN.PARTNER_GROUP_ID AND apbt.REGION_ID = RN.PARTNER_REGION_ID) LEFT OUTER JOIN AM_PARTNER_AREA_T AR ON ( apbt.ORG_ID = AR.ORG_ID AND apbt.PARTNER_ID = AR.PARTNER_ID AND apbt.GROUP_ID = AR.PARTNER_GROUP_ID AND apbt.REGION_ID = AR.PARTNER_REGION_ID AND apbt.AREA_ID = AR.PARTNER_REGION_ID) LEFT OUTER JOIN IL_DOC_STATUS_SETUP_T dss ON (dss.ORG_ID = a.ORG_ID AND dss.STATUS_CODE = a.undwt_status) WHERE amt.ORG_ID = 5 AND a.DOCUMENT_TYPE = 'P' AND a.ENDORSEMENT_NO = 0 AND a.CANCEL_TAG IS NULL AND a.DOC_REFERENCE_KEY IS NOT NULL AND a.REVISED_TAG IS NULL AND amt.Partner_ID = '2' AND TRUNC (a.CREATION_DATE) BETWEEN '03-jan-2022' AND '30-jul-2023' AND ( A.document_type = 'Q' OR iNS.INSTALLMENT_NO = (SELECT MIN (inst.INSTALLMENT_NO) FROM IL_DOC_INSTALLMENTS_T inst WHERE a.ORG_ID = inst.ORG_ID AND a.BRANCH_ID = inst.BRANCH_ID AND a.MAIN_PRODUCT_CODE = inst.MAIN_PRODUCT_CODE AND a.SUB_PRODUCT_CODE = inst.SUB_PRODUCT_CODE AND a.TAKAFUL_TYPE = inst.TAKAFUL_TYPE AND a.DOCUMENT_TYPE = inst.DOCUMENT_TYPE AND a.DOCUMENT_NO = inst.DOCUMENT_NO AND a.RECORD_TYPE = inst.RECORD_TYPE AND a.DOCUMENT_YEAR = inst.DOCUMENT_YEAR AND a.ISSUE_COUNT = inst.ISSUE_COUNT AND a.ENDORSEMENT_NO = inst.ENDORSEMENT_NO AND a.APPLICATION_ID = inst.APPLICATION_ID AND NVL (inst.POSTING_TAG, 'N') <> 'Y')) 4/10/2024 11:18:44 AM: Session Ended ...... 4/10/2024 11:18:44 AM: {} 4/10/2024 11:22:08 AM: Session Started ...... 4/10/2024 11:22:08 AM: {} 4/10/2024 12:57:02 PM: Session Started ...... 4/10/2024 12:57:02 PM: {} 4/10/2024 1:12:16 PM: Session Started ...... 4/10/2024 1:12:16 PM: {} 4/10/2024 1:12:16 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 1:12:16 PM: select RELEASE_VERSION from SM_RELEASE_INFO_T order by SERIAL_NO desc 4/10/2024 1:12:16 PM: Session Ended ...... 4/10/2024 1:12:16 PM: {} 4/10/2024 1:12:18 PM: select * from SM_APPLICATION_SETUP_T 4/10/2024 1:12:18 PM: select * from SM_APPLICATION_SETUP_T 4/10/2024 1:12:56 PM: Session Started ...... 4/10/2024 1:12:56 PM: {} 4/10/2024 1:12:56 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 1:12:56 PM: Session Ended ...... 4/10/2024 1:12:56 PM: {} 4/10/2024 1:12:59 PM: select * from SM_APPLICATION_SETUP_T 4/10/2024 1:12:59 PM: select * from SM_APPLICATION_SETUP_T 4/10/2024 1:14:14 PM: Session Started ...... 4/10/2024 1:14:14 PM: {} 4/10/2024 1:14:14 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 1:14:14 PM: **************************** User shafiq_rehman Login Request..... **************************** 4/10/2024 1:14:14 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME=shafiq_rehman 4/10/2024 1:14:15 PM: ************* Deleting Un-Used Tokens.. For User: shafiq_rehman ************* 4/10/2024 1:14:15 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME=shafiq_rehman 4/10/2024 1:14:15 PM: delete from SM_EMAIL_TOKENS_T where USERID=:USERID and nvl(TOKEN_USED,'N') = :TOKEN_USED params: USERID=441, TOKEN_USED=N 4/10/2024 1:14:15 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=shafiq_rehman 4/10/2024 1:14:15 PM: select * from SM_APPLICATION_SETUP_T 4/10/2024 1:14: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=shafiq_rehman 4/10/2024 1:14:15 PM: select nvl(max(SERIAL_NO),0)+1 from SM_USER_LOGIN_HIST_T 4/10/2024 1:14:15 PM: select to_char(sysdate,'dd/mm/yyyy hh24:mi:ss') from dual 4/10/2024 1:14:15 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=3100, USERNAME=shafiq_rehman, PASSWORD=8KnHnwew8abgMkg+nBvBAEW3bD+6dWZvzATPpl6O9+LRHxk976s6sInN1HAhgpGAuFX7D6RwxBD+qeEY8wmtwcCmGVcimAPVK/dZ/10Rs5DEIJC2y6nipAzjMWmzcaNr, IP_ADDRESS=182.191.151.252, OTHER_INFO=Chrome103-103.0-Unknown, STATUS_TAG=S, STATUS_MESSAGE=success, CREATION_DATE=4/11/2024 1:14:14 AM 4/10/2024 1:14:15 PM: update SM_USERS_T set LOGIN_ATTEMPTS=0 where upper(USERNAME) = upper(:USERNAME) params: USERNAME=shafiq_rehman 4/10/2024 1:14:15 PM: update SM_USERS_T set LAST_LOGIN=sysdate where upper(USERNAME) = upper(:USERNAME) params: USERNAME=shafiq_rehman 4/10/2024 1:14:15 PM: **************************** User shafiq_rehman Logged in Successfully.. **************************** 4/10/2024 1:14:15 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='MASTER_ADMIN_ID' 4/10/2024 1:14:15 PM: select RELEASE_VERSION from SM_RELEASE_INFO_T order by SERIAL_NO desc 4/10/2024 1:14:15 PM: select to_char(CREATION_DATE,'dd/mm/yyyy') CREATION_DATE from SM_USERS_T where upper(USERID)=upper(:USERID) params: USERID=441 4/10/2024 1:14:15 PM: select APPLICATION_ID from SM_APPLICATION_USER_MAPPING_T where USERID=:USERID order by APPLICATION_ID params: USERID=441 4/10/2024 1:14:15 PM: select ORG_ID from SM_USER_ORG_MAPPING_T b where upper(USERID) = upper(:USERID) params: USERID=shafiq_rehman 4/10/2024 1:14:15 PM: select * from SM_USERS_T where USERID=:USERID params: USERID=441 4/10/2024 1:14:15 PM: Request.IsSecureConnection True 4/10/2024 1:14: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=shafiq_rehman 4/10/2024 1:14:16 PM: sid td0ksmu5nkl1zkwfxutxw5r5 4/10/2024 1:14:16 PM: sid 67cb450d-95e4-4622-b5b4-10dd6e244dae 4/10/2024 1:14:16 PM: sid ZealERP.ZealSecurity.Models.NewSecurity.User 4/10/2024 1:14:19 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME= 4/10/2024 1:14:19 PM: select * from SM_USERS_T where USERID=:USERID params: USERID=441 4/10/2024 1:14:19 PM: ************* Deleting Un-Used Tokens.. For User: ************* 4/10/2024 1:14:19 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME= 4/10/2024 1:14:19 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=shafiq_rehman 4/10/2024 1:14:19 PM: select * from SM_APPLICATION_SETUP_T 4/10/2024 1:14:19 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=shafiq_rehman 4/10/2024 1:14:20 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=shafiq_rehman 4/10/2024 1:14:20 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='shafiq_rehman' and e.ORG_ID='6' 4/10/2024 1:14:20 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='shafiq_rehman' and e.ORG_ID='6' 4/10/2024 1:14:20 PM: select e.EMPLOYEENUMBER from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='shafiq_rehman' and e.ORG_ID='6' 4/10/2024 1:14:20 PM: select e.EMPLOYEENUMBER from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='shafiq_rehman' and e.ORG_ID='6' 4/10/2024 1:14:20 PM: select to_char(sysdate,'dd/mm/yyyy hh24:mi:ss') from dual 4/10/2024 1:14:20 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='shafiq_rehman' 4/10/2024 1:14:20 PM: select APPLICATION_ID from SM_APPLICATION_USER_MAPPING_T where USERID= :USERID order by APPLICATION_ID params: USERID=441 4/10/2024 1:14:20 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=shafiq_rehman 4/10/2024 1:14:20 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=441, APPLICATION_ID2=23, USERID2=441, APPLICATION_ID3=23 4/10/2024 1:14:20 PM: select APPLICATION_DESC,BRANCH_REQUIRED from SM_APPLICATION_SETUPHD_T where APPLICATION_ID=:APPLICATION_ID params: APPLICATION_ID=23 4/10/2024 1:14:20 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=shafiq_rehman 4/10/2024 1:14:20 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=441, APPLICATION_ID=23, USERID2=441, APPLICATION_ID2=23 4/10/2024 1:14:20 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=441, APPLICATION_ID2=23 4/10/2024 1:14:20 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=441, APPLICATION_ID2=23 4/10/2024 1:14:20 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=shafiq_rehman 4/10/2024 1:14:20 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/10/2024 1:14:20 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='GENERAL_PARAMETER_APP_ID' 4/10/2024 1:14:20 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='AGENCY_MANAGEMENT_APP_ID' 4/10/2024 1:14:20 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='ZEAL_FINANCIAL_APP_ID' 4/10/2024 1:14:20 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='GLAS_APP_ID' 4/10/2024 1:14:20 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='ILAS_APP_ID' 4/10/2024 1:14:20 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='GHAS_APP_ID' 4/10/2024 1:14:20 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='IHAS_APP_ID' 4/10/2024 1:14:20 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='NEW_ADVICE_ENTRY' 4/10/2024 1:14:23 PM: select * from SM_APPLICATION_SETUPHD_T where ACTIVE='1' order by APPLICATION_ID 4/10/2024 1:14:23 PM: select * from SM_APPLICATION_USER_MAPPING_T order by APPLICATION_ID,USERID 4/10/2024 1:14:23 PM: select a.ORG_ID from SM_USER_ORG_MAPPING_T a where upper(a.USERID) = :USERID params: USERID=SHAFIQ_REHMAN 4/10/2024 1:14:23 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=SHAFIQ_REHMAN, ORG_ID=6 4/10/2024 1:14: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=shafiq_rehman 4/10/2024 1:14:26 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=shafiq_rehman 4/10/2024 1:14:39 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=441, APPLICATION_ID2=23, USERID2=441, APPLICATION_ID3=23 4/10/2024 1:14:39 PM: select APPLICATION_DESC,BRANCH_REQUIRED from SM_APPLICATION_SETUPHD_T where APPLICATION_ID=:APPLICATION_ID params: APPLICATION_ID=23 4/10/2024 1:14:39 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=shafiq_rehman 4/10/2024 1:14:39 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=shafiq_rehman, BRANCH_ID=1 4/10/2024 1:14:39 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/10/2024 1:14:39 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/10/2024 1:14:39 PM: select AGENT_ID,AGENT_NAME from AM_AGENT_T where ORG_ID = :ORG_ID and USERNAME = :USERNAME params: ORG_ID=6, USERNAME=shafiq_rehman 4/10/2024 1:14:39 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=shafiq_rehman 4/10/2024 1:14:39 PM: Select DEFAULT_CURRENCY,DEFAULT_COUNTRY From TK_BRANCH_SETUP_T where BRANCH_ID=:BRANCH_ID params: BRANCH_ID=1 4/10/2024 1:14:39 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/10/2024 1:14:39 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=shafiq_rehman 4/10/2024 1:14:39 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='shafiq_rehman' and e.org_id='6' 4/10/2024 1:14:39 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='shafiq_rehman' and e.org_id='6' 4/10/2024 1:14:39 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='SECURITY_MODULE_APP_ID' 4/10/2024 1:14:39 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='HCM_APP_ID' 4/10/2024 1:14:39 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='ISSUE_DATE_EDITABLE' 4/10/2024 1:14:39 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='PROV_RECEIPT_VOUCHER_TYPE' 4/10/2024 1:14:39 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='KNOCKOFF_VOUCHER_ON_CURRENT_DATE' 4/10/2024 1:14:39 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='GLAS_BULK_POSTING' 4/10/2024 1:14:39 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='SHOW_WITHOUT_ACCOUNTING' 4/10/2024 1:14:39 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='NEW_VOUCHER_ENTRY' 4/10/2024 1:14:39 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='SUITE_ANALYSIS' 4/10/2024 1:14:39 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='NEED_ANALYSIS' 4/10/2024 1:14:39 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='OCC_ON_ILLUSTRATION' 4/10/2024 1:14:39 PM: select CONFIG_NAME,CONFIG_VALUE from SM_APPLICATION_CONFIG_T where CONFIG_NAME='CBC_ON_PROPOSAL' 4/10/2024 1:14:43 PM: select * from SM_APPLICATION_SETUP_T 4/10/2024 1:14:43 PM: select Logo_image from TK_ORGANIZATION_SETUP_T where org_id='6' 4/10/2024 1:15:26 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='shafiq_rehman' and e.org_id='6' 4/10/2024 1:15:26 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='shafiq_rehman' and e.org_id='6' 4/10/2024 1:15:28 PM: select * from SM_APPLICATION_SETUP_T 4/10/2024 1:15:28 PM: select Logo_image from TK_ORGANIZATION_SETUP_T where org_id='6' 4/10/2024 1:15:32 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/10/2024 1:15:32 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/10/2024 1:15:32 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/10/2024 1:15:32 PM: select USERID from SM_USERS_T where USERNAME='shafiq_rehman' 4/10/2024 1:15:32 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='shafiq_rehman' 4/10/2024 1:15:32 PM: select * from COUNTRY order by COUNTRY_CODE 4/10/2024 1:15:32 PM: SELECT VALUESET_ID,VALUE_ID,VALUE_DESC FROM pf_valueset_values_t where ACTIVE='1' order by VALUE_DESC 4/10/2024 1:15:32 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/10/2024 1:15:33 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=441, ORG_ID=6, BRANCH_ID=1 4/10/2024 1:16:26 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=shafiq_rehman 4/10/2024 1:16:26 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='shafiq_rehman' and e.ORG_ID='6' 4/10/2024 1:16:26 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='shafiq_rehman' and e.ORG_ID='6' 4/10/2024 1:16:26 PM: select e.EMPLOYEENUMBER from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='shafiq_rehman' and e.ORG_ID='6' 4/10/2024 1:16:26 PM: select e.EMPLOYEENUMBER from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='shafiq_rehman' and e.ORG_ID='6' 4/10/2024 1:16:26 PM: select to_char(sysdate,'dd/mm/yyyy hh24:mi:ss') from dual 4/10/2024 1:16:26 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='shafiq_rehman' 4/10/2024 1:16:26 PM: select APPLICATION_ID from SM_APPLICATION_USER_MAPPING_T where USERID= :USERID order by APPLICATION_ID params: USERID=441 4/10/2024 1:16:26 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=shafiq_rehman 4/10/2024 1:16:26 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=441, APPLICATION_ID2=23, USERID2=441, APPLICATION_ID3=23 4/10/2024 1:16:26 PM: select APPLICATION_DESC,BRANCH_REQUIRED from SM_APPLICATION_SETUPHD_T where APPLICATION_ID=:APPLICATION_ID params: APPLICATION_ID=23 4/10/2024 1:16:26 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=shafiq_rehman 4/10/2024 1:16:26 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=shafiq_rehman 4/10/2024 1:16:26 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/10/2024 1:16:26 PM: select * from SM_APPLICATION_SETUPHD_T where ACTIVE='1' order by APPLICATION_ID 4/10/2024 1:16:26 PM: select * from SM_APPLICATION_USER_MAPPING_T order by APPLICATION_ID,USERID 4/10/2024 1:16:26 PM: select a.ORG_ID from SM_USER_ORG_MAPPING_T a where upper(a.USERID) = :USERID params: USERID=SHAFIQ_REHMAN 4/10/2024 1:16:26 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=SHAFIQ_REHMAN, ORG_ID=6 4/10/2024 1:16:27 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=shafiq_rehman 4/10/2024 1:16:27 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=shafiq_rehman 4/10/2024 1:16:30 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 1:16:30 PM: Session Ended ...... 4/10/2024 1:16:30 PM: {} 4/10/2024 1:17:26 PM: Session Started ...... 4/10/2024 1:17:26 PM: {} 4/10/2024 1:17:26 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 1:17:26 PM: Session Ended ...... 4/10/2024 1:17:26 PM: {} 4/10/2024 1:17:27 PM: select * from SM_APPLICATION_SETUP_T 4/10/2024 1:17:27 PM: select * from SM_APPLICATION_SETUP_T 4/10/2024 1:18:25 PM: Session Started ...... 4/10/2024 1:18:25 PM: {} 4/10/2024 1:18:25 PM: Session Started ...... 4/10/2024 1:18:25 PM: {} 4/10/2024 1:18:25 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 1:18:25 PM: **************************** User shafiq_rehman Login Request..... **************************** 4/10/2024 1:18:25 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME=shafiq_rehman 4/10/2024 1:18:25 PM: ************* Deleting Un-Used Tokens.. For User: shafiq_rehman ************* 4/10/2024 1:18:25 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME=shafiq_rehman 4/10/2024 1:18:25 PM: delete from SM_EMAIL_TOKENS_T where USERID=:USERID and nvl(TOKEN_USED,'N') = :TOKEN_USED params: USERID=441, TOKEN_USED=N 4/10/2024 1:18:25 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=shafiq_rehman 4/10/2024 1:18:25 PM: select * from SM_APPLICATION_SETUP_T 4/10/2024 1:18:25 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=shafiq_rehman 4/10/2024 1:18:25 PM: select nvl(max(SERIAL_NO),0)+1 from SM_USER_LOGIN_HIST_T 4/10/2024 1:18:25 PM: select to_char(sysdate,'dd/mm/yyyy hh24:mi:ss') from dual 4/10/2024 1:18:25 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=3101, USERNAME=shafiq_rehman, PASSWORD=RV0mwEfFuRfwnHHdO8pc4klaaNbzqghzmXZqNhwBr//irC3RmsCghekuoKqO/lzKOXgHOZPQm18aH8iLMTUqX/9O7zgo+dHKl7UXbpW4weCPZp3hAG8uNgE1/8ciOBSM, IP_ADDRESS=182.191.151.252, OTHER_INFO=Chrome103-103.0-Unknown, STATUS_TAG=S, STATUS_MESSAGE=success, CREATION_DATE=4/11/2024 1:18:24 AM 4/10/2024 1:18:25 PM: update SM_USERS_T set LOGIN_ATTEMPTS=0 where upper(USERNAME) = upper(:USERNAME) params: USERNAME=shafiq_rehman 4/10/2024 1:18:25 PM: update SM_USERS_T set LAST_LOGIN=sysdate where upper(USERNAME) = upper(:USERNAME) params: USERNAME=shafiq_rehman 4/10/2024 1:18:25 PM: **************************** User shafiq_rehman Logged in Successfully.. **************************** 4/10/2024 1:18:25 PM: select RELEASE_VERSION from SM_RELEASE_INFO_T order by SERIAL_NO desc 4/10/2024 1:18:25 PM: select to_char(CREATION_DATE,'dd/mm/yyyy') CREATION_DATE from SM_USERS_T where upper(USERID)=upper(:USERID) params: USERID=441 4/10/2024 1:18:25 PM: select APPLICATION_ID from SM_APPLICATION_USER_MAPPING_T where USERID=:USERID order by APPLICATION_ID params: USERID=441 4/10/2024 1:18:25 PM: select ORG_ID from SM_USER_ORG_MAPPING_T b where upper(USERID) = upper(:USERID) params: USERID=shafiq_rehman 4/10/2024 1:18:25 PM: select * from SM_USERS_T where USERID=:USERID params: USERID=441 4/10/2024 1:18:25 PM: Request.IsSecureConnection True 4/10/2024 1:18:25 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=shafiq_rehman 4/10/2024 1:18:27 PM: sid gkiye2gkw0pyvqtxabkg5lcl 4/10/2024 1:18:27 PM: sid b5ef6635-3aa6-4744-870f-931867a46f81 4/10/2024 1:18:27 PM: sid ZealERP.ZealSecurity.Models.NewSecurity.User 4/10/2024 1:18:28 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME= 4/10/2024 1:18:28 PM: select * from SM_USERS_T where USERID=:USERID params: USERID=441 4/10/2024 1:18:28 PM: ************* Deleting Un-Used Tokens.. For User: ************* 4/10/2024 1:18:28 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME= 4/10/2024 1:18:28 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=shafiq_rehman 4/10/2024 1:18:28 PM: select * from SM_APPLICATION_SETUP_T 4/10/2024 1:18:28 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=shafiq_rehman 4/10/2024 1:18:28 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=shafiq_rehman 4/10/2024 1:18:28 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='shafiq_rehman' and e.ORG_ID='6' 4/10/2024 1:18:28 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='shafiq_rehman' and e.ORG_ID='6' 4/10/2024 1:18:28 PM: select e.EMPLOYEENUMBER from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='shafiq_rehman' and e.ORG_ID='6' 4/10/2024 1:18:28 PM: select e.EMPLOYEENUMBER from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='shafiq_rehman' and e.ORG_ID='6' 4/10/2024 1:18:28 PM: select to_char(sysdate,'dd/mm/yyyy hh24:mi:ss') from dual 4/10/2024 1:18:28 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='shafiq_rehman' 4/10/2024 1:18:28 PM: select APPLICATION_ID from SM_APPLICATION_USER_MAPPING_T where USERID= :USERID order by APPLICATION_ID params: USERID=441 4/10/2024 1:18:29 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=shafiq_rehman 4/10/2024 1:18:29 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=441, APPLICATION_ID2=23, USERID2=441, APPLICATION_ID3=23 4/10/2024 1:18:29 PM: select APPLICATION_DESC,BRANCH_REQUIRED from SM_APPLICATION_SETUPHD_T where APPLICATION_ID=:APPLICATION_ID params: APPLICATION_ID=23 4/10/2024 1:18:29 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=shafiq_rehman 4/10/2024 1:18:29 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=441, APPLICATION_ID=23, USERID2=441, APPLICATION_ID2=23 4/10/2024 1:18:29 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=441, APPLICATION_ID2=23 4/10/2024 1:18:29 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=441, APPLICATION_ID2=23 4/10/2024 1:18:29 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=shafiq_rehman 4/10/2024 1:18:29 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/10/2024 1:18:29 PM: select * from SM_APPLICATION_SETUPHD_T where ACTIVE='1' order by APPLICATION_ID 4/10/2024 1:18:29 PM: select * from SM_APPLICATION_USER_MAPPING_T order by APPLICATION_ID,USERID 4/10/2024 1:18:29 PM: select a.ORG_ID from SM_USER_ORG_MAPPING_T a where upper(a.USERID) = :USERID params: USERID=SHAFIQ_REHMAN 4/10/2024 1:18:29 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=SHAFIQ_REHMAN, ORG_ID=6 4/10/2024 1:18:31 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=shafiq_rehman 4/10/2024 1:18:31 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=shafiq_rehman 4/10/2024 1:18:37 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=441, APPLICATION_ID2=23, USERID2=441, APPLICATION_ID3=23 4/10/2024 1:18:37 PM: select APPLICATION_DESC,BRANCH_REQUIRED from SM_APPLICATION_SETUPHD_T where APPLICATION_ID=:APPLICATION_ID params: APPLICATION_ID=23 4/10/2024 1:18:37 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=shafiq_rehman 4/10/2024 1:18:37 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=shafiq_rehman, BRANCH_ID=1 4/10/2024 1:18:37 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/10/2024 1:18:37 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/10/2024 1:18:37 PM: select AGENT_ID,AGENT_NAME from AM_AGENT_T where ORG_ID = :ORG_ID and USERNAME = :USERNAME params: ORG_ID=6, USERNAME=shafiq_rehman 4/10/2024 1:18:37 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=shafiq_rehman 4/10/2024 1:18:37 PM: Select DEFAULT_CURRENCY,DEFAULT_COUNTRY From TK_BRANCH_SETUP_T where BRANCH_ID=:BRANCH_ID params: BRANCH_ID=1 4/10/2024 1:18:37 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/10/2024 1:18:37 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=shafiq_rehman 4/10/2024 1:18:38 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='shafiq_rehman' and e.org_id='6' 4/10/2024 1:18:38 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='shafiq_rehman' and e.org_id='6' 4/10/2024 1:18:38 PM: select * from SM_APPLICATION_SETUP_T 4/10/2024 1:18:38 PM: select Logo_image from TK_ORGANIZATION_SETUP_T where org_id='6' 4/10/2024 1:18:54 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='shafiq_rehman' and e.org_id='6' 4/10/2024 1:18:54 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='shafiq_rehman' and e.org_id='6' 4/10/2024 1:18:54 PM: select * from SM_APPLICATION_SETUP_T 4/10/2024 1:18:54 PM: select Logo_image from TK_ORGANIZATION_SETUP_T where org_id='6' 4/10/2024 1:18:57 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/10/2024 1:18:57 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/10/2024 1:18:57 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/10/2024 1:18:57 PM: select USERID from SM_USERS_T where USERNAME='shafiq_rehman' 4/10/2024 1:18:57 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='shafiq_rehman' 4/10/2024 1:18:58 PM: select * from COUNTRY order by COUNTRY_CODE 4/10/2024 1:18:58 PM: SELECT VALUESET_ID,VALUE_ID,VALUE_DESC FROM pf_valueset_values_t where ACTIVE='1' order by VALUE_DESC 4/10/2024 1:18:58 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/10/2024 1:18:58 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=441, ORG_ID=6, BRANCH_ID=1 4/10/2024 1:19:55 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='shafiq_rehman' and e.org_id='6' 4/10/2024 1:19:55 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='shafiq_rehman' and e.org_id='6' 4/10/2024 1:19:56 PM: select * from SM_APPLICATION_SETUP_T 4/10/2024 1:19:56 PM: select Logo_image from TK_ORGANIZATION_SETUP_T where org_id='6' 4/10/2024 1:19:58 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/10/2024 1:19:58 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/10/2024 1:19:58 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/10/2024 1:19:58 PM: select USERID from SM_USERS_T where USERNAME='shafiq_rehman' 4/10/2024 1:19:59 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='shafiq_rehman' 4/10/2024 1:19:59 PM: select * from COUNTRY order by COUNTRY_CODE 4/10/2024 1:19:59 PM: SELECT VALUESET_ID,VALUE_ID,VALUE_DESC FROM pf_valueset_values_t where ACTIVE='1' order by VALUE_DESC 4/10/2024 1:19:59 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/10/2024 1:19:59 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=441, ORG_ID=6, BRANCH_ID=1 4/10/2024 1:20:26 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=shafiq_rehman 4/10/2024 1:20:26 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='shafiq_rehman' and e.ORG_ID='6' 4/10/2024 1:20:26 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='shafiq_rehman' and e.ORG_ID='6' 4/10/2024 1:20:26 PM: select e.EMPLOYEENUMBER from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='shafiq_rehman' and e.ORG_ID='6' 4/10/2024 1:20:26 PM: select e.EMPLOYEENUMBER from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='shafiq_rehman' and e.ORG_ID='6' 4/10/2024 1:20:26 PM: select to_char(sysdate,'dd/mm/yyyy hh24:mi:ss') from dual 4/10/2024 1:20:26 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='shafiq_rehman' 4/10/2024 1:20:26 PM: select APPLICATION_ID from SM_APPLICATION_USER_MAPPING_T where USERID= :USERID order by APPLICATION_ID params: USERID=441 4/10/2024 1:20:26 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=shafiq_rehman 4/10/2024 1:20:26 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=441, APPLICATION_ID2=23, USERID2=441, APPLICATION_ID3=23 4/10/2024 1:20:26 PM: select APPLICATION_DESC,BRANCH_REQUIRED from SM_APPLICATION_SETUPHD_T where APPLICATION_ID=:APPLICATION_ID params: APPLICATION_ID=23 4/10/2024 1:20:26 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=shafiq_rehman 4/10/2024 1:20:26 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=shafiq_rehman 4/10/2024 1:20:26 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/10/2024 1:20:27 PM: select * from SM_APPLICATION_SETUPHD_T where ACTIVE='1' order by APPLICATION_ID 4/10/2024 1:20:27 PM: select * from SM_APPLICATION_USER_MAPPING_T order by APPLICATION_ID,USERID 4/10/2024 1:20:27 PM: select a.ORG_ID from SM_USER_ORG_MAPPING_T a where upper(a.USERID) = :USERID params: USERID=SHAFIQ_REHMAN 4/10/2024 1:20:27 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=SHAFIQ_REHMAN, ORG_ID=6 4/10/2024 1:20:27 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 1:20:27 PM: Session Ended ...... 4/10/2024 1:20:27 PM: {} 4/10/2024 1:20:28 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=shafiq_rehman 4/10/2024 1:20:28 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=shafiq_rehman 4/10/2024 1:21:23 PM: Session Started ...... 4/10/2024 1:21:23 PM: {} 4/10/2024 1:21:23 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 1:21:23 PM: **************************** User shafiq_rehman Login Request..... **************************** 4/10/2024 1:21:23 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME=shafiq_rehman 4/10/2024 1:21:23 PM: select nvl(max(SERIAL_NO),0)+1 from SM_USER_LOGIN_HIST_T 4/10/2024 1:21:23 PM: select to_char(sysdate,'dd/mm/yyyy hh24:mi:ss') from dual 4/10/2024 1:21:23 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=3102, USERNAME=shafiq_rehman, PASSWORD=bd5INfrXOzrk1bkqcus+MyaCdhIttnUomZHBe/Z4zWE5GoeoJpx17pAC9josB7cp4bmT9n2TADYjHs98V8hPPnUqNBmIC50M4LLhWRLiSuqy/tvWNinGc2lQg4cC+yw6, IP_ADDRESS=182.191.151.252, OTHER_INFO=Chrome103-103.0-Unknown, STATUS_TAG=E, STATUS_MESSAGE=Invalid Credentials, CREATION_DATE=4/11/2024 1:21:22 AM 4/10/2024 1:21:23 PM: **************************** Error at Login Request for User shafiq_rehman, Message: Invalid Credentials **************************** 4/10/2024 1:21:23 PM: update SM_USERS_T set LOGIN_ATTEMPTS=nvl(LOGIN_ATTEMPTS,0)+1 where upper(USERNAME) = upper(:USERNAME) params: USERNAME=shafiq_rehman 4/10/2024 1:21:23 PM: select * from SM_APPLICATION_SETUP_T 4/10/2024 1:21:23 PM: select LOGIN_ATTEMPTS from SM_USERS_T where upper(USERNAME) = upper(:USERNAME) params: USERNAME=shafiq_rehman 4/10/2024 1:21:24 PM: select * from SM_APPLICATION_SETUP_T 4/10/2024 1:21:24 PM: select * from SM_APPLICATION_SETUP_T 4/10/2024 1:21:52 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 1:21:52 PM: **************************** User shafiq_rehman Login Request..... **************************** 4/10/2024 1:21:52 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME=shafiq_rehman 4/10/2024 1:21:52 PM: ************* Deleting Un-Used Tokens.. For User: shafiq_rehman ************* 4/10/2024 1:21:52 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME=shafiq_rehman 4/10/2024 1:21:52 PM: delete from SM_EMAIL_TOKENS_T where USERID=:USERID and nvl(TOKEN_USED,'N') = :TOKEN_USED params: USERID=441, TOKEN_USED=N 4/10/2024 1:21:52 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=shafiq_rehman 4/10/2024 1:21:52 PM: select * from SM_APPLICATION_SETUP_T 4/10/2024 1:21:52 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=shafiq_rehman 4/10/2024 1:21:52 PM: select nvl(max(SERIAL_NO),0)+1 from SM_USER_LOGIN_HIST_T 4/10/2024 1:21:52 PM: select to_char(sysdate,'dd/mm/yyyy hh24:mi:ss') from dual 4/10/2024 1:21:52 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=3103, USERNAME=shafiq_rehman, PASSWORD=aLCuiNqQVykgGBcdcnmwNOGIiP89JZRlbL5S3fZQz4uX+oR/aRQnFpatYkedsZw2y/rboVuuawm+bTOckapVrkqJi7ACI8qqPpH114KiY/3Y5gf4GymEPnop1LcWS3P+, IP_ADDRESS=182.191.151.252, OTHER_INFO=Chrome103-103.0-Unknown, STATUS_TAG=S, STATUS_MESSAGE=success, CREATION_DATE=4/11/2024 1:21:51 AM 4/10/2024 1:21:52 PM: update SM_USERS_T set LOGIN_ATTEMPTS=0 where upper(USERNAME) = upper(:USERNAME) params: USERNAME=shafiq_rehman 4/10/2024 1:21:52 PM: update SM_USERS_T set LAST_LOGIN=sysdate where upper(USERNAME) = upper(:USERNAME) params: USERNAME=shafiq_rehman 4/10/2024 1:21:52 PM: **************************** User shafiq_rehman Logged in Successfully.. **************************** 4/10/2024 1:21:52 PM: select RELEASE_VERSION from SM_RELEASE_INFO_T order by SERIAL_NO desc 4/10/2024 1:21:52 PM: select to_char(CREATION_DATE,'dd/mm/yyyy') CREATION_DATE from SM_USERS_T where upper(USERID)=upper(:USERID) params: USERID=441 4/10/2024 1:21:52 PM: select APPLICATION_ID from SM_APPLICATION_USER_MAPPING_T where USERID=:USERID order by APPLICATION_ID params: USERID=441 4/10/2024 1:21:52 PM: select ORG_ID from SM_USER_ORG_MAPPING_T b where upper(USERID) = upper(:USERID) params: USERID=shafiq_rehman 4/10/2024 1:21:52 PM: select * from SM_USERS_T where USERID=:USERID params: USERID=441 4/10/2024 1:21:52 PM: Request.IsSecureConnection True 4/10/2024 1:21:52 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=shafiq_rehman 4/10/2024 1:21:53 PM: sid 3apqobwl24ytgfvzdkrqlamx 4/10/2024 1:21:53 PM: sid fd6d3d8d-fc52-48a1-8c77-e01da99ffb62 4/10/2024 1:21:53 PM: sid ZealERP.ZealSecurity.Models.NewSecurity.User 4/10/2024 1:21:53 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME= 4/10/2024 1:21:53 PM: select * from SM_USERS_T where USERID=:USERID params: USERID=441 4/10/2024 1:21:54 PM: ************* Deleting Un-Used Tokens.. For User: ************* 4/10/2024 1:21:54 PM: select * from SM_USERS_T where upper(USERNAME)= upper(:USERNAME) params: USERNAME= 4/10/2024 1:21:54 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=shafiq_rehman 4/10/2024 1:21:54 PM: select * from SM_APPLICATION_SETUP_T 4/10/2024 1:21:54 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=shafiq_rehman 4/10/2024 1:21:54 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=shafiq_rehman 4/10/2024 1:21:54 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='shafiq_rehman' and e.ORG_ID='6' 4/10/2024 1:21:54 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='shafiq_rehman' and e.ORG_ID='6' 4/10/2024 1:21:54 PM: select e.EMPLOYEENUMBER from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='shafiq_rehman' and e.ORG_ID='6' 4/10/2024 1:21:54 PM: select e.EMPLOYEENUMBER from employee e ,sm_users_t u where u.email=e.OFFICIALEMAIL and u.USERNAME='shafiq_rehman' and e.ORG_ID='6' 4/10/2024 1:21:54 PM: select to_char(sysdate,'dd/mm/yyyy hh24:mi:ss') from dual 4/10/2024 1:21:54 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='shafiq_rehman' 4/10/2024 1:21:54 PM: select APPLICATION_ID from SM_APPLICATION_USER_MAPPING_T where USERID= :USERID order by APPLICATION_ID params: USERID=441 4/10/2024 1:21:54 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=shafiq_rehman 4/10/2024 1:21:54 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=441, APPLICATION_ID2=23, USERID2=441, APPLICATION_ID3=23 4/10/2024 1:21:54 PM: select APPLICATION_DESC,BRANCH_REQUIRED from SM_APPLICATION_SETUPHD_T where APPLICATION_ID=:APPLICATION_ID params: APPLICATION_ID=23 4/10/2024 1:21:54 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=shafiq_rehman 4/10/2024 1:21:54 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=441, APPLICATION_ID=23, USERID2=441, APPLICATION_ID2=23 4/10/2024 1:21:54 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=441, APPLICATION_ID2=23 4/10/2024 1:21:54 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=441, APPLICATION_ID2=23 4/10/2024 1:21:54 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=shafiq_rehman 4/10/2024 1:21:54 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/10/2024 1:21:55 PM: select * from SM_APPLICATION_SETUPHD_T where ACTIVE='1' order by APPLICATION_ID 4/10/2024 1:21:55 PM: select * from SM_APPLICATION_USER_MAPPING_T order by APPLICATION_ID,USERID 4/10/2024 1:21:55 PM: select a.ORG_ID from SM_USER_ORG_MAPPING_T a where upper(a.USERID) = :USERID params: USERID=SHAFIQ_REHMAN 4/10/2024 1:21:55 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=SHAFIQ_REHMAN, ORG_ID=6 4/10/2024 1:21:57 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=shafiq_rehman 4/10/2024 1:21:57 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=shafiq_rehman 4/10/2024 1:22:08 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 1:22:08 PM: Session Ended ...... 4/10/2024 1:22:08 PM: {} 4/10/2024 1:22:08 PM: select * from SM_APPLICATION_SETUP_T 4/10/2024 1:22:08 PM: select * from SM_APPLICATION_SETUP_T 4/10/2024 1:22:12 PM: select * from SM_APPLICATION_SETUPHD_T where ACTIVE='1' order by APPLICATION_ID 4/10/2024 1:22:12 PM: select * from SM_APPLICATION_USER_MAPPING_T order by APPLICATION_ID,USERID 4/10/2024 1:22:12 PM: select a.ORG_ID from SM_USER_ORG_MAPPING_T a where upper(a.USERID) = :USERID params: USERID=SHAFIQ_REHMAN 4/10/2024 1:22:12 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=SHAFIQ_REHMAN, ORG_ID=6 4/10/2024 1:22:13 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=shafiq_rehman 4/10/2024 1:22:13 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=shafiq_rehman 4/10/2024 1:38:27 PM: Session Ended ...... 4/10/2024 1:38:27 PM: {} 4/10/2024 2:05:48 PM: Session Started ...... 4/10/2024 2:05:48 PM: {} 4/10/2024 2:06:25 PM: Session Started ...... 4/10/2024 2:06:25 PM: {} 4/10/2024 4:53:33 PM: Session Started ...... 4/10/2024 4:53:33 PM: {} 4/10/2024 4:53:34 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 4:53:34 PM: Session Ended ...... 4/10/2024 4:53:34 PM: {} 4/10/2024 5:30:55 PM: Session Started ...... 4/10/2024 5:30:55 PM: {} 4/10/2024 5:51:14 PM: Session Ended ...... 4/10/2024 5:51:14 PM: {} 4/10/2024 5:54:41 PM: Session Started ...... 4/10/2024 5:54:41 PM: {} 4/10/2024 5:54:41 PM: SELECT IDHT.PARTNER_ID,APT.PARTNER_NAME,IDHT.PARTNER_BRANCH_ID,APBT.PARTNER_BRANCH_NAME,IDHT.CHANNEL_ID,ADC.CHANNEL_NAME,IDHT.MODEL_ID,ACMT.MODEL_NAME,IDHT.DOCUMENT_TYPE, nvl(COUNT(CASE WHEN IDHT.DOCUMENT_TYPE='Q' THEN IDHT.DOCUMENT_TYPE END),0) AS SUBMISSION_COUNT, nvl(CASE WHEN IDHT.DOCUMENT_TYPE='Q'THEN SUM(IDHT.BASIC_CONTRIBUTION) END,0) AS SUBMISSION_AMOUNT, nvl(COUNT(CASE WHEN IDHT.POSTING_TAG='Y'THEN IDHT.POSTING_TAG END),0) AS ISSUANCE_COUNT, nvl(SUM(CASE WHEN IDHT.POSTING_TAG='Y' THEN IDHT.BASIC_CONTRIBUTION END),0) AS ISSUANCE_AMOUNT, nvl(COUNT(CASE WHEN IDHT.CANCEL_TAG='Y' THEN IDHT.CANCEL_TAG END),0) AS CANCELLATION_COUNT, nvl(SUM(CASE WHEN IDHT.CANCEL_TAG='Y' THEN IDHT.BASIC_CONTRIBUTION END),0) AS CANCELLATION_AMOUNT, nvl(COUNT(CASE WHEN IDHT.LOCK_TAG='Y' AND IDHT.POSTING_TAG IS NULL THEN IDHT.LOCK_TAG END),0) AS PENDING_COUNT, nvl(SUM(CASE WHEN IDHT.LOCK_TAG='Y' AND IDHT.POSTING_TAG IS NULL THEN IDHT.BASIC_CONTRIBUTION END),0) AS PENDING_AMOUNT FROM IL_DOC_HEADER_T IDHT LEFT JOIN AM_AGENT_T AGT ON IDHT.AGENT_ID=AGT.AGENT_ID AND IDHT.ORG_ID=AGT.ORG_ID LEFT JOIN AM_PARTNER_T APT ON IDHT.PARTNER_ID=APT.PARTNER_ID AND IDHT.ORG_ID=APT.ORG_ID LEFT JOIN AM_DISTRIBUTION_CHANNEL_T ADC ON IDHT.CHANNEL_ID=ADC.CHANNEL_ID AND IDHT.ORG_ID=ADC.ORG_ID LEFT JOIN AM_CHANNEL_MODEL_T ACMT ON IDHT.MODEL_ID=ACMT.MODEL_ID AND IDHT.CHANNEL_ID=ACMT.CHANNEL_ID AND IDHT.ORG_ID=ACMT.ORG_ID LEFT JOIN AM_PARTNER_BRANCHES_T APBT ON IDHT.PARTNER_BRANCH_ID=APBT.PARTNER_BRANCH_ID AND IDHT.ORG_ID = APBT.ORG_ID AND IDHT.PARTNER_ID = APBT.PARTNER_ID GROUP BY IDHT.PARTNER_ID,IDHT.PARTNER_BRANCH_ID,IDHT.MODEL_ID,IDHT.CHANNEL_ID,IDHT.DOCUMENT_TYPE,APT.PARTNER_NAME,ACMT.MODEL_NAME,ADC.CHANNEL_NAME,IDHT.ORG_ID,APBT.PARTNER_BRANCH_NAME params: ORG_ID=0, BRANCH_ID=0, MAIN_PRODUCT_CODE=0, SUB_PRODUCT_CODE=0, TAKAFUL_TYPE=, DOCUMENT_TYPE=, DOCUMENT_NO=, RECORD_TYPE=, DOCUMENT_YEAR=, ISSUE_COUNT=, ENDORSEMENT_NO=, APPLICATION_ID= 4/10/2024 6:05:41 PM: Session Started ...... 4/10/2024 6:05:41 PM: {} 4/10/2024 6:05:53 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 6:05:53 PM: Session Ended ...... 4/10/2024 6:05:53 PM: {} 4/10/2024 6:14:54 PM: Session Ended ...... 4/10/2024 6:14:54 PM: {} 4/10/2024 6:17:32 PM: Session Started ...... 4/10/2024 6:17:32 PM: {} 4/10/2024 6:17:34 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 6:17:34 PM: Session Ended ...... 4/10/2024 6:17:34 PM: {} 4/10/2024 8:39:35 PM: Session Started ...... 4/10/2024 8:39:35 PM: {} 4/10/2024 8:39:35 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 8:39:35 PM: Session Ended ...... 4/10/2024 8:39:35 PM: {} 4/10/2024 8:42:41 PM: Session Started ...... 4/10/2024 8:42:41 PM: {} 4/10/2024 8:42:41 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 8:42:41 PM: Session Ended ...... 4/10/2024 8:42:41 PM: {} 4/10/2024 9:52:43 PM: Session Started ...... 4/10/2024 9:52:43 PM: {} 4/10/2024 9:52:43 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 9:52:43 PM: Session Ended ...... 4/10/2024 9:52:43 PM: {} 4/10/2024 9:55:58 PM: Session Started ...... 4/10/2024 9:55:58 PM: {} 4/10/2024 9:55:58 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 9:55:58 PM: Session Ended ...... 4/10/2024 9:55:58 PM: {} 4/10/2024 10:48:35 PM: Session Started ...... 4/10/2024 10:48:35 PM: {} 4/10/2024 10:48:36 PM: select CONFIG_VALUE from SM_APPLICATION_CONFIG_T WHERE CONFIG_NAME=:CONFIG_NAME params: CONFIG_NAME=CAPTCHA_ENABLED 4/10/2024 10:48:36 PM: Session Ended ...... 4/10/2024 10:48:36 PM: {}