| SQL Id | SQL Text |
|---|
| 06rmtc5pcycvt | INSERT INTO CH_RD_INT_BREAKUP_TABLE (COD_ACCT_NO, BAL_BASE, EFF_RAT_INT, DAT_FROM, DAT_TO, AMT_INT, CTR_NUM_DAYS, AMT_TAX, FLG_INT_TYP) VALUES ((:B9 ).COD_ACCT_NO(), :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 ) |
| 0941b3ngftpdd | SELECT inventory_code as "InventoryCode" , inventory_no as "InventoryNo" , card_passbook_no as "AllInOnePassBook" , cod_chnl_id as "CodChannelID" , flg_stmt_display as "FlgStmtDisplay" FROM xface_addl_details_txnlog WHERE ref_txn_no = CAST(:1 AS CHAR(40)) |
| 0b0spdxshanxk | SELECT DISTINCT COD_LAST_MNT_MAKERID, COD_LAST_MNT_CHKRID FROM CYTM_RATES WHERE CCY1 = :B2 AND CCY2= :B1 AND FLG_MNT_STATUS = 'A' AND DAT_LAST_MNT=(SELECT MAX(DAT_LAST_MNT) FROM CYTM_RATES WHERE CCY1 = :B2 AND CCY2 = :B1 AND FLG_MNT_STATUS = 'A') |
| 0cpwzbwc8dcbv | select transactio0_.REF_TXN_NO as REF1_117_0_, transactio0_.DAT_POST as DAT2_117_0_, transactio0_.DAT_LOG as DAT3_117_0_, transactio0_.ref_txn_no as ref1_117_0_, transactio0_.ref_usr_no as ref4_117_0_, transactio0_.DAT_TXN as DAT5_117_0_, transactio0_.REF_SYS_TR_AUD_NO as REF6_117_0_, transactio0_.CTR_BATCH_NO as CTR7_117_0_, transactio0_.COD_MSG_TYP as COD8_117_0_, transactio0_.cod_user_id as cod9_117_0_, transactio0_.SUB_SEQ_NO as SUB10_117_0_, transactio0_.COD_ORG_BRN as COD11_117_0_, transactio0_.COD_ORG_BANK as COD12_117_0_, transactio0_.cod_auth_id as cod13_117_0_, transactio0_.ref_org_txn_no as ref14_117_0_, transactio0_.channel_id as channel15_117_0_, 'A' as formula0_0_, 'A' as formula1_0_, 'A' as formula2_0_ from xf_ol_st_ext_txn_xref transactio0_ where transactio0_.REF_TXN_NO=:1 |
| 0h51sv3amtg1w | SELECT BAL_AVAILABLE, DAT_ACCT_OPEN, COD_CC_BRN, COD_PROD, COD_CCY FROM CH_ACCT_MAST WHERE COD_ACCT_NO = :B1 AND FLG_MNT_STATUS = 'A' |
| 0h6fzmdrypj45 | SELECT AB.*, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.cod_fcr_hold_no ELSE NULL END FCR_UNHOLD_NO , CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Notice_No ELSE NULL END UNHOLD_COD_NOTICE_NO, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.DAT_POSTING ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN AB.DAT_HOLD_STATUS ELSE NULL END END DAT_UNHOLD_ACTION, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN to_char(auditlogs2.Dat_ACTION, 'HH24:MI:SS') ELSE NULL END UNHOLD_TIME, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Reason ELSE NULL END UNHOLD_HOLD_AUTH, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Last_Mnt_Makerid ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN 'SYSTEM' ELSE NULL END END UNHOLD_MAKER, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Last_Mnt_Chkrid ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN 'SYSTEM' ELSE NULL END END UNHOLD_CHECKER, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Txt_Narrative ELSE NULL END UNHOLD_NARR, CASE WHEN(auditlogs2.cod_action =1 AND cod_hold_status = 3) THEN auditlogs2.COD_PREV_NOTICE_NO ELSE NULL END prev_notice_no FROM (Select * from temp_holdunhold_inq1 tmp WHERE 1 = 1 AND (cod_hold_status = (case when cod_hold_typ = 3 then cod_hold_status else 0 end) or cod_hold_status = (case when cod_hold_typ = 3 then cod_hold_status else 1 end)) AND COD_HOLD_TYP = 3 AND COD_CC_BRN_TXN = 265 ) AB LEFT JOIN ba_hold_audit_log auditlogs2 ON (AB.cod_fcr_hold_no = auditlogs2.Cod_Fcr_Hold_No AND AB.COD_NOTICE_NO = auditlogs2.cod_notice_no AND AB.cod_mc_acct_no = auditlogs2.cod_mc_acct_no) |
| 0mxt2nxpq0tzv | SELECT --+ PARALLEL(8) A.COD_CUST, C.COD_MC_ACCT_NO, A.COD_ACCT_NO, A.COD_ACCT_TITLE, (CASE WHEN A.BAL_AVAILABLE >= 0 THEN 'C' ELSE 'D' END) COD_DRCR, A.COD_CCY, ABS(A.BAL_AVAILABLE) BAL, (SELECT MAX((TO_CHAR(N.DAT_VALUE, 'yyyymmdd'))) FROM CH_NOBOOK N WHERE N.COD_ACCT_NO = A.COD_ACCT_NO AND N.COD_DRCR = 'D'), (SELECT MAX((TO_CHAR(N.DAT_VALUE, 'yyyymmdd'))) FROM CH_NOBOOK N WHERE N.COD_ACCT_NO = A.COD_ACCT_NO AND N.COD_DRCR = 'C'), '00', A.COD_PROD FROM CH_ACCT_MAST A, MC_ACCT_XREF C WHERE A.COD_CC_BRN = :B2 AND A.COD_PROD = :B1 AND A.COD_ACCT_NO = C.COD_ACCT_NO AND A.FLG_MNT_STATUS = 'A' AND C.FLG_MNT_STATUS = 'A' |
| 0njs34w88tsms | SELECT --+PARALLEL(4) B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, SUM(A.AMT_TXN_HOST), COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host FROM CH_ST_CAP_INPUT_TXN_MMDD A, CH_PROD_MAST B WHERE DAT_POST = TO_DATE('21-03-2013', 'DD-MM-YYYY') AND A.COD_PROD_HOST = B.COD_PROD AND A.COD_DRCR_DEST = 'C' AND COD_CCY_HOST = '156' AND B.COD_GL_INT_PAYABLE = '26003' AND a.cod_cc_brn_host = '850' GROUP BY B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host ORDER BY B.COD_GL_INT_PAYABLE, COD_CCY_HOST, COD_CC_BRN_HOST, A.COD_PROD_HOST |
| 0p7nttkrn81z0 | SELECT NVL(AMT_LIM_IB_WITHDRAW, 0) FROM CH_DAILY_IB_WITHDRAW_LIM_UTIL WHERE COD_ACCT_NO = :B2 AND DAT_PROCESS = :B1 |
| 0w29h9wwn0wu5 | SELECT RAT_CCY_MID, RAT_CCY_BOOK, RAT_CCY_CB, RAT_CCY_SPECIAL_1, RAT_CCY_SPECIAL_2, RAT_NOTE_BUY_SPRD, RAT_NOTE_SELL_SPRD, RAT_CHQ_BUY_SPRD, RAT_CHQ_SELL_SPRD, RAT_XFER_BUY_SPRD, RAT_XFER_SELL_SPRD FROM BA_CCY_RATE WHERE COD_CCY = :B3 AND COD_LCY = :B2 AND DAT_TIM_RATE_EFF <= :B1 AND FLG_MNT_STATUS = 'A' ORDER BY DAT_TIM_RATE_EFF DESC |
| 0yrazz6wy6d3z | DECLARE BEGIN :1 := PK_MCA_OPERATION.OPEN_MCA(:2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 ) ; END; |
| 0yv4wbwns3cya |
INSERT INTO XFACE_TEMP_ACCT_TRANS_INQ (AMOUNT, COD_ACCT_NO, COD_BRANCH, COD_AUTH_ID, COD_USER_ID, COD_TASK_DERIVED, DAT_POST, DAT_TXN, FLG_DR_CR, IS_NXT_PAGE, REF_TXN_NO, TXT_TXN_NARRATIVE, SESSION_ID, ROW_NUM, REF_USR_NO, COD_TXN_MNEMONIC, RUNNING_BALANCE, OTHER_ACCT, OTHER_BRN_NAM, OTHER_ACCT_TITLE, SEQ_NO, TRANSACTION_LITERAL, INVENTORY_CODE, INVENTORY_NO, BANK_INFORMATION_NO, REF_KEY_NO, COD_SERVICE_ID, COD_MSG_TYP, FLG_ONLINE_UPLOAD, FLG_CA_TT, COD_TXN_LITERAL, COD_EXT_TASK, FLG_STMT_DISPLAY, TXT_TXN_DESC, COD_MC_ACCT_NO, COD_CC_BRN_OTHR_ACCT, NOBK_COD_USERNO, COD_DEP_NO, COD_PASSBK_LITERAL, RENEW_TYPE, COD_CHNL_ID) SELECT AMOUNT, COD_ACCT_NO, COD_BRANCH, COD_AUTH_ID, COD_USER_ID, COD_TASK_DERIVED, DAT_POST, DAT_TXN, FLG_DR_CR, IS_NXT_PAGE, REF_TXN_NO, TXT_TXN_NARRATIVE, SESSION_ID, ROWNUM, REF_USR_NO, COD_TXN_MNEMONIC, RUNNING_BALANCE, OTHER_ACCT, OTHER_BRN_NAM, OTHER_ACCT_TITLE, SEQ_NO, TRANSACTION_LITERAL, INVENTORY_CODE, INVENTORY_NO, BANK_INFORMATION_NO, REF_KEY_NO, COD_SERVICE_ID, COD_MSG_TYP, FLG_ONLINE_UPLOAD, FLG_CA_TT, COD_TXN_LITERAL, COD_EXT_TASK, FLG_STMT_DISPLAY, TXT_TXN_DESC, COD_MC_ACCT_NO, COD_CC_BRN_OTHR_ACCT, NOBK_COD_USERNO, COD_DEP_NO, COD_PASSBK_LITERAL, RENEW_TYPE, COD_CHNL_ID FROM (SELECT (CASE WHEN NVL(RENEW_TYPE, ' ') IN ('PO', 'LI') AND C.COD_PASSBK_LITERAL = 'RENEW_REINVEST_PAYIN' THEN 0 WHEN C.COD_DEP_NO > 1 AND BAL_INT_PAID = 0 AND C.COD_PASSBK_LITERAL = 'RENEW_REINVEST_PAYIN' THEN ((SELECT TDMI.BAL_INT_PAID - AMT_TAX - AMT_INT_RECOVERED FROM TD_DEP_MAST TDMI WHERE TDMI.COD_DEP_NO = (C.COD_DEP_NO - 1) AND TDMI.FLG_MNT_STATUS = 'A' AND TDMI.COD_ACCT_NO = C.COD_ACCT_NO)) WHEN C.COD_DEP_NO > 1 AND C.COD_PASSBK_LITERAL = 'RENEW_REINVEST_PAYIN' THEN (SELECT TDMI.BAL_INT_PAID - AMT_TAX - AMT_INT_RECOVERED FROM TD_DEP_MAST TDMI WHERE TDMI.COD_DEP_NO = (C.COD_DEP_NO - 1) AND TDMI.FLG_MNT_STATUS = 'A' AND TDMI.COD_ACCT_NO = C.COD_ACCT_NO) ELSE AMT_TXN - (AMT_INT - AMT_TAX - AMT_INT_RECOVERED) END) AMOUNT, BAL_FOR_RATE_EARNED, BAL_INT_PAID, AMT_TAX, :B4 AS COD_ACCT_NO, C.COD_CC_BRN_TXN AS COD_BRANCH, NVL(T.COD_AUTH_ID, C.COD_AUTH_ID) AS COD_AUTH_ID, T.COD_USER_ID AS COD_USER_ID, DECODE(T.REF_TXN_NO_ORG, NULL, T.COD_EXT_TASK, T.COD_EXT_TASK_REV) AS COD_TASK_DERIVED, C.DAT_POST AS DAT_POST, C.DAT_TXN AS DAT_TXN, C.COD_DRCR AS FLG_DR_CR, NVL(T.FLG_STMT_DISPLAY, 'Y') AS IS_NXT_PAGE, C.REF_TXN_NO AS REF_TXN_NO, TXT_TXN_NARRATIVE, :B5 AS SESSION_ID, ROWNUM AS ROW_NUM, C.REF_USR_NO AS REF_USR_NO, C.COD_TXN_MNEMONIC AS COD_TXN_MNEMONIC, :B6 AS RUNNING_BALANCE, T.COD_OTHER_ACCT_NO AS OTHER_ACCT, '' AS OTHER_BRN_NAM, '' AS OTHER_ACCT_TITLE, 0 AS SEQ_NO, '' AS TRANSACTION_LITERAL, T.INVENTORY_CODE AS INVENTORY_CODE, (CASE WHEN T.INVENTORY_NO IS NULL THEN (CASE WHEN T.CHEQUE_NO IS NULL THEN (CASE WHEN T.CARD_NO IS NULL THEN T.CARD_PASSBOOK_NO ELSE T.CARD_NO END) ELSE T.CHEQUE_NO END) ELSE T.INVENTORY_NO END) AS INVENTORY_NO, T.BANK_INFORMATION_NO AS BANK_INFORMATION_NO, T.REF_KEY_NO AS REF_KEY_NO, T.COD_SERVICE_ID, C.COD_MSG_TYP, T.FLG_ONLINE_UPLOAD, T.FLG_CA_TT, C.COD_TXN_LITERAL, T.COD_EXT_TASK, T.FLG_STMT_DISPLAY, C.TXT_TXN_DESC, :B1 AS COD_MC_ACCT_NO, T.COD_CC_BRN_OTHR_ACCT, C.COD_USERNO AS NOBK_COD_USERNO, C.COD_DEP_NO AS COD_DEP_NO, C.COD_PASSBK_LITERAL, RENEW_TYPE, T.COD_CHNL_ID FROM (SELECT /*+index(tdn in_td_nobook_2)*/ TDN.AMT_TXN_TCY AS AMT_TXN, TDN.COD_CC_BRN_TXN, TDN.COD_AUTH_ID, TDN.COD_USERNO, TDN.COD_DEP_NO, TDN.CTR_BATCH_NO, TDN.REF_SYS_TR_AUD_NO, TDN.REF_SUB_SEQ_NO, TDN.DAT_TXN, TDN.COD_DRCR AS FLG_DR_CR, TDN.REF_TXN_NO AS REF_TXN_NO, TDN.COD_TXN_MNEMONIC, TDN.COD_PASSBK_LITERAL, TDN.TXT_TXN_DESC, TDN.REF_USR_NO, TDN.DAT_POST, TDN.COD_BANK_LITERAL, TDN.COD_DRCR, TDN.COD_ACCT_NO, TDN.COD_MSG_TYP, SUB.RENEW_TYPE, (SUM(DECODE(TDN.COD_PASSBK_LITERAL, 'PRM_INT_PAID_DEDUCT', AMT_TXN_ACY, 0)) OVER(PARTITION BY REF_TXN_NO)) AMT_INT_RECOVERED, (SUM
(DECODE(TDN.COD_PASSBK_LITERAL, 'REN_PEND_INT', AMT_TXN_ACY, 'PRM_PEND_INT', AMT_TXN_ACY, 'PRM_PENALTY_INT', AMT_TXN_ACY, 'INT_PAYABLE', AMT_TXN_ACY, 'POST_RED_PMI_CR', AMT_TXN_ACY, 'SWP_PRE_RED_INT', AMT_TXN_ACY, 'POST_RED_PEND_INT', AMT_TXN_ACY, 0)) OVER(PARTITION BY REF_TXN_NO)) AMT_INT, (SUM(DECODE(TDN.COD_PASSBK_LITERAL, 'TAX_COMP_TOTAL', AMT_TXN_ACY, 'SWP_TOTAL_TAX', AMT_TXN_ACY, 'POST_RED_PMI_TOT_TAX', AMT_TXN_ACY, 'PRM_TOTAL_TAX', AMT_TXN_ACY, 'RTX_TOT_ADDL_TAX', AMT_TXN_ACY, 'INT_PAYABLE_TAX', AMT_TXN_ACY, 'TAX_RECOVERED', AMT_TXN_ACY, 0)) OVER(PARTITION BY REF_TXN_NO)) AMT_TAX, TDM.BAL_FOR_RATE_EARNED AS BAL_FOR_RATE_EARNED, TDM.BAL_INT_PAID AS BAL_INT_PAID, TDN.COD_TXN_LITERAL FROM TD_NOBOOK TDN, TD_DEP_MAST TDM, XFACE_SUB_ACCT_ADDNL_DTLS SUB WHERE TDN.COD_ACCT_NO = :B4 AND TDM.COD_ACCT_NO = :B4 AND TDM.FLG_MNT_STATUS = 'A' AND TDM.COD_DEP_NO = TDN.COD_DEP_NO AND TDN.COD_BANK_LITERAL <> 'SPL' AND TDN.COD_ORG_DEP_NO <> 0 AND TDN.DAT_POST BETWEEN :B3 AND :B2 AND SUB.COD_ACCT_NO = TDN.COD_ACCT_NO AND SUB.COD_DEP_NO = TDN.COD_DEP_NO AND SUB.COD_MC_ACCT_NO = :B1 ORDER BY TDN.COD_PSBK_LINE_NO) C, XFACE_ADDL_DTLS_TLOG_TEMP T WHERE C.COD_ACCT_NO = :B4 AND C.COD_ACCT_NO = T.COD_SUB_ACCT_NO(+) AND C.REF_TXN_NO = T.REF_TXN_NO(+) AND TRIM(TO_CHAR(C.CTR_BATCH_NO)) || '~' || TRIM(TO_CHAR(C.REF_SYS_TR_AUD_NO)) || '~' || TRIM(TO_CHAR(C.REF_SUB_SEQ_NO)) = T.REF_KEY_NO(+) AND C.COD_DRCR IS NOT NULL AND C.COD_PASSBK_LITERAL IN (SELECT COD_PASSBK_LITERAL FROM TD_TXNLIT_MNEM_XREF WHERE CTR_TXN_LEG = 0 OR (CTR_TXN_LEG != 0 AND CTR_GRP_NO NOT IN (SELECT CTR_GRP_NO FROM TD_TXNLIT_MNEM_XREF WHERE CTR_TXN_LEG = 0))) AND ((C.COD_BANK_LITERAL = 'TDP' AND C.COD_PASSBK_LITERAL = 'NET_TD_PAYIN') OR (C.COD_PASSBK_LITERAL NOT IN ('INT_COMP', 'NET_TD_PAYIN', 'BAT_MAT_PAY_TD_ACCT', 'SPL', 'INT_PAID_BAT_XFER_SB', 'INT_PAYABLE'))) AND C.COD_TXN_MNEMONIC NOT IN (1358, 3113, 3203, 1331, 1328, 1317) AND T.SESSIONID(+) = :B5 ORDER BY C.DAT_TXN, C.COD_DEP_NO, C.COD_USERNO, C.CTR_BATCH_NO, C.REF_SYS_TR_AUD_NO DESC, C.REF_SUB_SEQ_NO) B |
| 0z1r1cqbhmpn6 | update ET_ALERTS_LOG set COD_SERVICE_ID=:1 , DAT_ALERT=:2 , TXT_ALERT_DATA=:3 , FLG_ALERT_STATUS=:4 , COD_ALERT_PRIORITY=:5 , FLG_MSG_TYPE=:6 , REF_SYS_NO=:7 , REF_USR_NO=:8 , REF_TXN_NO=:9 where COD_ALERT_UID=:10 |
| 13hfxx0zygb2u | SELECT A.COD_STOCK_STAT FROM IV_STOCK_STATUS A WHERE A.COD_BANK = :B3 AND A.COD_STOCK = :B2 AND A.COD_STOCK_NO = :B1 |
| 15h6cugpdqyc8 | BEGIN :1 := FCR44HOST.PK_XFACE_AUDIT_TRAIL.AT_REAL_TIME_GL_TXN_INQ(:2 , :3 , :4 , :5 , :6 , :7 ); END; |
| 1dsq1wq33h322 |
select currentand0_.COD_ACCT_NO as COD1_187_0_, currentand0_.FLG_MNT_STATUS as FLG2_187_0_, currentand0_.flg_grace_period as flg3_187_0_, currentand0_.cod_last_mnt_chkrid as cod4_187_0_, currentand0_.cod_last_mnt_makerid as cod5_187_0_, currentand0_.dat_last_mnt as dat6_187_0_, currentand0_.ctr_updat_srlno as ctr7_187_0_, currentand0_.cod_mnt_action as cod8_187_0_, currentand0_.DAT_ACCT_OPEN as DAT9_187_0_, currentand0_.COD_LANG as COD10_187_0_, currentand0_.COD_CUST as COD11_187_0_, currentand0_.cod_prod as cod12_187_0_, currentand0_.cod_ccy as cod13_187_0_, currentand0_.fk_ccy_status as fk14_187_0_, currentand0_.COD_OFFICR_ID as COD15_187_0_, currentand0_.COD_CC_BRN as COD16_187_0_, currentand0_.fk_brn_status as fk17_187_0_, currentand0_.flg_rat_change_advice as flg18_187_0_, currentand0_.Rat_change_advice_lead_days as Rat19_187_0_, currentand0_.FLG_REST_ACCT as FLG20_187_0_, currentand0_.FLG_EMP_ACCT as FLG21_187_0_, currentand0_.NAM_NOMINEE as NAM22_187_0_, currentand0_.FLG_PSBOOK as FLG23_187_0_, currentand0_.FLG_SC_WAIVER as FLG24_187_0_, currentand0_.FLG_MEMO as FLG25_187_0_, currentand0_.AMT_EXEMPT_LIMIT_2 as AMT26_187_0_, currentand0_.COD_TDS_2 as COD27_187_0_, currentand0_.FLG_TDS as FLG28_187_0_, currentand0_.AMT_EXEMPT_LIMIT as AMT29_187_0_, currentand0_.COD_TDS as COD30_187_0_, currentand0_.COD_ACCT_TITLE as COD31_187_0_, currentand0_.CTR_YTD_STMNT_NO as CTR32_187_0_, currentand0_.FLG_SPECIAL_STMNT as FLG33_187_0_, currentand0_.CTR_STMNT_COPIES as CTR34_187_0_, currentand0_.CTR_DAY_STMNT_GEN as CTR35_187_0_, currentand0_.CTR_INT_SC_XFER as CTR36_187_0_, currentand0_.cod_int_sc_acct_no as cod37_187_0_, currentand0_.ACCT_XFERED_FROM as ACCT38_187_0_, currentand0_.DAT_ST_UNCL_ADVNC as DAT39_187_0_, currentand0_.DAT_EXP_UNCLR_ADVNC as DAT40_187_0_, currentand0_.AMT_UNCLR as AMT41_187_0_, currentand0_.AMT_UNCLR_ADVNC_LIM as AMT42_187_0_, currentand0_.RAT_UNCLR_ADVNC_PCT as RAT43_187_0_, currentand0_.FLG_ACCR_STATUS as FLG44_187_0_, currentand0_.COD_ACCT_NO_GRP_INT as COD45_187_0_, currentand0_.COD_ACCT_NO_GRP_SC as COD46_187_0_, currentand0_.FLG_STATUS_CONVERSION as FLG47_187_0_, currentand0_.FLG_GRP_BONUS as FLG48_187_0_, currentand0_.FLG_INT_WAIVER as FLG49_187_0_, currentand0_.FLG_SWEEPIN as FLG50_187_0_, currentand0_.FLG_SC_WAIVER_CUST as FLG51_187_0_, currentand0_.BMP_SC_WAIVER as BMP52_187_0_, currentand0_.FLG_STATUS_RECALLED as FLG53_187_0_, currentand0_.FLG_SI as FLG54_187_0_, currentand0_.FLG_IDD_AUTH as FLG55_187_0_, currentand0_.FLG_ALLOW_DRWDWN as FLG56_187_0_, currentand0_.FLG_VAT as FLG57_187_0_, currentand0_.FLG_SWPOUT as FLG58_187_0_, currentand0_.FLG_STATUS_LEGAL as FLG59_187_0_, currentand0_.FLG_REMINDER_GEN as FLG60_187_0_, currentand0_.FLG_STATUS_SECURITIZED as FLG61_187_0_, currentand0_.FLG_DR_AUTH as FLG62_187_0_, currentand0_.FLG_INTEREST_FREEZE as FLG63_187_0_, currentand0_.FLG_JOINT_ACCT as FLG64_187_0_, currentand0_.FLG_ACCT_CLOSE as FLG65_187_0_, currentand0_.FLG_PDO_OVERRIDE as FLG66_187_0_, currentand0_.FLG_ADHOC_STMNT as FLG67_187_0_, currentand0_.FLG_DORM_SC as FLG68_187_0_, currentand0_.FLG_PAST_DUE_STATUS as FLG69_187_0_, currentand0_.FLG_REPL_CUBE as FLG70_187_0_, currentand0_.COD_LINE_NO as COD71_187_0_, currentand0_.FLG_ATM as FLG72_187_0_, currentand0_.CTR_NUM_WITHDRAW as CTR73_187_0_, currentand0_.COD_ACCT_STAT as COD74_187_0_, currentand0_.REF_CHQ_NO_LST_USED as REF75_187_0_, currentand0_.CTR_CHQ_REORDER as CTR76_187_0_, currentand0_.REF_CHQ_NO_LST_ISSD as REF77_187_0_, currentand0_.CTR_NUM_CHQ_WITHDRAW as CTR78_187_0_, currentand0_.BAL_last_stmnt as BAL79_187_0_, currentand0_.dat_last_stmnt as dat80_187_0_, currentand0_.AMT_DR_INT_COMP as AMT81_187_0_, currentand0_.AMT_CR_INT_COMP as AMT82_187_0_, currentand0_.CTR_CR_YTD as CTR83_187_0_, currentand0_.AMT_CR_YTD as AMT84_187_0_, currentand0_.CTR_DR_YTD as CTR85_187_0_, currentand0_.AMT_DR_YTD as AMT86_187_0_, currentand0_.AMT_CLR_TODAY as AMT87_1
87_0_, currentand0_.CTR_TOT_TXNS as CTR88_187_0_, currentand0_.BAL_MIN_MONTH as BAL89_187_0_, currentand0_.BAL_LST_PSBK as BAL90_187_0_, currentand0_.CTR_PSBK_LINE_NO as CTR91_187_0_, currentand0_.CTR_DAYS_OD_LST_YR as CTR92_187_0_, currentand0_.AMT_CUM_OD_LIMIT as AMT93_187_0_, currentand0_.AMT_OD_LIMIT as AMT94_187_0_, currentand0_.AMT_OD_LIMIT_PREV as AMT95_187_0_, currentand0_.CTR_DAYS_OD_CURR as CTR96_187_0_, currentand0_.CTR_DAYS_OD_YTD as CTR97_187_0_, currentand0_.AMT_COMMIT_FEE as AMT98_187_0_, currentand0_.CTR_DAYS_OD_MTD as CTR99_187_0_, currentand0_.AMT_SWEEPIN_LIEN as AMT100_187_0_, currentand0_.CTR_DAYS_OVERLINE_LST_YR as CTR101_187_0_, currentand0_.TIMES_OVERLINE_YTD as TIMES102_187_0_, currentand0_.CTR_DAYS_OVERLINE_CURR as CTR103_187_0_, currentand0_.CTR_DAYS_OVERLINE_YTD as CTR104_187_0_, currentand0_.CTR_DAYS_OVERLINE_MTD as CTR105_187_0_, currentand0_.FLG_ADDTNL_ADRS as FLG106_187_0_, currentand0_.FLG_MAIL_ADD_CTRL as FLG107_187_0_, currentand0_.FLG_HOLD_MAIL as FLG108_187_0_, currentand0_.AMT_HLD as AMT109_187_0_, currentand0_.BAL_AVAILABLE as BAL110_187_0_, currentand0_.BAL_PREVIOUS as BAL111_187_0_, currentand0_.AMT_YTD_SC as AMT112_187_0_, currentand0_.AMT_YTD_INT_RECD as AMT113_187_0_, currentand0_.BAL_BOOK as BAL114_187_0_, currentand0_.AMT_AUTH_DR as AMT115_187_0_, currentand0_.FLG_PREV_BAL_STAT as FLG116_187_0_, currentand0_.AMT_YTD_INT_PAID as AMT117_187_0_, currentand0_.BAL_ACCT_MIN_REQD as BAL118_187_0_, currentand0_.ACCT_TERM_DAYS as ACCT119_187_0_, currentand0_.AMT_ADB_PRODUCT as AMT120_187_0_, currentand0_.AMT_BKDT_CR_INT as AMT121_187_0_, currentand0_.AMT_BKDT_DR_INT as AMT122_187_0_, currentand0_.AMT_CR_INT_ACCR as AMT123_187_0_, currentand0_.AMT_CR_INT_ACCR_LAST_CAP as AMT124_187_0_, currentand0_.AMT_CR_MTD as AMT125_187_0_, currentand0_.AMT_CR_TODAY as AMT126_187_0_, currentand0_.AMT_DR_INT_ACCR as AMT127_187_0_, currentand0_.AMT_DR_INT_ACCR_LAST_CAP as AMT128_187_0_, currentand0_.AMT_DR_MTD as AMT129_187_0_, currentand0_.AMT_DR_TODAY as AMT130_187_0_, currentand0_.AMT_INSTAL as AMT131_187_0_, currentand0_.AMT_LAST_CR as AMT132_187_0_, currentand0_.AMT_LAST_CR_INT_ACCR as AMT133_187_0_, currentand0_.AMT_LAST_DR as AMT134_187_0_, currentand0_.AMT_LAST_DR_INT_ACCR as AMT135_187_0_, currentand0_.AMT_MATURITY_VALUE as AMT136_187_0_, currentand0_.AMT_PERIODIC_PRODUCT as AMT137_187_0_, currentand0_.AMT_RD_ADVANCE as AMT138_187_0_, currentand0_.AMT_TAX_ACCR as AMT139_187_0_, currentand0_.AMT_TAX_ACCR_2 as AMT140_187_0_, currentand0_.AMT_TOT_CR as AMT141_187_0_, currentand0_.AMT_TOT_DR as AMT142_187_0_, currentand0_.BAL_LAST_INT_CAP as BAL143_187_0_, currentand0_.BAL_LAST_SC_CAP as BAL144_187_0_, currentand0_.BAL_TRADING_MIN_REQD as BAL145_187_0_, currentand0_.BP_LINE_SANCTION as BP146_187_0_, currentand0_.BP_LINE_UTILIZED as BP147_187_0_, currentand0_.COD_ACCT_NO_RD_DRWDWN as COD148_187_0_, currentand0_.COD_CLOSER_ID as COD149_187_0_, currentand0_.COD_CUST_MINOR_STAT as COD150_187_0_, currentand0_.COD_SC_PKG as COD151_187_0_, currentand0_.CTR_CR_TODAY as CTR152_187_0_, currentand0_.CTR_DR_MTD as CTR153_187_0_, currentand0_.CTR_CR_MTD as CTR154_187_0_, currentand0_.CTR_DR_TODAY as CTR155_187_0_, currentand0_.CTR_LATE_INSTAL_REMAINING as CTR156_187_0_, currentand0_.CTR_NSF_ITEM as CTR157_187_0_, currentand0_.CTR_NSF_ITEM_YTD as CTR158_187_0_, currentand0_.CTR_RETRIES as CTR159_187_0_, currentand0_.RAT_VAR_CR_INT as RAT160_187_0_, currentand0_.DAT_BP_EXPIRY as DAT161_187_0_, currentand0_.DAT_LAST_CR as DAT162_187_0_, currentand0_.DAT_LAST_DR as DAT163_187_0_, currentand0_.DAT_LAST_INT_CAP as DAT164_187_0_, currentand0_.DAT_LAST_INT_COMP as DAT165_187_0_, currentand0_.DAT_LAST_NSF as DAT166_187_0_, currentand0_.DAT_LAST_PENALTY as DAT167_187_0_, currentand0_.DAT_LAST_SC_CAP as DAT168_187_0_, currentand0_.DAT_LST_PSBK_UPD as DAT169_187_0_, currentand0_.DAT_MATURITY as DAT170_187_0_, currentand0_.DAT_MATURITY_EXEC as DA
T171_187_0_, currentand0_.DAT_NEXT_RETRY as DAT172_187_0_, currentand0_.DAT_NPL as DAT173_187_0_, currentand0_.DAT_RECALLED as DAT174_187_0_, currentand0_.FLG_DISALLOW_BRN as FLG175_187_0_, currentand0_.FLG_DR_INT_SRC_CHANGED as FLG176_187_0_, currentand0_.FLG_STP_PMNT as FLG177_187_0_, currentand0_.FLG_USE_TIERS_FOR_OD as FLG178_187_0_, currentand0_.FRQ_INSTAL as FRQ179_187_0_, currentand0_.GRACE_DAYS as GRACE180_187_0_, currentand0_.LIMIT_ID as LIMIT181_187_0_, currentand0_.NAM_CUST_SHRT as NAM182_187_0_, currentand0_.RAT_INT_RD as RAT183_187_0_, currentand0_.RAT_PENALTY as RAT184_187_0_, currentand0_.cod_cr_int_cap_basis as cod185_187_0_, currentand0_.cod_dr_int_cap_basis as cod186_187_0_, currentand0_.frq_cr_int_cap as frq187_187_0_, currentand0_.frq_dr_int_cap as frq188_187_0_, currentand0_.cr_int_cap_day as cr189_187_0_, currentand0_.dr_int_cap_day as dr190_187_0_, currentand0_.dat_last_cr_int_cap as dat191_187_0_, currentand0_.dat_last_dr_int_cap as dat192_187_0_, currentand0_.bal_last_cr_int_cap as bal193_187_0_, currentand0_.bal_last_dr_int_cap as bal194_187_0_, currentand0_.dat_next_cr_int_cap as dat195_187_0_, currentand0_.dat_next_dr_int_cap as dat196_187_0_, currentand0_.amt_cr_int_accr_adj as amt197_187_0_, currentand0_.amt_dr_int_accr_adj as amt198_187_0_, currentand0_.debit_confirmation_bal as debit199_187_0_, currentand0_.credit_confirmation_bal as credit200_187_0_, currentand0_.COD_IBAN_NO as COD201_187_0_, currentand0_.COD_AER as COD202_187_0_, currentand0_.CTR_CHQ_PUR_RET as CTR203_187_0_, currentand0_.AMT_CR_ROUNDING_DIFFERENCE as AMT204_187_0_, currentand0_.AMT_DR_ROUNDING_DIFFERENCE as AMT205_187_0_, currentand0_.COD_AMT_UNUSED_LIMIT as COD206_187_0_, currentand0_.OD_PARENT_LIMIT_ID as OD207_187_0_, currentand0_.Dat_Of_Recovery as Dat208_187_0_, currentand0_.COD_SC_XFER_ACCT_NO as COD209_187_0_, currentand0_.COD_CR_INT_XFER_ACCT_NO as COD210_187_0_, currentand0_.COD_DR_INT_XFER_ACCT_NO as COD211_187_0_, currentand0_.FLG_STMNT as FLG212_187_0_, currentand0_.FLG_EXCLUDE_COMB_STMNT as FLG213_187_0_, currentand0_.BAL_ACCT_MIN_INITIAL_PAYIN as BAL214_187_0_ from vwe_ch_acct_mast currentand0_ where currentand0_.COD_ACCT_NO=:1 and currentand0_.FLG_MNT_STATUS=:2 |
| 1kn0brbtu80n1 | SELECT A.COD_CR_INT_XFER_ACCT_NO FROM CH_ACCT_MAST A WHERE COD_ACCT_NO = :B1 AND FLG_MNT_STATUS = 'A' |
| 1rd69vg69tx8x | SELECT * FROM CH_ACCT_MAST WHERE COD_ACCT_NO = (:B1 ).COD_ACCT_NO() AND FLG_MNT_STATUS = 'A' |
| 1unm2nqbma9br | DECLARE BEGIN :1 := AP_CS_HO_ACCT_ADD(:2 , :3 , :4 , :5 , :6 , :7 , :8 ) ; END; |
| 1wbsh1xn7jcm6 | SELECT (RAT_CCY_MID - RAT_XFER_BUY_SPRD) FROM BA_CCY_RATE B WHERE COD_LCY = PK_BA_GLOBAL.COD_LCY AND DAT_TIM_RATE_EFF = (SELECT MAX(DAT_TIM_RATE_EFF) FROM BA_CCY_RATE C WHERE B.COD_CCY = :B1 AND B.COD_CCY = C.COD_CCY AND C.COD_LCY = PK_BA_GLOBAL.COD_LCY AND FLG_MNT_STATUS = 'A' AND DAT_TIM_RATE_EFF <= PK_BA_GLOBAL.DAT_PROCESS) AND B.FLG_MNT_STATUS = 'A' |
| 1wr48pz7hhdx9 | SELECT MAX(DAT_POST) FROM TD_NOBOOK WHERE COD_ACCT_NO = :B1 |
| 1x70v3n10ksha | UPDATE CH_ACCT_MAST SET COD_ACCT_TITLE = :B2 WHERE COD_CUST = :B1 AND FLG_MNT_STATUS = 'A' |
| 1zt4zvzbrvu26 | select * from ( select nvl(b.tablespace_name, nvl(a.tablespace_name, 'UNKOWN')) TNAME, round(b.Kbytes_alloc, 2) * 100 KBYTES, round(b.Mbytes_alloc, 2) * 100 MBYTES, round(b.Kbytes_alloc-nvl(a.Kbytes_free, 0)-nvl(c.Kexp_undo, 0), 2) * 100 KBUSED, round(b.Mbytes_alloc-nvl(a.Mbytes_free, 0)-nvl(c.Mexp_undo, 0), 2) * 100 MBUSED, round(nvl(a.Kbytes_free, 0)+nvl(c.Kexp_undo, 0), 2) * 100 KBFREE, round(nvl(a.Mbytes_free, 0)+nvl(c.Mexp_undo, 0), 2) * 100 MBFREE, round(((b.kbytes_alloc-nvl(a.Kbytes_free, 0)-nvl(c.Kexp_undo, 0))/ b.Kbytes_alloc)*100, 2) * 100 PCIUSED, round(((nvl(a.Kbytes_free, 0)+nvl(c.Kexp_undo, 0))/ b.Kbytes_alloc)*100, 2) * 100 PCIFREE, round(nvl(a.K_largest, 0), 2) * 100 KLARGEST, round(nvl(a.M_largest, 0), 2) * 100 MLARGEST, round(nvl(b.Kbytes_max, b.Kbytes_alloc), 2) * 100 KMAXSIZE, round(nvl(b.Mbytes_max, b.Mbytes_alloc), 2) * 100 MMAXSIZE, round(decode(b.Kbytes_max, 0, 0, (b.Kbytes_alloc/b.Kbytes_max)*100), 2)* 100 PCIMAX, nvl(ts_fragment_number, 0) TSFGNUM, round(decode(b.Kbytes_max, 0, 0, ((b.Kbytes_max-b.Kbytes_alloc+nvl(a.Kbytes_free, 0))/b.Kbytes_max)*100), 2)* 100 PCIFMAX from ( select sum(bytes)/1024 Kbytes_free, sum(bytes)/1024/1024 Mbytes_free, max(bytes)/1024 K_largest, max(bytes)/1024/1024 M_largest, tablespace_name, count(tablespace_name) ts_fragment_number from sys.dba_free_space group by tablespace_name ) a, ( select sum(bytes)/1024 Kbytes_alloc, sum(bytes)/1024/1024 Mbytes_alloc, sum(decode(autoextensible, 'NO', bytes, 'YES', maxbytes))/1024 Kbytes_max, sum(decode(autoextensible, 'NO', bytes, 'YES', maxbytes))/1024/1024 Mbytes_max, tablespace_name from sys.dba_data_files group by tablespace_name) b, ( select sum(bytes)/1024 Kexp_undo, sum(bytes)/1024/1024 Mexp_undo, tablespace_name from sys.dba_undo_extents where status = 'EXPIRED' group by tablespace_name) c where a.tablespace_name (+) = b.tablespace_name and c.tablespace_name (+) = b.tablespace_name order by 1 ) where ROWNUM<= :maxrownum AND (( PCIUSED >= :BindValue0 )) |
| 20n46m35h8xa8 | SELECT AB.*, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.cod_fcr_hold_no ELSE NULL END FCR_UNHOLD_NO , CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Notice_No ELSE NULL END UNHOLD_COD_NOTICE_NO, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.DAT_POSTING ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN AB.DAT_HOLD_STATUS ELSE NULL END END DAT_UNHOLD_ACTION, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN to_char(auditlogs2.Dat_ACTION, 'HH24:MI:SS') ELSE NULL END UNHOLD_TIME, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Reason ELSE NULL END UNHOLD_HOLD_AUTH, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Last_Mnt_Makerid ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN 'SYSTEM' ELSE NULL END END UNHOLD_MAKER, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Last_Mnt_Chkrid ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN 'SYSTEM' ELSE NULL END END UNHOLD_CHECKER, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Txt_Narrative ELSE NULL END UNHOLD_NARR, CASE WHEN(auditlogs2.cod_action =1 AND cod_hold_status = 3) THEN auditlogs2.COD_PREV_NOTICE_NO ELSE NULL END prev_notice_no FROM (Select * from temp_holdunhold_inq1 tmp WHERE 1 = 1 AND (cod_hold_status = (case when cod_hold_typ = 3 then cod_hold_status else 0 end) or cod_hold_status = (case when cod_hold_typ = 3 then cod_hold_status else 1 end)) AND COD_HOLD_TYP = 3 AND COD_CC_BRN_TXN = 167 ) AB LEFT JOIN ba_hold_audit_log auditlogs2 ON (AB.cod_fcr_hold_no = auditlogs2.Cod_Fcr_Hold_No AND AB.COD_NOTICE_NO = auditlogs2.cod_notice_no AND AB.cod_mc_acct_no = auditlogs2.cod_mc_acct_no) |
| 2136t6u9kbux5 |
UPDATE CH_ACCT_MAST SET COD_CC_BRN = :B212 , COD_PROD = :B211 , COD_ACCT_NO = :B210 , COD_OFFICR_ID = :B209 , DAT_ACCT_OPEN = :B208 , COD_ACCT_TITLE = :B207 , COD_CUST = :B206 , NAM_CUST_SHRT = :B205 , NAM_NOMINEE = :B204 , COD_CCY = :B203 , COD_ACCT_STAT = :B202 , COD_LANG = :B201 , COD_TDS = :B200 , BAL_ACCT_MIN_REQD = :B199 , FLG_JOINT_ACCT = :B198 , FLG_ADHOC_STMNT = :B197 , FLG_STP_PMNT = :B196 , FLG_SI = :B195 , FLG_SWPOUT = :B194 , FLG_IDD_AUTH = :B193 , FLG_TDS = :B192 , FLG_VAT = :B191 , AMT_EXEMPT_LIMIT = :B190 , FLG_GRP_BONUS = :B189 , FLG_ATM = :B188 , CTR_INT_SC_XFER = :B187 , COD_ACCT_NO_GRP_INT = :B186 , COD_ACCT_NO_GRP_SC = :B185 , RAT_VAR_CR_INT = :B184 , REF_CHQ_NO_LST_ISSD = :B183 , REF_CHQ_NO_LST_USED = :B182 , FLG_SPECIAL_STMNT = :B181 , FLG_REST_ACCT = :B180 , FLG_EMP_ACCT = :B179 , FLG_HOLD_MAIL = :B178 , FLG_MAIL_ADD_CTRL = :B177 , FLG_ADDTNL_ADRS = :B176 , FLG_MEMO = :B175 , FLG_DR_AUTH = :B174 , FLG_PSBOOK = :B173 , AMT_OD_LIMIT = :B172 , DAT_ST_UNCL_ADVNC = :B171 , AMT_UNCLR_ADVNC_LIM = :B170 , RAT_UNCLR_ADVNC_PCT = :B169 , DAT_EXP_UNCLR_ADVNC = :B168 , CTR_DAYS_OD_CURR = :B167 , CTR_DAYS_OD_MTD = :B166 , CTR_DAYS_OD_YTD = :B165 , CTR_DAYS_OD_LST_YR = :B164 , CTR_STMNT_COPIES = :B163 , CTR_DAY_STMNT_GEN = :B162 , BAL_BOOK = :B161 , AMT_UNCLR = :B160 , AMT_AUTH_DR = :B159 , AMT_HLD = :B158 , BAL_AVAILABLE = :B157 , AMT_CLR_TODAY = :B156 , AMT_DR_TODAY = :B155 , AMT_CR_TODAY = :B154 , AMT_DR_MTD = :B153 , AMT_CR_MTD = :B152 , AMT_DR_YTD = :B151 , AMT_CR_YTD = :B150 , CTR_DR_TODAY = :B149 , CTR_CR_TODAY = :B148 , CTR_DR_MTD = :B147 , CTR_CR_MTD = :B146 , CTR_DR_YTD = :B145 , CTR_CR_YTD = :B144 , AMT_LAST_DR = :B143 , DAT_LAST_DR = :B142 , AMT_LAST_CR = :B141 , DAT_LAST_CR = :B140 , DAT_LAST_STMNT = :B139 , BAL_LAST_STMNT = :B138 , BAL_MIN_MONTH = :B137 , CTR_YTD_STMNT_NO = :B136 , CTR_NUM_WITHDRAW = :B135 , CTR_NUM_CHQ_WITHDRAW = :B134 , CTR_CHQ_REORDER = :B133 , DAT_LAST_INT_CAP = :B132 , DAT_LAST_SC_CAP = :B131 , AMT_CR_INT_ACCR_LAST_CAP = :B130 , AMT_DR_INT_ACCR_LAST_CAP = :B129 , AMT_TAX_ACCR = :B128 , AMT_ADB_PRODUCT = :B127 , DAT_LAST_INT_COMP = :B126 , BAL_LAST_INT_CAP = :B125 , AMT_TOT_DR = :B124 , AMT_TOT_CR = :B123 , BAL_LAST_SC_CAP = :B122 , DAT_LAST_NSF = :B121 , CTR_NSF_ITEM_YTD = :B120 , CTR_NSF_ITEM = :B119 , FLG_INT_WAIVER = :B118 , FLG_SC_WAIVER = :B117 , FLG_SC_WAIVER_CUST = :B116 , BMP_SC_WAIVER = :B115 , COD_INT_SC_ACCT_NO = :B114 , AMT_YTD_INT_PAID = :B113 , AMT_YTD_INT_RECD = :B112 , AMT_YTD_SC = :B111 , AMT_DR_INT_ACCR = :B110 , AMT_CR_INT_ACCR = :B109 , AMT_DR_INT_COMP = :B108 , AMT_CR_INT_COMP = :B107 , AMT_LAST_CR_INT_ACCR = :B106 , AMT_LAST_DR_INT_ACCR = :B105 , AMT_BKDT_CR_INT = :B104 , AMT_BKDT_DR_INT = :B103 , BP_LINE_SANCTION = :B102 , BP_LINE_UTILIZED = :B101 , DAT_BP_EXPIRY = :B100 , CTR_PSBK_LINE_NO = :B99 , BAL_LST_PSBK = :B98 , DAT_LST_PSBK_UPD = :B97 , COD_CLOSER_ID = :B96 , FLG_ACCT_CLOSE = :B95 , FLG_DORM_SC = :B94 , AMT_SWEEPIN_LIEN = :B93 , FLG_SWEEPIN = :B92 , CTR_DAYS_OVERLINE_CURR = :B91 , CTR_DAYS_OVERLINE_MTD = :B90 , CTR_DAYS_OVERLINE_YTD = :B89 , CTR_DAYS_OVERLINE_LST_YR = :B88 , AMT_PERIODIC_PRODUCT = :B87 , BAL_PREVIOUS = :B86 , FLG_PREV_BAL_STAT = :B85 , FLG_MNT_STATUS = :B84 , COD_MNT_ACTION = :B83 , COD_LAST_MNT_MAKERID = :B82 , COD_LAST_MNT_CHKRID = :B81 , DAT_LAST_MNT = :B80 , CTR_UPDAT_SRLNO = :B79 , DAT_RECALLED = :B78 , DAT_NPL = :B77 , TIMES_OVERLINE_YTD = :B76 , CTR_FUNDS_CR_TODAY = :B75 , FLG_STATUS_RECALLED = :B74 , FLG_STATUS_SECURITIZED = :B73 , FLG_STATUS_CONVERSION = :B72 , FLG_STATUS_LEGAL = :B71 , FLG_REMINDER_GEN = :B70 , FLG_ACCR_STATUS = :B69 , LIMIT_ID = :B68 , ACCT_XFERED_FROM = :B67 , FLG_PDO_OVERRIDE = :B66 , FLG_PAST_DUE_STATUS = :B65 , AMT_COMMIT_FEE = :B64 , AMT_CUM_OD_LIMIT = :B63 , AMT_OD_LIMIT_PREV = :B62 , CTR_TOT_TXNS = :B61 , AMT_INSTAL = :B60 , DAT_MATURITY = :B59 , CT
R_LATE_INSTAL_REMAINING = :B58 , ACCT_TERM_DAYS = :B57 , FRQ_INSTAL = :B56 , RAT_INT_RD = :B55 , AMT_RD_ADVANCE = :B54 , FLG_REPL_CUBE = :B53 , COD_LINE_NO = :B52 , AMT_MATURITY_VALUE = :B51 , RAT_PENALTY = :B50 , DAT_LAST_PENALTY = :B49 , GRACE_DAYS = :B48 , FLG_INTEREST_FREEZE = :B47 , COD_CUST_MINOR_STAT = :B46 , COD_ACCT_NO_RD_DRWDWN = :B45 , FLG_ALLOW_DRWDWN = :B44 , CTR_RETRIES = :B43 , DAT_NEXT_RETRY = :B42 , DAT_MATURITY_EXEC = :B41 , COD_TDS_2 = :B40 , AMT_TAX_ACCR_2 = :B39 , AMT_EXEMPT_LIMIT_2 = :B38 , BAL_TRADING_MIN_REQD = :B37 , COD_SC_PKG = :B36 , FLG_DISALLOW_BRN = :B35 , FLG_DR_INT_SRC_CHANGED = :B34 , FLG_USE_TIERS_FOR_OD = :B33 , FLG_RAT_CHANGE_ADVICE = :B32 , RAT_CHANGE_ADVICE_LEAD_DAYS = :B31 , COD_CR_INT_CAP_BASIS = :B30 , COD_DR_INT_CAP_BASIS = :B29 , FRQ_CR_INT_CAP = :B28 , FRQ_DR_INT_CAP = :B27 , CR_INT_CAP_DAY = :B26 , DR_INT_CAP_DAY = :B25 , DAT_LAST_CR_INT_CAP = :B24 , DAT_LAST_DR_INT_CAP = :B23 , BAL_LAST_CR_INT_CAP = :B22 , BAL_LAST_DR_INT_CAP = :B21 , DAT_NEXT_CR_INT_CAP = :B20 , DAT_NEXT_DR_INT_CAP = :B19 , AMT_CR_INT_ACCR_ADJ = :B18 , AMT_DR_INT_ACCR_ADJ = :B17 , DEBIT_CONFIRMATION_BAL = :B16 , CREDIT_CONFIRMATION_BAL = :B15 , COD_IBAN_NO = :B14 , COD_AER = :B13 , CTR_CHQ_PUR_RET = :B12 , AMT_CR_ROUNDING_DIFFERENCE = :B11 , AMT_DR_ROUNDING_DIFFERENCE = :B10 , COD_AMT_UNUSED_LIMIT = :B9 , OD_PARENT_LIMIT_ID = :B8 , DAT_OF_RECOVERY = :B7 , COD_SC_XFER_ACCT_NO = :B6 , COD_CR_INT_XFER_ACCT_NO = :B5 , COD_DR_INT_XFER_ACCT_NO = :B4 , FLG_STMNT = :B3 , FLG_EXCLUDE_COMB_STMNT = :B2 , BAL_ACCT_MIN_INITIAL_PAYIN = :B1 WHERE COD_ACCT_NO = :B215 AND FLG_MNT_STATUS = :B214 AND CTR_UPDAT_SRLNO = :B213 |
| 2avbprd3y6fb2 | DECLARE BEGIN :1 := PK_XFACE_INQ_CUST_SEARCH.AP_INQ_CUST_SEARCH(:2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 ) ; END; |
| 2gwn0f46hyu7v | SELECT * FROM CH_ACCT_MAST WHERE FLG_MNT_STATUS = 'A' AND COD_ACCT_NO = :B1 |
| 2jwq955kpr4md | SELECT * FROM TD_PROD_MAST WHERE COD_PROD = :B1 AND FLG_MNT_STATUS = 'A' |
| 2jxd8gvw5q282 | DELETE FROM TEMP_PS_PSBK_DTLS_TEMP WHERE SESSION_ID = :B1 |
| 2uu6483w3x1y7 | SELECT COD_PROD, CTR_LATE_INSTAL_REMAINING FROM CH_ACCT_MAST WHERE COD_ACCT_NO = :B1 AND FLG_MNT_STATUS = 'A' |
| 2y238kyd18avh | SELECT NVL(SUM(DECODE(COD_DRCR, 'C', AMT_TXN_ACY, -AMT_TXN_ACY)), 0) FROM TD_AUDIT_TRAIL WHERE COD_ACCT_NO = :B6 AND COD_PROD = :B5 AND DAT_POST < :B4 AND COD_GL IN (:B3 , :B2 , :B1 ) |
| 31kaw8sb922jn | SELECT COUNT(0) FROM CH_RD_INSTAL_DET WHERE COD_ACCT_NO = (:B1 ).COD_ACCT_NO() |
| 32xx5zzc201wq | LOCK TABLE "TEMP_CUST_DTLS" IN EXCLUSIVE MODE NOWAIT |
| 389gdxg3mk88k | DECLARE BEGIN :1 := PK_XFACE_ACCT_TRANS_INQ.AP_XFACE_ACCT_TRANS_INQ(:2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 ) ; END; |
| 38j9ukuskya12 | SELECT BAL_BOOK, COD_ACCT_STAT FROM CH_ACCT_MAST WHERE COD_ACCT_NO = :B1 AND FLG_MNT_STATUS = 'A' |
| 3bgupt86665nu | SELECT BAL_AVAILABLE, AMT_HLD, AMT_UNCLR, AMT_AUTH_DR, NAM_CUST_SHRT, COD_CUST FROM CH_ACCT_MAST WHERE COD_ACCT_NO = :B2 AND FLG_MNT_STATUS = 'A' AND CTR_UPDAT_SRLNO = :B1 |
| 3c0h6w6ga4fp4 | select * from fcr44host.mc_acct_xref t where cod_cust_id='2021498352' |
| 3faq1h0rvuzwf | SELECT i.cod_stock as "InventoryCode", i.cod_stock_no as "InventoryNo" , decode(p.all_in_one_no , null, c.cod_card_no, p.all_in_one_no) as "AllInOnePassBook" FROM iv_mca_xref i , cm_card_mca_xref c, mc_psbk_mast p where i.cod_mc_acct_no = p.cod_mc_acct_no(+) AND i.cod_stock_no = p.cod_psbk_no(+) AND i.cod_stock = p.cod_stock(+) and i.cod_mc_acct_no = c.cod_mc_acct_no(+) and i.cod_stock = c.cod_card_typ(+) and i.link_status = 'A' AND i.cod_stock IN (734, 735, 738, 747, 748, 749, 778, 781) and i.cod_mc_acct_no = :1 |
| 3hddt2qrq2txy | SELECT COD_CUST FROM CH_ACCT_CUST_XREF WHERE COD_ACCT_NO = :B1 AND COD_ACCT_CUST_REL IN ('SOW', 'JAF', 'JOF') AND FLG_MNT_STATUS = 'A' |
| 3qjushmkjj0d9 | SELECT COD_ACCT_NO, COD_CUST, COD_CC_BRN, COD_PROD, BAL_BOOK, FLG_SWEEPIN, FLG_ACCR_STATUS, COD_CCY, BAL_AVAILABLE, CTR_UPDAT_SRLNO, BAL_PREVIOUS, DAT_ACCT_OPEN FROM CH_ACCT_MAST WHERE COD_ACCT_NO = :B1 AND FLG_MNT_STATUS = 'A' |
| 40a3wzrttg9u5 | SELECT --+PARALLEL(4) B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, SUM(A.AMT_TXN_HOST), COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host FROM CH_ST_CAP_INPUT_TXN_MMDD A, CH_PROD_MAST B WHERE DAT_POST = TO_DATE('21-03-2013', 'DD-MM-YYYY') AND A.COD_PROD_HOST = B.COD_PROD AND A.COD_DRCR_DEST = 'C' AND COD_CCY_HOST = '156' AND B.COD_GL_INT_PAYABLE = '26003' AND a.cod_cc_brn_host = '855' GROUP BY B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host ORDER BY B.COD_GL_INT_PAYABLE, COD_CCY_HOST, COD_CC_BRN_HOST, A.COD_PROD_HOST |
| 44zpmjfcdnnax | SELECT REFERENCENUMBER REFERENCENUMBER , TRIM(TO_CHAR(TO_NUMBER(DEDUCTEDAMOUNT), '999999999999.99')) DEDUCTEDAMOUNT , HOSTDATE HOSTDATE , HOSTREFERENCENUMBER HOSTREFERENCENUMBER , STATUS STATUS , ERRORMESSAGE ERRORMESSAGE , TRIM(TO_CHAR(TO_NUMBER(ACCOUNTBALANCE), '999999999999.99')) ACCOUNTBALANCE , ACCOUNTNAME ACCOUNTNAME , ACCTHOMEBANKSTATION ACCTHOMEBANKSTATION FROM EXT_FCR_BLKFNDXFER B WHERE B.FILEID = :B1 |
| 47us85qnn7v3v | SELECT DAT_PROCESS FROM BA_BANK_MAST WHERE FLG_MNT_STATUS = 'A' |
| 4c2jhutjj01ms | INSERT INTO XFACE_TEMP_ACCT_BAS_INFO (COD_MC_ACCT_NO, COD_ACCT_NO, COD_CCY, COD_ACCT_TYP, COD_CC_BRN, COD_ACCT_TITLE, COD_PROD, COD_PROD_NAM, COD_CUSTID, COD_DEP_NO, COD_DAT_VALUE, COD_INT_RATE, COD_FLG_AUTO_RENEW, COD_CASH_REMIT_FLG, COD_ACCT_NATURE, COD_WITHDR_METHOD, COD_CASH_INTR_BRN_TXN_FLG, COD_FUND_INTR_BRN_TXN_FLG, COD_BAL_BOOK, COD_HOLD_AMT, COD_STOP_PAY_AMT, COD_BAL_AVAILABLE, COD_NET_BAL, COD_DAT_ACCT_OPEN, COD_ACCT_STATUS, COD_DAT_ACCT_CLOSE, COD_DAT_LAST_CAPITALIZATION, COD_DAT_MATURITY, COD_DEP_TERM, COD_INVENTORY_COD, COD_INVENTORY_NO, COD_INVENTORY_STATUS, COD_PAY_VERIFY_AMT, COD_PAYER_PAYEE_NAM_FLG, COD_FUND_ATTR, COD_BULK_ACCT_OPEN_FLG, COD_ACCT_CLOSURE_FLG, COD_ASSIGNED_ACCT, COD_ACCRUE_INT_AMT, COD_DUE_INT_AMT, COD_INT_PAYOUT_ACCT, COD_FIRST_CHK_PERSON, COD_FIRST_CHK_PERSON_TELNO, COD_SECOND_CHK_PERSON, COD_SECOND_CHK_PERSON_TELNO, COD_CAPITAL_VERIFY_RESULT, COD_AGREEMENT_DEPOSIT_FLG, COD_PARENT_ACCT_FLG, COD_OFFICIER_ID, COD_ACCT_NO_BENEF, COD_REG_PERIOD_INT) SELECT A.COD_MC_ACCT_NO, B.COD_ACCT_NO, B.COD_CCY, A.COD_MODULE, A.COD_CC_BRN, A.COD_MCA_TITLE, B.COD_PROD, ' ', A.COD_CUST_ID, 0, A.DAT_MCA_OPEN, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, A.DAT_MCA_OPEN, A.COD_MCA_STAT, A.DAT_MCA_CLOSE, '', '', '', '', '', '', 0, '', '', '', '', '', 0, 0, '', '', '', '', '', '', '', '', '', '', '' FROM MC_ACCT_MAST A, MC_ACCT_XREF B WHERE B.COD_ACCT_NO = :B1 AND A.COD_MC_ACCT_NO = B.COD_MC_ACCT_NO AND A.FLG_MNT_STATUS = 'A' AND B.FLG_MNT_STATUS = 'A' |
| 4c4bstd40juuy | DECLARE BEGIN :1 := PK_XFACE_INQ_CONSOLIDATED_ACCT.AP_INQ_CONSOLIDATED_TXN(:2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 ) ; END; |
| 4kj4y3xyavft6 | select signatorie0_.cod_cust_id as cod1_0_, signatorie0_.flg_mnt_status as flg2_0_, signatorie0_.signatory_name as signatory3_0_, signatorie0_.signatory_desgn as signatory4_0_, signatorie0_.director_name as director5_0_, signatorie0_.idx as idx0_ from vwe_ci_custmast_signatory signatorie0_ where signatorie0_.cod_cust_id=:1 and signatorie0_.flg_mnt_status=:2 |
| 4r9njbqddg6hd | INSERT INTO XFACE_AT_REAL_TIME_GL_TXN_INQ (COD_GL_ACCT, DAT_TXN, NAM_GL, DEB_TXN_AMT, CRE_TXN_AMT, INQUIRED_BRANCH, SESSION_ID) SELECT :B3 , :B2 , B.NAM_GL_ACCT, DECODE(A.DRCR_IND, 'D', A.LCY_AMOUNT, 'C', NULL), DECODE(A.DRCR_IND, 'C', A.LCY_AMOUNT, 'D', NULL), (SELECT COD_EXTERNAL_BRANCH FROM BA_EXT_BRANCH_XREF WHERE A.AC_BRANCH = COD_CC_BRN), :B4 FROM ACTB_HISTORY A, GL_TABLE B WHERE A.AC_NO = B.COD_GL_ACCT AND A.AC_NO = :B3 AND A.TRN_DT = :B2 AND A.AC_CCY = :B1 AND A.AC_BRANCH IN (SELECT COD_CC_BRN FROM GTT_LOWER_BRANCH WHERE SESSION_ID = :B4 ) AND B.FLG_MNT_STATUS = 'A' |
| 4ubbrc9uha5fy |
select individual0_.COD_CUST_ID as COD1_190_0_, individual0_.FLG_MNT_STATUS as FLG2_190_0_, individual0_.NAM_CUST_SHRT as NAM3_190_0_, individual0_.COD_OFFICR_ID as COD4_190_0_, individual0_.COD_CUST_NATL_ID as COD5_190_0_, individual0_.COD_NATL_ID_OLD as COD6_190_0_, individual0_.CIF_TYPE as CIF7_190_0_, individual0_.FLG_REST_CUST as FLG8_190_0_, individual0_.dat_cif_type_change as dat9_190_0_, individual0_.COD_CUST_PHONETIC as COD10_190_0_, individual0_.COD_MID_PHONETIC as COD11_190_0_, individual0_.COD_FIRST_PHONETIC as COD12_190_0_, individual0_.FLG_MEMBER as FLG13_190_0_, individual0_.COD_MEMBER_NO as COD14_190_0_, individual0_.COD_CUST_LANG as COD15_190_0_, individual0_.FLG_IC_TYP as FLG16_190_0_, individual0_.FLG_CUST_TYP as FLG17_190_0_, individual0_.COD_TDS as COD18_190_0_, individual0_.COD_TDS_2 as COD19_190_0_, individual0_.TXT_CUST_NATNLTY as TXT20_190_0_, individual0_.COD_CC_HOMEBRN as COD21_190_0_, individual0_.DAT_CUST_OPEN as DAT22_190_0_, individual0_.cod_last_mnt_chkrid as cod23_190_0_, individual0_.cod_last_mnt_makerid as cod24_190_0_, individual0_.dat_last_mnt as dat25_190_0_, individual0_.ctr_updat_srlno as ctr26_190_0_, individual0_.cod_mnt_action as cod27_190_0_, individual0_.FLG_KIO as FLG28_190_0_, individual0_.REF_CUST_IT_NUM as REF29_190_0_, individual0_.FLG_KEY_CHG as FLG30_190_0_, individual0_.FLG_REPLICATE as FLG31_190_0_, individual0_.FLG_LOCK_FAC as FLG32_190_0_, individual0_.flg_blocked as flg33_190_0_, individual0_.cod_block_reason as cod34_190_0_, individual0_.COD_EMPLOYEE_ID as COD35_190_0_, individual0_.NAM_IC_Issuer as NAM36_190_0_, individual0_.DAT_IC_Issue as DAT37_190_0_, individual0_.DAT_IC_Expiry as DAT38_190_0_, individual0_.FLG_Dom_Overseas as FLG39_190_0_, individual0_.TXT_Cust_region as TXT40_190_0_, individual0_.FLG_Composite_Stat as FLG41_190_0_, individual0_.FLG_Statement_Freq as FLG42_190_0_, individual0_.FLG_All_One as FLG43_190_0_, individual0_.COD_Cust_Class as COD44_190_0_, individual0_.dat_next_stmt as dat45_190_0_, individual0_.dat_last_stmt as dat46_190_0_, individual0_.External_Customer_IC as External47_190_0_, individual0_.External_Customer_IC_TYPE as External48_190_0_, individual0_.COD_CUSTADR_TYPE as COD49_190_0_, individual0_.COD_CUST_REGION as COD50_190_0_, individual0_.TXT_STMT_REGION as TXT51_190_0_, individual0_.COD_ACCT_NO_DEFAULT as COD52_190_0_, individual0_.FLG_CUST_STATUS as FLG53_190_0_, individual0_.COD_TYP_ACCOM as COD54_190_0_, individual0_.COD_BANK_CARD as COD55_190_0_, individual0_.REF_CUST_EMAIL as REF56_190_0_, individual0_.REF_CUST_TELEX as REF57_190_0_, individual0_.REF_PHONE_MOBILE as REF58_190_0_, individual0_.COD_CUSTMOB_INTERNATION_CODE as COD59_190_0_, individual0_.TXT_MOB_EMAIL_ADD as TXT60_190_0_, individual0_.FLG_CUST_MEMO as FLG61_190_0_, individual0_.NAM_CUST_FULL as NAM62_190_0_, individual0_.dat_birth_cust as dat63_190_0_, individual0_.FLG_LOC_GLOB as FLG64_190_0_, individual0_.FLG_STAFF as FLG65_190_0_, individual0_.FLG_SPL_CUST as FLG66_190_0_, individual0_.REF_CUST_FAX as REF67_190_0_, individual0_.FLG_IC_VALIDITY as FLG68_190_0_, individual0_.cod_cust_marstat as cod69_190_0_, individual0_.txt_cust_sex as txt70_190_0_, individual0_.FLG_MINOR as FLG71_190_0_, individual0_.COD_GUARDIAN_TYPE as COD72_190_0_, individual0_.cod_cust_status as cod73_190_0_, individual0_.TXT_CUST_EDUCN as TXT74_190_0_, individual0_.COD_CUST_BLDGRP as COD75_190_0_, individual0_.cod_cust_introducer_id as cod76_190_0_, individual0_.NAM_CUST_MID as NAM77_190_0_, individual0_.NAM_CUST_LAST as NAM78_190_0_, individual0_.NAM_CUST_FIRST as NAM79_190_0_, individual0_.TXT_CUST_PREFIX as TXT80_190_0_, individual0_.NAM_CUST_EMP as NAM81_190_0_, individual0_.CTR_CUST_SPOUSES as CTR82_190_0_, individual0_.CTR_DPNDT_CHLDRN as CTR83_190_0_, individual0_.CTR_DPNDT_OTHRS as CTR84_190_0_, individual0_.NAM_CUST_SPOUSE as NAM85_190_0_, individual0_.TXT_SPOUSE_OCCPN as TXT86_190_0_, individual
0_.TXT_PROFESS_CAT as TXT87_190_0_, individual0_.COD_SIGN_TYP as COD88_190_0_, individual0_.TXT_ETHNIC_ORIGIN as TXT89_190_0_, individual0_.TXT_LGL_RSDNC_STAT as TXT90_190_0_, individual0_.COD_INCOME_CAT as COD91_190_0_, individual0_.TXT_CUST_RESIDENCE as TXT92_190_0_, individual0_.TXT_CUST_DESGN as TXT93_190_0_, individual0_.nam_mother_maiden as nam94_190_0_, individual0_.CREDIT_RATING as CREDIT95_190_0_, individual0_.TXT_IC_ISSUE_REGION as TXT96_190_0_ from vwe_ci_custmast individual0_ where individual0_.COD_CUST_ID=:1 and individual0_.FLG_MNT_STATUS=:2 and decode(individual0_.flg_typ_class, 'B', 'C', individual0_.flg_typ_class)='I' |
| 4z0m8jnwx1nn1 | INSERT INTO XFACE_ADDL_DTLS_TLOG_TEMP (REF_TXN_NO, REF_USR_NO, REF_KEY_NO, REF_TXN_NO_ORG, REF_USR_NO_ORG, RECON_CODE, COD_TASK_DERIVED, COD_CHNL_ID, COD_SERVICE_ID, COD_USER_ID, COD_AUTH_ID, COD_ACCT_NO, TYP_ACCT_NO, COD_SUB_ACCT_NO, COD_DEP_NO, AMOUNT, COD_CCY, DAT_POST, DAT_VALUE, TXT_TXN_NARRATIVE, DATE_CHEQUE_ISSUE, TXN_BUSINESS_TYPE, CARD_NO, INVENTORY_CODE, INVENTORY_NO, CARD_PASSBOOK_NO, COD_CASH_ANALYSIS, BANK_INFORMATION_NO, BATCH_NO, SUMMARY, MAIN_IC_TYPE, MAIN_IC_NO, MAIN_IC_NAME, MAIN_IC_CHECK_RETURN_CODE, DEPUTY_IC_TYPE, DEPUTY_IC_NO, DEPUTY_NAME, DEPUTY_IC_CHECK_RETURN_CODE, ACCOUNT_PROPERTY, CHEQUE_NO, COD_EXT_TASK, COD_MODULE, ACC_PURPOSE_CODE, NATIONALITY, CUSTOMER_NAME, COD_INCOME_EXPENSE, COD_EXT_BRANCH, COD_ACCT_TITLE, FLG_CA_TT, DAT_EXT_LOCAL, ACCT_OWNER_VALID_RESULT, FLG_DR_CR, FLG_ONLINE_UPLOAD, FLG_STMT_DISPLAY, COD_TXN_TYPE, DAT_TS_TXN, LC_BG_GUARANTEE_NO, COD_OTHER_ACCT_NO, COD_MOD_OTHER_ACCT_NO, COD_CC_BRN_SUB_ACCT, COD_CC_BRN_OTHR_ACCT, COD_EXT_TASK_REV, SESSIONID) SELECT REF_TXN_NO, REF_USR_NO, REF_KEY_NO, REF_TXN_NO_ORG, REF_USR_NO_ORG, RECON_CODE, COD_TASK_DERIVED, COD_CHNL_ID, COD_SERVICE_ID, COD_USER_ID, COD_AUTH_ID, COD_ACCT_NO, TYP_ACCT_NO, COD_SUB_ACCT_NO, COD_DEP_NO, AMOUNT, COD_CCY, DAT_POST, DAT_VALUE, TXT_TXN_NARRATIVE, DATE_CHEQUE_ISSUE, TXN_BUSINESS_TYPE, CARD_NO, INVENTORY_CODE, INVENTORY_NO, CARD_PASSBOOK_NO, COD_CASH_ANALYSIS, BANK_INFORMATION_NO, BATCH_NO, SUMMARY, MAIN_IC_TYPE, MAIN_IC_NO, MAIN_IC_NAME, MAIN_IC_CHECK_RETURN_CODE, DEPUTY_IC_TYPE, DEPUTY_IC_NO, DEPUTY_NAME, DEPUTY_IC_CHECK_RETURN_CODE, ACCOUNT_PROPERTY, CHEQUE_NO, COD_EXT_TASK, COD_MODULE, ACC_PURPOSE_CODE, NATIONALITY, CUSTOMER_NAME, COD_INCOME_EXPENSE, COD_EXT_BRANCH, COD_ACCT_TITLE, FLG_CA_TT, DAT_EXT_LOCAL, ACCT_OWNER_VALID_RESULT, FLG_DR_CR, FLG_ONLINE_UPLOAD, FLG_STMT_DISPLAY, COD_TXN_TYPE, DAT_TS_TXN, LC_BG_GUARANTEE_NO, COD_OTHER_ACCT_NO, COD_MOD_OTHER_ACCT_NO, COD_CC_BRN_SUB_ACCT, COD_CC_BRN_OTHR_ACCT, COD_EXT_TASK_REV, :B4 FROM XFACE_ADDL_DETAILS_TXNLOG WHERE COD_SUB_ACCT_NO = :B3 AND DAT_POST BETWEEN :B2 AND :B1 |
| 51m5fjxsjfw5x | insert into REC_TXN_LOG (REF_SYS_TR_AUD_NO, USER_ID, AUTH_ID, COD_TRAN, AUTH_NO, COD_TRAN_STAT, DATE_SYS, COD_MSG_TYP, COD_REPLY, REF_USR_NO, COD_SERVICE_ID, COD_CHNL_ID, EXT_REPLY, DAT_REQ, DAT_RESP, REF_ORG_NO, DAT_VALUE, COD_ERROR, TXN_TIME_TAKEN, EXT_LOCAL_DATE, EXT_TASK_CODE, EXT_BRN_CODE, COD_BRN, USER_NO, REF_TXN_NO, DAT_POST) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 ) |
| 53qm75t2pfkrh | SELECT DAT_BASCHG_EFF, :1 AS COD_ACCT_NO, 1 AS COD_INT_TYPE, :2 AS COD_CCY, 0 AS AMT_RESTED_PRINCIPAL, 0 AS AMT_INT_COMP, 0 AS AMT_FACE_VALUE, 0 AS AMT_ADVANCES, 0 AS AMT_DISBURSED, 0 AS AMT_CONTRIBUTION_PAYIN, 0 AS BAL_OFFSET_AVG, (SELECT SUM(DECODE(cod_drcr, 'D', 1, -1) * amt_txn_acy) FROM ln_arrear_txn_hist B, ln_arrears_table C WHERE B.cod_acct_no = :3 AND B.cod_arrear_type = 'C' AND c.flg_accrual_basis = 'A' AND C.cod_acct_no = B.cod_acct_no AND C.ref_billno_srl = B.ref_billno_srl AND B.dat_value <= C.Dat_Ioa_Grace_Expiry AND :4 > C.dat_arrears_due AND C.dat_ioa_grace_expiry > :5 /* arrears not paid off within the grace period */ AND NOT (C.amt_arrears_due = 0 AND C.dat_ioa_grace_expiry >= C.dat_last_payment )) AMT_ARREARS_PRINC, (SELECT SUM(DECODE(cod_drcr, 'D', 1, -1) * amt_txn_acy) FROM ln_arrear_txn_hist B, ln_arrears_table C WHERE B.cod_acct_no = :6 AND B.cod_arrear_type IN ('I', 'T', 'N', 'U') AND C.cod_acct_no = B.cod_acct_no AND c.flg_accrual_basis = 'A' AND C.ref_billno_srl = B.ref_billno_srl AND B.dat_value <= C.Dat_Ioa_Grace_Expiry AND :7 > C.dat_arrears_due AND C.dat_ioa_grace_expiry > :8 /* arrears not paid off within the grace period */ AND NOT (C.amt_arrears_due = 0 AND C.dat_ioa_grace_expiry >= C.dat_last_payment )) AMT_ARREARS_INT, (SELECT SUM(DECODE(cod_drcr, 'D', 1, -1) * amt_txn_acy) FROM ln_arrear_txn_hist B, ln_arrears_table C WHERE B.cod_acct_no = :9 AND B.cod_arrear_type IN ('F', 'P', 'S', 'O', 'D', 'M', 'E', 'G') AND C.cod_acct_no = B.cod_acct_no AND c.flg_accrual_basis = 'A' AND C.ref_billno_srl = B.ref_billno_srl AND B.dat_value <= C.Dat_Ioa_Grace_Expiry AND :10 > C.dat_arrears_due AND C.dat_ioa_grace_expiry > :11 /* arrears not paid off within the grace period */ AND NOT (C.amt_arrears_due = 0 AND C.dat_ioa_grace_expiry >= C.dat_last_payment)) AMT_ARREARS_CHG, (SELECT SUM(DECODE(cod_drcr, 'D', 1, -1) * amt_txn_acy) FROM ln_arrear_txn_hist B, ln_arrears_table C WHERE B.cod_acct_no = :12 AND B.cod_arrear_type IN ('A', 'L') AND c.flg_accrual_basis = 'A' AND C.cod_acct_no = B.cod_acct_no AND C.ref_billno_srl = B.ref_billno_srl AND B.dat_value <= C.Dat_Ioa_Grace_Expiry AND :13 > C.dat_arrears_due AND C.dat_ioa_grace_expiry > :14 /* arrears not paid off within the grace period */ AND NOT (C.amt_arrears_due = 0 AND C.dat_ioa_grace_expiry >= C.dat_last_payment )) AMT_ARREARS_PEN FROM (SELECT DISTINCT dat_value dat_baschg_eff FROM ln_arrear_txn_hist D, ln_arrears_table E WHERE D.cod_acct_no = :15 AND D.cod_arrear_type NOT IN ('1', 'R') AND e.flg_accrual_basis = 'A' AND D.cod_acct_no = E.cod_acct_no AND D.ref_billno_srl = E.ref_billno_srl AND :16 > E.dat_arrears_due AND E.dat_ioa_grace_expiry >= :17 AND E.dat_ioa_grace_expiry < :18 /* arrears not paid off within the grace period */ AND NOT (E.amt_arrears_due = 0 AND E.dat_ioa_grace_expiry >= E.dat_last_payment ) AND D.dat_value BETWEEN E.dat_arrears_due AND :19 - 1) A |
| 54dzwh5taaz6k | DECLARE BEGIN :1 := PK_BA_ACCT_ATTR.PROCESS_ATTRIBUTE(:2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 ) ; END; |
| 57y0pr4f329q4 | DECLARE BEGIN :1 := AP_OL_CH_WDR(:2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , :99 , :100 , :101 , :102 , :103 , :104 , :105 , :106 , :107 , :108 , :109 , :110 , :111 , :112 , :113 , :114 , :115 , :116 , :117 , :118 , :119 , :120 , :121 , :122 , :123 , :124 , :125 , :126 , :127 , :128 , :129 , :130 , :131 , :132 , :133 , :134 , :135 , :136 , :137 , :138 , :139 , :140 , :141 , :142 , :143 , :144 , :145 , :146 , :147 , :148 , :149 , :150 , :151 , :152 , :153 , :154 , :155 , :156 , :157 , :158 , :159 , :160 , :161 , :162 , :163 , :164 , :165 , :166 , :167 , :168 , :169 , :170 , :171 , :172 , :173 , :174 , :175 , :176 , :177 , :178 , :179 , :180 , :181 , :182 , :183 , :184 , :185 , :186 , :187 , :188 , :189 , :190 , :191 , :192 , :193 , :194 , :195 , :196 , :197 , :198 , :199 , :200 , :201 , :202 , :203 , :204 , :205 , :206 , :207 , :208 , :209 , :210 , :211 , :212 , :213 , :214 , :215 , :216 , :217 , :218 , :219 , :220 , :221 , :222 , :223 , :224 , :225 , :226 , :227 , :228 , :229 , :230 , :231 , :232 , :233 , :234 , :235 , :236 , :237 , :238 , :239 ) ; END; |
| 5anpz1aj6qzq8 |
select bank0_.COD_BANK as COD1_95_0_, bank0_.FLG_MNT_STATUS as FLG2_95_0_, bank0_.NAM_BANK as NAM3_95_0_, bank0_.cod_lcy as cod4_95_0_, bank0_.flg_auto_acct as flg5_95_0_, bank0_.COD_BANK_IC as COD6_95_0_, bank0_.NAM_BANK_SHRT as NAM7_95_0_, bank0_.cod_bank_identifier as cod8_95_0_, bank0_.cod_iso_country as cod9_95_0_, bank0_.txt_cd_gen_class_name as txt10_95_0_, bank0_.txt_iban_mask as txt11_95_0_, bank0_.TXT_BANK_ADD2 as TXT12_95_0_, bank0_.TXT_BANK_ADD1 as TXT13_95_0_, bank0_.TXT_BANK_ZIP as TXT14_95_0_, bank0_.NAM_BANK_STATE as NAM15_95_0_, bank0_.NAM_BANK_COUNTRY as NAM16_95_0_, bank0_.NAM_BANK_CITY as NAM17_95_0_, bank0_.TXT_BANK_ADD3 as TXT18_95_0_, bank0_.flg_interface as flg19_95_0_, bank0_.DAT_NEXT_PROCESS as DAT20_95_0_, bank0_.DAT_PROCESS as DAT21_95_0_, bank0_.DAT_LAST_PROCESS as DAT22_95_0_, bank0_.DAT_PROC_GL as DAT23_95_0_, bank0_.DAT_PROC_STL as DAT24_95_0_, bank0_.DAT_PROC_CHQ as DAT25_95_0_, bank0_.DAT_PROC_TD as DAT26_95_0_, bank0_.DAT_PROC_LN as DAT27_95_0_, bank0_.COD_FDT_BRIDGE_GL_CR as COD28_95_0_, bank0_.COD_FDT_BRIDGE_GL_DR as COD29_95_0_, bank0_.COD_GL_BANK_CASH as COD30_95_0_, bank0_.COD_GL_VAULT_CASH as COD31_95_0_, bank0_.COD_GL_OVERAGE as COD32_95_0_, bank0_.COD_GL_SHORTAGE as COD33_95_0_, bank0_.COD_IB_IBD_CR as COD34_95_0_, bank0_.COD_IB_IBD_DR as COD35_95_0_, bank0_.COD_GL_SUSPENSE_CR as COD36_95_0_, bank0_.COD_GL_SUSPENSE_DR as COD37_95_0_, bank0_.COD_GL_IB_CR as COD38_95_0_, bank0_.COD_GL_IB_DR as COD39_95_0_, bank0_.COD_GL_FT_INTERNAL as COD40_95_0_, bank0_.COD_FXPROFIT_SUNDRY_GL as COD41_95_0_, bank0_.COD_FX_PROFIT_GL as COD42_95_0_, bank0_.cod_gl_tds as cod43_95_0_, bank0_.cod_gl_tds_2 as cod44_95_0_, bank0_.COD_GL_TDS_RECV as COD45_95_0_, bank0_.COD_GL_TDS_RECV_2 as COD46_95_0_, bank0_.COD_GL_TDS_PAYABLE as COD47_95_0_, bank0_.cod_gl_vat as cod48_95_0_, bank0_.FLG_IBD_CCY as FLG49_95_0_, bank0_.cod_gl_pro_comp_expense as cod50_95_0_, bank0_.cod_contingent_asset_gl as cod51_95_0_, bank0_.cod_contingent_liability_gl as cod52_95_0_, bank0_.cod_last_mnt_chkrid as cod53_95_0_, bank0_.cod_last_mnt_makerid as cod54_95_0_, bank0_.dat_last_mnt as dat55_95_0_, bank0_.ctr_updat_srlno as ctr56_95_0_, bank0_.cod_mnt_action as cod57_95_0_, bank0_.AML_ONLINE_LIMIT_CR as AML58_95_0_, bank0_.AML_ONLINE_LIMIT_DR as AML59_95_0_, bank0_.AML_DAILY_LIMIT_CR as AML60_95_0_, bank0_.AML_DAILY_LIMIT_DR as AML61_95_0_, bank0_.cod_bank_taxid as cod62_95_0_, bank0_.cod_bank_central as cod63_95_0_, bank0_.COD_LO_HO as COD64_95_0_, bank0_.cod_cc_ho as cod65_95_0_, bank0_.cod_ccy_ho as cod66_95_0_, bank0_.ctr_yr_beg_mth as ctr67_95_0_, bank0_.CTR_CLR_PER_DAY as CTR68_95_0_, bank0_.prd_int_indx_rate as prd69_95_0_, bank0_.CTR_IDD_ARR_MAX_DYS as CTR70_95_0_, bank0_.TDS_CIRCLE_REF_NO as TDS71_95_0_, bank0_.rat_var_td_od as rat72_95_0_, bank0_.CTR_TDS_BEGIN_MTH as CTR73_95_0_, bank0_.ctr_week_beg_day as ctr74_95_0_, bank0_.rat_vat as rat75_95_0_, bank0_.FLG_AUTO_MCA_NO_GEN as FLG76_95_0_, bank0_.flg_fis_interface as flg77_95_0_, bank0_.amt_vat as amt78_95_0_, bank0_.frq_rsv_calc as frq79_95_0_, bank0_.flg_hold_amt as flg80_95_0_, bank0_.cod_sc_pkg as cod81_95_0_, bank0_.flg_hold_ft_asset as flg82_95_0_, bank0_.flg_hold_ft_liability as flg83_95_0_, bank0_.lm_reval_freq as lm84_95_0_, bank0_.lm_revaluation_base as lm85_95_0_, bank0_.flg_ib_stl as flg86_95_0_, bank0_.TXT_WEEK_WRK_DAYS as TXT87_95_0_, bank0_.FT_HOLD_EXECUTION as FT88_95_0_, bank0_.AMT_HI_VAL_CHQ as AMT89_95_0_, bank0_.DAT_TDS_YR_END as DAT90_95_0_, bank0_.DAT_VAT_YR_END as DAT91_95_0_, bank0_.DAT_VAT_NEXT_REMIT as DAT92_95_0_, bank0_.dat_oltp_log as dat93_95_0_, bank0_.FRQ_TDS_REMIT as FRQ94_95_0_, bank0_.FRQ_VAT_REMIT as FRQ95_95_0_, bank0_.FLG_CUTOFF_RUN_TODAY as FLG96_95_0_, bank0_.CUTOFF_IN_PROGRESS as CUTOFF97_95_0_, bank0_.CUTOFF_TIM_WAIT as CUTOFF98_95_0_, bank0_.COD_STMT_FLIER as COD99_95_0_, bank0_.lm_last_reval_date as lm100_95_0_, bank0_.lm_next_reva
l_date as lm101_95_0_, bank0_.DAT_TDS_NEXT_REMIT as DAT102_95_0_ from ba_bank_mast bank0_ where bank0_.COD_BANK=:1 and bank0_.FLG_MNT_STATUS=:2 |
| 5ch9429j8jpj2 | SELECT AB.*, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.cod_fcr_hold_no ELSE NULL END FCR_UNHOLD_NO , CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Notice_No ELSE NULL END UNHOLD_COD_NOTICE_NO, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.DAT_POSTING ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN AB.DAT_HOLD_STATUS ELSE NULL END END DAT_UNHOLD_ACTION, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN to_char(auditlogs2.Dat_ACTION, 'HH24:MI:SS') ELSE NULL END UNHOLD_TIME, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Reason ELSE NULL END UNHOLD_HOLD_AUTH, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Last_Mnt_Makerid ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN 'SYSTEM' ELSE NULL END END UNHOLD_MAKER, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Last_Mnt_Chkrid ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN 'SYSTEM' ELSE NULL END END UNHOLD_CHECKER, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Txt_Narrative ELSE NULL END UNHOLD_NARR, CASE WHEN(auditlogs2.cod_action =1 AND cod_hold_status = 3) THEN auditlogs2.COD_PREV_NOTICE_NO ELSE NULL END prev_notice_no FROM (Select * from temp_holdunhold_inq1 tmp WHERE 1 = 1 AND (cod_hold_status = (case when cod_hold_typ = 3 then cod_hold_status else 0 end) or cod_hold_status = (case when cod_hold_typ = 3 then cod_hold_status else 1 end)) AND COD_HOLD_TYP = 3 AND COD_CC_BRN_TXN = 543 ) AB LEFT JOIN ba_hold_audit_log auditlogs2 ON (AB.cod_fcr_hold_no = auditlogs2.Cod_Fcr_Hold_No AND AB.COD_NOTICE_NO = auditlogs2.cod_notice_no AND AB.cod_mc_acct_no = auditlogs2.cod_mc_acct_no) |
| 5hhhad6fhk0tx |
INSERT INTO TEMP_PS_PSBK_DTLS (COD_RECORD_TYP, COD_MC_ACCT_NO, COD_ACCT_NO, COD_DEP_NO, MC_PKG_CODE, REF_TXN_NO, REF_SYS_TR_AUD_NO, REF_USR_NO, CTR_BATCH_NO, COD_CC_BRN_TXN, COD_USERNO, COD_AUTH_ID, DAT_TXN, DAT_VALUE, DAT_POST, REMARK, PURPOSE_CODE, TXT_PURPOSE_DESC, AMT_TXN, COD_MC_ACCT_CCY, COD_TXN_CCY, COD_DRCR, COD_MSG_TYP, AMT_RUNNING_BAL, DEP_VALUE_DATE, DAT_MATURITY, AMT_INT, AMT_TAX, RAT_DEP_INT, CTR_DEP_TERM_DAYS, CTR_DEP_TERM_MONTHS, COD_PAGE_NO, COD_LINE_NO, COD_TXN_MNEMONIC, SESSION_ID, COD_MODULE, COD_PASSBK_LITERAL, REF_SUB_SEQ_NO, ROW_NUM) SELECT COD_RECORD_TYP, COD_MC_ACCT_NO, COD_ACCT_NO, COD_DEP_NO, MC_PKG_CODE, REF_TXN_NO, REF_SYS_TR_AUD_NO, REF_USR_NO, CTR_BATCH_NO, COD_CC_BRN_TXN, COD_USERNO, COD_AUTH_ID, DAT_TXN, DAT_VALUE, DAT_POST, REMARK, PURPOSE_CODE, TXT_PURPOSE_DESC, (CASE WHEN COD_PASSBK_LITERAL = 'RENEW_REINVEST_PAYIN' AND NVL(RENEW_TYPE, ' ') IN ('PO', 'LI') THEN 0 WHEN COD_DEP_NO > 1 AND BAL_INT_PAID = 0 AND COD_PASSBK_LITERAL = 'RENEW_REINVEST_PAYIN' THEN ((SELECT TDMI.BAL_INT_PAID - AMT_TAX - AMT_INT_RECOVERED FROM TD_DEP_MAST TDMI WHERE TDMI.COD_DEP_NO = (INNERQUERY.COD_DEP_NO - 1) AND TDMI.FLG_MNT_STATUS = 'A' AND TDMI.COD_ACCT_NO = INNERQUERY.COD_ACCT_NO)) WHEN COD_DEP_NO > 1 AND COD_PASSBK_LITERAL = 'RENEW_REINVEST_PAYIN' THEN (SELECT TDMI.BAL_INT_PAID - AMT_TAX - AMT_INT_RECOVERED FROM TD_DEP_MAST TDMI WHERE TDMI.COD_DEP_NO = (INNERQUERY.COD_DEP_NO - 1) AND TDMI.FLG_MNT_STATUS = 'A' AND TDMI.COD_ACCT_NO = INNERQUERY.COD_ACCT_NO) WHEN COD_USERNO = 24046 THEN AMT_TXN ELSE AMT_TXN - (AMT_INT - AMT_TAX - AMT_INT_RECOVERED) END) AS AMT_TXN, COD_MC_ACCT_CCY, COD_TXN_CCY, COD_DRCR, COD_MSG_TYP, AMT_RUNNING_BAL, DEP_VALUE_DATE, DAT_MATURITY, AMT_INT, AMT_TAX, RAT_DEP_INT, CTR_DEP_TERM_DAYS, CTR_DEP_TERM_MONTHS, COD_PAGE_NO, COD_LINE_NO, COD_TXN_MNEMONIC, SESSION_ID, COD_MODULE, COD_PASSBK_LITERAL, REF_SUB_SEQ_NO, ROWNUM FROM (SELECT 0 AS COD_RECORD_TYP, :B2 AS COD_MC_ACCT_NO, :B1 AS COD_ACCT_NO, TD.COD_DEP_NO AS COD_DEP_NO, :B10 AS MC_PKG_CODE, TD.REF_TXN_NO AS REF_TXN_NO, TD.REF_SYS_TR_AUD_NO AS REF_SYS_TR_AUD_NO, TD.REF_USR_NO AS REF_USR_NO, TD.CTR_BATCH_NO AS CTR_BATCH_NO, TD.COD_CC_BRN_TXN AS COD_CC_BRN_TXN, TD.COD_USERNO AS COD_USERNO, XF.COD_AUTH_ID AS COD_AUTH_ID, TD.DAT_TXN AS DAT_TXN, TD.DAT_VALUE AS DAT_VALUE, TD.DAT_POST AS DAT_POST, AP_XFACE_GET_TXN_LITERAL(VAR_P_COD_TASK_DERIVED => (CASE WHEN TD.COD_TXN_MNEMONIC = '1358' AND TD.COD_PASSBK_LITERAL IN ('PRM_ADDL_TAX') THEN 'EOD' WHEN TD.COD_PASSBK_LITERAL IN ('RENEW_REINVEST_PAYIN') THEN 'BATCH' ELSE NVL(XF.COD_EXT_TASK, 'EOD') END), VAR_P_COD_TXN_MNEMONIC => NVL(GET_XFACE_ALT_MNEMONIC_CODE(TD.COD_TXN_MNEMONIC, TD.COD_PASSBK_LITERAL), TD.COD_TXN_MNEMONIC), VAR_P_COD_MSG_TYP => (CASE COD_MSG_TYP WHEN 1 THEN 200 WHEN 2 THEN 400 ELSE COD_MSG_TYP END), VAR_COD_MC_ACCT_NO => :B2 , VAR_P_PSBK_NO => :B9 , VAR_P_PSBK_TYPE => :B8 , VAR_P_ALL_IN_ONE_NO => :B7 , VAR_COD_SERVICE => XF.COD_SERVICE_ID, VAR_FLG_PART_FULL_RED => (CASE XF.COD_SERVICE_ID WHEN '213' THEN 'P' WHEN '201' THEN 'P' ELSE NULL END), VAR_P_COD_PSBK_LITERAL => TD.COD_PASSBK_LITERAL) AS REMARK, NVL(XF.COD_EXT_TASK, 'EOD') AS PURPOSE_CODE, GET_PURPOSE_CODE(ACC_PURPOSE_CODE, TD.COD_TXN_MNEMONIC) AS TXT_PURPOSE_DESC, AMT_TXN_ACY AS AMT_TXN, :B6 AS COD_MC_ACCT_CCY, COD_TXN_CCY AS COD_TXN_CCY, NVL(COD_DRCR, 'D') AS COD_DRCR, (CASE COD_MSG_TYP WHEN 200 THEN 1 ELSE 2 END) AS COD_MSG_TYP, AMT_DEP_RUNNING_BAL AS AMT_RUNNING_BAL, NULL AS DEP_VALUE_DATE, NULL AS DAT_MATURITY, INT_AMT AS AMT_INT, TAX_AMT AS AMT_TAX, NULL AS RAT_DEP_INT, NULL AS CTR_DEP_TERM_DAYS, NULL AS CTR_DEP_TERM_MONTHS, NULL AS COD_PAGE_NO, COD_PSBK_LINE_NO AS COD_LINE_NO, TD.COD_TXN_MNEMONIC AS COD_TXN_MNEMONIC, :B5 AS SESSION_ID, 'TD' AS COD_MODULE, COD_PASSBK_LITERAL AS COD_PASSBK_LITERAL, TD.REF_SUB_SEQ_NO AS REF_SUB_SEQ_NO, TD.BAL_INT_PAID, TD.BAL_F
OR_RATE_EARNED, TD.AMT_INT_RECOVERED, NVL(TD.RENEW_TYPE, ' ') AS RENEW_TYPE FROM (SELECT --+index(TDN IN_TD_NOBOOK_1) index(TDM IN_TD_DEP_MAST_1) index(sub in_xface_sub_acct_addnl_dtls_3) TDN.COD_ACCT_NO, TDN.COD_DEP_NO, REF_TXN_NO, REF_SYS_TR_AUD_NO, REF_USR_NO, REF_SUB_SEQ_NO, CTR_BATCH_NO, COD_CC_BRN_TXN, COD_USERNO, COD_AUTH_ID, DAT_TXN, DAT_VALUE, DAT_POST, COD_TXN_CCY, COD_DRCR, CTR_TXN_LEG, COD_MSG_TYP, COD_PSBK_LINE_NO, COD_PASSBK_LITERAL, (SUM(DECODE(TDN.COD_PASSBK_LITERAL, 'REN_PEND_INT', AMT_TXN_ACY, 'PRM_PENALTY_INT', AMT_TXN_ACY, 'INT_PAYABLE', AMT_TXN_ACY, 'POST_RED_PMI_CR', AMT_TXN_ACY, 'SWP_PRE_RED_INT', AMT_TXN_ACY, 'INT_COLLECT_CHQ', AMT_TXN_ACY, 'PRM_PEND_INT', AMT_TXN_ACY, 'POST_RED_PEND_INT', AMT_TXN_ACY, 0)) OVER(PARTITION BY REF_TXN_NO)) INT_AMT, (SUM(DECODE(TDN.COD_PASSBK_LITERAL, 'TAX_COMP_TOTAL', AMT_TXN_ACY, 'SWP_TOTAL_TAX', AMT_TXN_ACY, 'POST_RED_PMI_TOT_TAX', AMT_TXN_ACY, 'PRM_TOTAL_TAX', AMT_TXN_ACY, 'RTX_TOT_ADDL_TAX', AMT_TXN_ACY, 'INT_PAYABLE_TAX', AMT_TXN_ACY, 'TAX_RECOVERED', AMT_TXN_ACY, 0)) OVER(PARTITION BY REF_TXN_NO)) TAX_AMT, (SUM(DECODE(TDN.COD_PASSBK_LITERAL, 'PRM_INT_PAID_DEDUCT', AMT_TXN_ACY, 0)) OVER(PARTITION BY REF_TXN_NO)) AMT_INT_RECOVERED, FLG_PASBKUPD, COD_TXN_MNEMONIC, AMT_TXN_ACY, COD_BANK_LITERAL, 0 AS AMT_DEP_RUNNING_BAL, TDM.BAL_FOR_RATE_EARNED AS BAL_FOR_RATE_EARNED, TDM.BAL_INT_PAID AS BAL_INT_PAID, NVL(SUB.RENEW_TYPE, ' ') AS RENEW_TYPE FROM TD_NOBOOK TDN, TD_DEP_MAST TDM, XFACE_SUB_ACCT_ADDNL_DTLS SUB WHERE TDN.COD_ACCT_NO = :B1 AND TDM.COD_ACCT_NO = :B1 AND TDM.FLG_MNT_STATUS = 'A' AND TDM.COD_DEP_NO = TDN.COD_DEP_NO AND TDN.COD_BANK_LITERAL <> 'SPL' AND TDN.COD_ORG_DEP_NO <> 0 AND DAT_TXN <= :B4 AND DAT_TXN >= :B3 AND SUB.COD_MC_ACCT_NO = :B2 AND TDN.COD_ACCT_NO = SUB.COD_ACCT_NO AND TDN.COD_DEP_NO = SUB.COD_DEP_NO AND TDN.COD_ACCT_NO = :B1 ORDER BY TDN.COD_PSBK_LINE_NO) TD, XFACE_ADDL_DETAILS_TXNLOG XF WHERE TD.COD_DRCR IN ('C', 'D') AND ((TD.COD_BANK_LITERAL = 'TDP' AND TD.COD_PASSBK_LITERAL = 'NET_TD_PAYIN') OR (TD.COD_PASSBK_LITERAL NOT IN ('INT_COMP', 'NET_TD_PAYIN', 'BAT_MAT_PAY_TD_ACCT', 'INT_PAID_BAT_XFER_SB', 'INT_COLLECT_CHQ', 'POST_RED_PEND_INT', 'SI_FROM_SAVINGS'))) AND TD.COD_ACCT_NO = XF.COD_SUB_ACCT_NO(+) AND TD.REF_TXN_NO = XF.REF_TXN_NO(+) AND TRIM(TO_CHAR(TD.CTR_BATCH_NO)) || '~' || TRIM(TO_CHAR(TD.REF_SYS_TR_AUD_NO)) || '~' || TRIM(TO_CHAR(TD.REF_SUB_SEQ_NO)) = XF.REF_KEY_NO(+) AND TD.FLG_PASBKUPD = 'N' AND ((TD.RENEW_TYPE IN ('PO', 'LI') AND TD.COD_PASSBK_LITERAL NOT IN('RENEW_REINVEST_PAYIN')) OR (TD.RENEW_TYPE IN (' ', 'PI'))) AND TD.COD_TXN_MNEMONIC NOT IN (1358, 3113, 3203, 3103) ORDER BY TD.DAT_TXN, TD.COD_DEP_NO, TD.COD_USERNO, TD.CTR_BATCH_NO, TD.REF_SYS_TR_AUD_NO DESC, TD.REF_SUB_SEQ_NO, TD.COD_MSG_TYP, (CASE WHEN (TD.COD_MSG_TYP = 400 AND TD.COD_DRCR = 'D') THEN 'C' WHEN (TD.COD_MSG_TYP = 400 AND TD.COD_DRCR = 'C') THEN 'D' ELSE TD.COD_DRCR END), TD.AMT_TXN_ACY) INNERQUERY |
| 5nt4m831zzt9u | SELECT --+PARALLEL(4) B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, SUM(A.AMT_TXN_HOST), COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host FROM CH_ST_CAP_INPUT_TXN_MMDD A, CH_PROD_MAST B WHERE DAT_POST = TO_DATE('21-03-2013', 'DD-MM-YYYY') AND A.COD_PROD_HOST = B.COD_PROD AND A.COD_DRCR_DEST = 'C' AND COD_CCY_HOST = '156' AND B.COD_GL_INT_PAYABLE = '26003' AND a.cod_cc_brn_host = '856' GROUP BY B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host ORDER BY B.COD_GL_INT_PAYABLE, COD_CCY_HOST, COD_CC_BRN_HOST, A.COD_PROD_HOST |
| 5p55my4r7dd02 | SELECT NVL (SUM(DECODE(COD_DRCR, 'C', AMOUNT, - (AMOUNT))), 0) FROM (SELECT COD_DRCR, (CASE WHEN C.COD_PASSBK_LITERAL = 'RENEW_REINVEST_PAYIN' AND NVL (RENEW_TYPE, ' ') IN ('PO', 'LI') THEN 0 WHEN C.COD_DEP_NO > 1 AND BAL_INT_PAID = 0 AND C.COD_PASSBK_LITERAL = 'RENEW_REINVEST_PAYIN' THEN ((SELECT TDMI.BAL_INT_PAID - AMT_TAX - AMT_INT_RECOVERED FROM TD_DEP_MAST TDMI WHERE TDMI.COD_DEP_NO = (C.COD_DEP_NO - 1) AND TDMI.FLG_MNT_STATUS = 'A' AND TDMI.COD_ACCT_NO = C.COD_ACCT_NO)) WHEN C.COD_DEP_NO > 1 AND C.COD_PASSBK_LITERAL = 'RENEW_REINVEST_PAYIN' THEN (SELECT TDMI.BAL_INT_PAID - AMT_TAX - AMT_INT_RECOVERED FROM TD_DEP_MAST TDMI WHERE TDMI.COD_DEP_NO = (C.COD_DEP_NO - 1) AND TDMI.FLG_MNT_STATUS = 'A' AND TDMI.COD_ACCT_NO = C.COD_ACCT_NO) ELSE AMT_TXN - (AMT_INT - AMT_TAX - AMT_INT_RECOVERED) END) AMOUNT FROM (SELECT TDN.AMT_TXN_TCY AS AMT_TXN, TDN.COD_DEP_NO, TDN.CTR_BATCH_NO, TDN.REF_SYS_TR_AUD_NO, TDN.REF_SUB_SEQ_NO, TDN.DAT_TXN, TDN.COD_DRCR AS FLG_DR_CR, TDN.REF_TXN_NO AS REF_TXN_NO, TDN.COD_TXN_MNEMONIC, TDN.COD_PASSBK_LITERAL, TDN.TXT_TXN_DESC, TDN.DAT_POST, TDN.COD_BANK_LITERAL, TDN.COD_DRCR, TDN.COD_ACCT_NO, (SUM(DECODE(TDN.COD_PASSBK_LITERAL, 'PRM_INT_PAID_DEDUCT', AMT_TXN_ACY, 0)) OVER(PARTITION BY REF_TXN_NO)) AMT_INT_RECOVERED, (SUM(DECODE(TDN.COD_PASSBK_LITERAL, 'REN_PEND_INT', AMT_TXN_ACY, 'PRM_PEND_INT', AMT_TXN_ACY, 'PRM_PENALTY_INT', AMT_TXN_ACY, 'INT_PAYABLE', AMT_TXN_ACY, 'POST_RED_PMI_CR', AMT_TXN_ACY, 'SWP_PRE_RED_INT', AMT_TXN_ACY, 'POST_RED_PEND_INT', AMT_TXN_ACY, 0)) OVER(PARTITION BY REF_TXN_NO)) AMT_INT, (SUM(DECODE(TDN.COD_PASSBK_LITERAL, 'TAX_COMP_TOTAL', AMT_TXN_ACY, 'SWP_TOTAL_TAX', AMT_TXN_ACY, 'POST_RED_PMI_TOT_TAX', AMT_TXN_ACY, 'PRM_TOTAL_TAX', AMT_TXN_ACY, 'RTX_TOT_ADDL_TAX', AMT_TXN_ACY, 'INT_PAYABLE_TAX', AMT_TXN_ACY, 'TAX_RECOVERED', AMT_TXN_ACY, 0)) OVER(PARTITION BY REF_TXN_NO)) AMT_TAX, TDM.BAL_FOR_RATE_EARNED AS BAL_FOR_RATE_EARNED, TDM.BAL_INT_PAID AS BAL_INT_PAID, TDN.COD_TXN_LITERAL, NVL (SUB.RENEW_TYPE, ' ') RENEW_TYPE FROM TD_NOBOOK TDN, TD_DEP_MAST TDM, XFACE_SUB_ACCT_ADDNL_DTLS SUB WHERE TDN.COD_ACCT_NO = :B3 AND TDM.COD_ACCT_NO = :B3 AND TDM.FLG_MNT_STATUS = 'A' AND TDM.COD_DEP_NO = TDN.COD_DEP_NO AND TDN.COD_BANK_LITERAL <> 'SPL' AND TDN.COD_ORG_DEP_NO <> 0 AND TDN.DAT_POST < :B2 AND TDN.COD_ACCT_NO = SUB.COD_ACCT_NO AND TDN.COD_DEP_NO = SUB.COD_DEP_NO AND SUB.COD_MC_ACCT_NO = :B1 ORDER BY TDN.COD_PSBK_LINE_NO) C WHERE C.COD_ACCT_NO = :B3 AND C.COD_DRCR IS NOT NULL AND C.COD_PASSBK_LITERAL IN (SELECT COD_PASSBK_LITERAL FROM TD_TXNLIT_MNEM_XREF WHERE CTR_TXN_LEG = 0 OR (CTR_TXN_LEG != 0 AND CTR_GRP_NO NOT IN (SELECT CTR_GRP_NO FROM TD_TXNLIT_MNEM_XREF WHERE CTR_TXN_LEG = 0))) AND((C.COD_BANK_LITERAL = 'TDP' AND C.COD_PASSBK_LITERAL = 'NET_TD_PAYIN') OR (C.COD_PASSBK_LITERAL NOT IN ('INT_COMP', 'NET_TD_PAYIN', 'BAT_MAT_PAY_TD_ACCT', 'SPL', 'INT_PAID_BAT_XFER_SB', 'INT_PAYABLE'))) AND C.COD_TXN_MNEMONIC NOT IN (1358, 3113, 3203, 1331, 1328, 1317) ORDER BY C.DAT_TXN) B |
| 5sp4zxjxp4tdy | INSERT INTO TEMP_FFI_GL_TXNLOG_CURRENT(SESSION_ID, COD_MSG_TYP, REF_SYS_TR_AUD_NO, REF_SUBSEQ_NO, COD_ORG_MSG_TYP, DAT_TXN, CTR_YR_TXN, DAT_POST, CTR_YR_POST, REF_ORG_STAN, COD_ORG_BRN, COD_USERNO, REF_ORG_SUBSEQ_NO, DAT_ORG_TXN, CTR_YR_ORG_TXN, DAT_ORG_POST, CTR_YR_ORG_POST, DAT_POST_STR, REF_DOC_NO, DAT_INSTR_STR, REF_INSTR_NO_STNO, TXN_NRRTV, FLG_DRCR, AMT_TXN_ACY, AMT_TXN_LCY, DAT_VALUE_STR, COD_PROCESS, COD_PROD, COD_ACCT_NO, REF_TXN_NO, CTR_BATCH_NO, COD_USER_ID, REF_USR_NO) SELECT :B9 , COD_MSG_TYP, REF_SYS_TR_AUD_NO, REF_SUBSEQ_NO, COD_ORG_MSG_TYP, DAT_TXN, CTR_YR_TXN, DAT_POST, CTR_YR_POST, REF_ORG_STAN, COD_ORG_BRN, COD_USERNO, REF_ORG_SUBSEQ_NO, DAT_ORG_TXN, CTR_YR_ORG_TXN, DAT_ORG_POST, CTR_YR_ORG_POST, DAT_POST_STR, REF_DOC_NO , DAT_TXN_STR, REF_INSTR_NO_STNO, SUBSTR(TXN_NRRTV, 1, 40), FLG_DRCR, AMT_TXN_TCY , AMT_TXN_LCY, DAT_VALUE_STR, COD_PROCESS, COD_PROD, COD_ACCT_NO, REF_TXN_NO, CTR_BATCH_NO, COD_USER_ID, REF_USR_NO FROM XF_OL_ST_TXNLOG_CURRENT WHERE TO_NUMBER(TRIM(SUBSTR(COD_ACCT_NO, 5, 16))) = :B8 AND COD_TXN_CCY = :B7 AND COD_CC_BRN = :B6 AND NVL(:B5 , PK_BA_LOB_CODES.GET_INQ_LOB_CODE(DAT_POST_STR, COD_USERNO, CTR_BATCH_NO, REF_SYS_TR_AUD_NO, REF_SUBSEQ_NO, REF_TXN_NO, COD_CC_BRN, COD_ACCT_NO, 'Y')) = PK_BA_LOB_CODES.GET_INQ_LOB_CODE(DAT_POST_STR, COD_USERNO, CTR_BATCH_NO, REF_SYS_TR_AUD_NO, REF_SUBSEQ_NO, REF_TXN_NO, COD_CC_BRN, COD_ACCT_NO, 'Y') AND DAT_POST_STR BETWEEN :B4 AND :B3 AND ABS(AMT_TXN_ACY) BETWEEN :B2 AND :B1 AND COD_PROCESS IN ( 18, 19, 20, 21, 22, 23, 24, 25, 27, 31, 32 ) UNION ALL SELECT :B9 , COD_MSG_TYP, REF_SYS_TR_AUD_NO, REF_SUBSEQ_NO, COD_ORG_MSG_TYP, DAT_TXN, CTR_YR_TXN, DAT_POST, CTR_YR_POST, REF_ORG_STAN, COD_ORG_BRN, COD_USERNO, REF_ORG_SUBSEQ_NO, DAT_ORG_TXN, CTR_YR_ORG_TXN, DAT_ORG_POST, CTR_YR_ORG_POST, DAT_TXN_STR, REF_DOC_NO , DAT_INSTR_STR, REF_INSTR_NO_STNO, SUBSTR(TXN_NRRTV, 1, 40), FLG_DRCR, AMT_TXN_ACY , AMT_TXN_LCY, DAT_VALUE_STR, COD_PROCESS, COD_PROD, COD_ACCT_NO, REF_TXN_NO, CTR_BATCH_NO, COD_USER_ID , REF_USR_NO FROM XF_OL_ST_SCLOG_CURRENT WHERE TO_NUMBER(LTRIM(RTRIM(SUBSTR(COD_ACCT_NO, 5, 16)))) = :B8 AND COD_ACC_CCY = :B7 AND COD_CC_BRN = :B6 AND NVL(:B5 , PK_BA_LOB_CODES.GET_INQ_LOB_CODE(DAT_POST_STR, COD_USERNO, CTR_BATCH_NO, REF_SYS_TR_AUD_NO, REF_SUBSEQ_NO, REF_TXN_NO, COD_CC_BRN, COD_ACCT_NO) ) = PK_BA_LOB_CODES.GET_INQ_LOB_CODE (DAT_POST_STR, COD_USERNO, CTR_BATCH_NO, REF_SYS_TR_AUD_NO, REF_SUBSEQ_NO, REF_TXN_NO, COD_CC_BRN, COD_ACCT_NO ) AND DAT_POST_STR BETWEEN :B4 AND :B3 AND ABS(AMT_TXN_ACY) BETWEEN :B2 AND :B1 AND COD_PROCESS IN ( 18, 19, 20, 21, 22, 23, 24, 25, 27, 31, 32 ) UNION ALL SELECT :B9 , COD_MSG_TYP, REF_SYS_TR_AUD_NO, REF_SUBSEQ_NO, COD_MSG_TYP, DAT_TXN, CTR_YR_TXN, DAT_STL, CTR_YR_STL, ORG_REF_STAN, COD_ORG_BRN, ( SELECT COD_USERNO FROM SM_USER_PROFILE WHERE COD_USER_ID = 'ATM' AND FLG_MNT_STATUS = 'A'), REF_SUBSEQ_NO, DAT_TXN, CTR_YR_STL, DAT_STL, CTR_YR_STL, DAT_POST_STL, RETRIEVAL_REF_NO, SYSDATE, '0', SUBSTR(TXN_NRRTV, 1, 40), DECODE(FLG_DRCR, 'D', 'C', 'C', 'D'), AMT_TXN_ACY, AMT_TXN_LCY, DAT_VALUE_STL, COD_PROCESS, COD_PROD, COD_ACCT_NO, REF_TXN_NO, CTR_BATCH_NO, NULL, REF_USR_NO FROM XF_OL_ST_COTXN WHERE ( CA_TERM_ID IN (SELECT CA_TERM_ID FROM ATM_ACQ_POSID_XREF WHERE ATM_CASH_GL = :B8 AND COD_ORG_BRN = :B6 ) OR TO_NUMBER(LTRIM(RTRIM(SUBSTR(COD_ACCT_NO, 5, 16)))) = :B8 ) AND COD_TXN_CCY = :B7 AND COD_ORG_BRN = :B6 AND DAT_POST_STL BETWEEN :B4 AND :B3 AND ABS(AMT_TXN_ACY) BETWEEN :B2 AND :B1 AND COD_ORIG_PROC IN ('011000', '012000', '013000', '014000', '031000', '032000', '210010', '210020', '210030', '1000', '2000', '200010', '200020') AND COD_EXT_RESP =0 AND COD_REPLY = 0 |
| 5svjwn4dk5knv | SELECT COD_ACCT_SRL_NO FROM OL_MC_RETAIL_ACCT_PSBK_SRLNO WHERE COD_CUSTOMER_ID = :B1 FOR UPDATE |
| 5x6yzh2wn75k1 | INSERT INTO XFACE_TEMP_ACCT_TRANS_INQ (AMOUNT, COD_ACCT_NO, COD_BRANCH, COD_AUTH_ID, COD_USER_ID, COD_TASK_DERIVED, DAT_POST, DAT_TXN, FLG_DR_CR, IS_NXT_PAGE, REF_TXN_NO, TXT_TXN_NARRATIVE, SESSION_ID, ROW_NUM, REF_USR_NO, COD_TXN_MNEMONIC, RUNNING_BALANCE, OTHER_ACCT, OTHER_BRN_NAM, OTHER_ACCT_TITLE, SEQ_NO, TRANSACTION_LITERAL, INVENTORY_CODE, INVENTORY_NO, BANK_INFORMATION_NO, REF_KEY_NO, FLG_STMT_DISPLAY, COD_SERVICE_ID, COD_EXT_TASK, FLG_CA_TT, COD_MSG_TYP, FLG_ONLINE_UPLOAD, COD_TXN_LITERAL, TXT_TXN_DESC, COD_CC_BRN_OTHR_ACCT, NOBK_COD_USERNO, COD_CHNL_ID, COD_MC_ACCT_NO) SELECT AMOUNT, COD_ACCT_NO, COD_BRANCH, COD_AUTH_ID, COD_USER_ID, COD_TASK_DERIVED, DAT_POST, DAT_TXN, FLG_DR_CR, IS_NXT_PAGE, REF_TXN_NO, TXT_TXN_NARRATIVE, SESSION_ID, ROWNUM, REF_USR_NO, COD_TXN_MNEMONIC, RUNNING_BALANCE, OTHER_ACCT, OTHER_BRN_NAM, OTHER_ACCT_TITLE, SEQ_NO, TRANSACTION_LITERAL, INVENTORY_CODE, INVENTORY_NO, BANK_INFORMATION_NO, REF_KEY_NO, FLG_STMT_DISPLAY, COD_SERVICE_ID, COD_EXT_TASK, FLG_CA_TT, COD_MSG_TYP, FLG_ONLINE_UPLOAD, COD_TXN_LITERAL, TXT_TXN_DESC, COD_CC_BRN_OTHR_ACCT, NOBK_COD_USERNO, COD_CHNL_ID, COD_MC_ACCT_NO FROM (SELECT C.AMT_TXN AS AMOUNT, :B3 AS COD_ACCT_NO, C.COD_CC_BRN_TXN AS COD_BRANCH, NVL(T.COD_AUTH_ID, C.COD_AUTH_ID) AS COD_AUTH_ID, T.COD_USER_ID, DECODE(T.REF_TXN_NO_ORG, NULL, T.COD_EXT_TASK, T.COD_EXT_TASK_REV) AS COD_TASK_DERIVED, C.DAT_POST AS DAT_POST, C.DAT_TXN AS DAT_TXN, C.COD_DRCR AS FLG_DR_CR, NVL(T.FLG_STMT_DISPLAY, 'Y') AS IS_NXT_PAGE, C.REF_TXN_NO AS REF_TXN_NO, TXT_TXN_NARRATIVE, :B4 AS SESSION_ID, ROWNUM AS ROW_NUM, NVL(T.REF_USR_NO, C.REF_USR_NO) AS REF_USR_NO, C.COD_TXN_MNEMONIC AS COD_TXN_MNEMONIC, :B5 AS RUNNING_BALANCE, T.COD_OTHER_ACCT_NO AS OTHER_ACCT, '' OTHER_BRN_NAM, '' OTHER_ACCT_TITLE, 0 AS SEQ_NO, '' TRANSACTION_LITERAL, T.INVENTORY_CODE AS INVENTORY_CODE, (CASE WHEN T.INVENTORY_NO IS NULL THEN (CASE WHEN T.CHEQUE_NO IS NULL THEN (CASE WHEN T.CARD_NO IS NULL THEN T.CARD_PASSBOOK_NO ELSE T.CARD_NO END) ELSE T.CHEQUE_NO END) ELSE T.INVENTORY_NO END) AS INVENTORY_NO, T.BANK_INFORMATION_NO AS BANK_INFORMATION_NO, T.REF_KEY_NO AS REF_KEY_NO, T.FLG_STMT_DISPLAY, T.COD_SERVICE_ID, T.COD_EXT_TASK, T.FLG_CA_TT, C.COD_MSG_TYP, T.FLG_ONLINE_UPLOAD, C.COD_TXN_LITERAL, C.TXT_TXN_DESC, T.COD_CC_BRN_OTHR_ACCT, C.COD_USERNO AS NOBK_COD_USERNO, T.COD_CHNL_ID, T.COD_ACCT_NO AS COD_MC_ACCT_NO FROM (SELECT --+index(chn in_ch_nobook_1) * FROM CH_NOBOOK CHN WHERE CHN.COD_ACCT_NO = :B3 AND CHN.DAT_POST BETWEEN :B2 AND :B1 AND CHN.COD_DRCR IS NOT NULL) C, XFACE_ADDL_DTLS_TLOG_TEMP T WHERE C.COD_ACCT_NO = T.COD_SUB_ACCT_NO(+) AND C.REF_TXN_NO = T.REF_TXN_NO(+) AND TRIM(TO_CHAR(C.CTR_BATCH_NO)) || '~' || TRIM(TO_CHAR(C.REF_SYS_TR_AUD_NO)) || '~' || TRIM(TO_CHAR(C.REF_SUB_SEQ_NO)) = NVL(T.REF_KEY_NO(+), TRIM(TO_CHAR(C.CTR_BATCH_NO)) || '~' || TRIM(TO_CHAR(C.REF_SYS_TR_AUD_NO)) || '~' || TRIM(TO_CHAR(C.REF_SUB_SEQ_NO))) AND T.SESSIONID(+) = :B4 ORDER BY C.DAT_TXN, C.DAT_POST, C.DAT_VALUE, C.COD_MSG_TYP, (CASE WHEN (C.COD_MSG_TYP = 400 AND C.COD_DRCR = 'D') THEN 'C' WHEN (C.COD_MSG_TYP = 400 AND C.COD_DRCR = 'C') THEN 'D' ELSE C.COD_DRCR END), (CASE WHEN (T.COD_SERVICE_ID = '001') THEN TO_NUMBER(REPLACE(NVL(T.REF_KEY_NO, TRIM(TO_CHAR(C.CTR_BATCH_NO)) || '~' || TRIM(TO_CHAR(C.REF_SYS_TR_AUD_NO)) || '~' || TRIM(TO_CHAR(C.REF_SUB_SEQ_NO))), '~', '')) ELSE C.AMT_TXN END)) B |
| 5xnf4v0dk0xdk | SELECT COD_INT_INDX FROM CH_INT_RATE_TIER_PLAN WHERE COD_PLAN = :B1 AND COD_INT_TYPE = 'CR' AND COD_TIER_NO = (SELECT MIN(COD_TIER_NO) FROM (SELECT COD_TIER_NO, DECODE(COD_TIER_NO, (MAX(COD_TIER_NO) OVER(PARTITION BY COD_INT_TYPE)), 9.99E18, BAL_INT_TIER) BAL_INT_TIER FROM CH_INT_RATE_TIER_PLAN WHERE COD_PLAN = :B1 AND COD_INT_TYPE = 'CR' AND FLG_MNT_STATUS = 'A') WHERE BAL_INT_TIER >= :B2 AND FLG_MNT_STATUS = 'A' AND DAT_EFFECTIVE = (SELECT MAX(DAT_EFFECTIVE) FROM (SELECT COD_TIER_NO, COD_INT_TYPE, DAT_EFFECTIVE, DECODE(COD_TIER_NO, (MAX(COD_TIER_NO) OVER(PARTITION BY COD_INT_TYPE)), 9.99E18, BAL_INT_TIER) BAL_INT_TIER FROM CH_INT_RATE_TIER_PLAN WHERE COD_PLAN = :B1 AND COD_INT_TYPE = 'CR' AND FLG_MNT_STATUS = 'A') WHERE BAL_INT_TIER >= :B2 )) AND DAT_EFFECTIVE = (SELECT MAX(DAT_EFFECTIVE) FROM (SELECT COD_TIER_NO, COD_INT_TYPE, DAT_EFFECTIVE, DECODE(COD_TIER_NO, (MAX(COD_TIER_NO) OVER(PARTITION BY COD_INT_TYPE)), 9.99E18, BAL_INT_TIER) BAL_INT_TIER FROM CH_INT_RATE_TIER_PLAN WHERE COD_PLAN = :B1 AND COD_INT_TYPE = 'CR' AND FLG_MNT_STATUS = 'A') WHERE BAL_INT_TIER >= :B2 ) AND FLG_MNT_STATUS = 'A' |
| 60fq54sy91442 | DECLARE BEGIN :1 := AP_OL_GL_TXNS(:2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , :99 , :100 , :101 , :102 , :103 , :104 , :105 , :106 , :107 , :108 , :109 , :110 , :111 , :112 , :113 , :114 , :115 , :116 , :117 , :118 , :119 , :120 , :121 , :122 , :123 , :124 , :125 , :126 , :127 , :128 , :129 , :130 , :131 , :132 , :133 , :134 , :135 , :136 , :137 , :138 , :139 , :140 , :141 , :142 , :143 , :144 , :145 , :146 , :147 , :148 , :149 , :150 , :151 , :152 , :153 , :154 , :155 , :156 , :157 , :158 , :159 , :160 , :161 , :162 , :163 , :164 , :165 , :166 , :167 , :168 , :169 , :170 , :171 , :172 , :173 , :174 , :175 , :176 , :177 , :178 , :179 , :180 , :181 , :182 , :183 , :184 , :185 , :186 , :187 , :188 , :189 , :190 , :191 , :192 , :193 , :194 , :195 , :196 , :197 , :198 , :199 , :200 , :201 , :202 , :203 , :204 , :205 , :206 , :207 , :208 , :209 , :210 , :211 , :212 , :213 , :214 , :215 , :216 , :217 , :218 , :219 , :220 , :221 , :222 , :223 , :224 , :225 , :226 , :227 , :228 , :229 , :230 , :231 , :232 , :233 , :234 , :235 , :236 , :237 , :238 , :239 ) ; END; |
| 626d1vhc6gncv | SELECT SUM(AMT_PENALTY) FROM CH_RD_INSTAL_DET WHERE COD_ACCT_NO = (:B1 ).COD_ACCT_NO() AND COD_ONLINE_STAT = 'Paid Today' |
| 65mxdras7gxbr | DECLARE BEGIN :1 := PK_XFACE_INQ_ACCT_BAS_INFO.AP_XFACE_INQ_ACCT_BAS_INFO(:2 , :3 , :4 , :5 ) ; END; |
| 65v5qyggxp5ah |
UPDATE CH_ACCT_MAST SET BAL_LAST_CR_INT_CAP = :B206 , BAL_LAST_DR_INT_CAP = :B205 , DAT_NEXT_CR_INT_CAP = :B204 , DAT_NEXT_DR_INT_CAP = :B203 , DAT_LAST_CR_INT_CAP = :B202 , DAT_LAST_DR_INT_CAP = :B201 , FRQ_CR_INT_CAP = :B200 , FRQ_DR_INT_CAP = :B199 , COD_CR_INT_CAP_BASIS = :B198 , COD_DR_INT_CAP_BASIS = :B197 , CR_INT_CAP_DAY = :B196 , DR_INT_CAP_DAY = :B195 , AMT_CR_INT_ACCR_ADJ = :B194 , AMT_DR_INT_ACCR_ADJ = :B193 , AMT_LAST_CR_INT_ACCR = :B192 , AMT_LAST_DR_INT_ACCR = :B191 , AMT_BKDT_CR_INT = :B190 , AMT_BKDT_DR_INT = :B189 , BP_LINE_SANCTION = :B188 , BP_LINE_UTILIZED = :B187 , DAT_BP_EXPIRY = :B186 , CTR_PSBK_LINE_NO = :B185 , BAL_LST_PSBK = :B184 , DAT_LST_PSBK_UPD = :B183 , COD_CLOSER_ID = :B182 , FLG_ACCT_CLOSE = :B181 , FLG_DORM_SC = :B180 , AMT_SWEEPIN_LIEN = :B179 , FLG_SWEEPIN = :B178 , CTR_DAYS_OVERLINE_CURR = :B177 , CTR_DAYS_OVERLINE_MTD = :B176 , CTR_DAYS_OVERLINE_YTD = :B175 , CTR_DAYS_OVERLINE_LST_YR = :B174 , AMT_PERIODIC_PRODUCT = :B173 , BAL_PREVIOUS = :B172 , FLG_PREV_BAL_STAT = :B171 , COD_MNT_ACTION = :B170 , COD_LAST_MNT_MAKERID = :B169 , COD_LAST_MNT_CHKRID = :B168 , DAT_LAST_MNT = :B167 , CTR_UPDAT_SRLNO = :B166 + 1, DAT_RECALLED = :B165 , DAT_NPL = :B164 , TIMES_OVERLINE_YTD = :B163 , CTR_FUNDS_CR_TODAY = :B162 , FLG_STATUS_RECALLED = :B161 , FLG_STATUS_SECURITIZED = :B160 , FLG_STATUS_CONVERSION = :B159 , FLG_STATUS_LEGAL = :B158 , FLG_REMINDER_GEN = :B157 , FLG_ACCR_STATUS = :B156 , LIMIT_ID = :B155 , ACCT_XFERED_FROM = :B154 , FLG_PDO_OVERRIDE = :B153 , FLG_PAST_DUE_STATUS = :B152 , AMT_COMMIT_FEE = :B151 , AMT_CUM_OD_LIMIT = :B150 , AMT_OD_LIMIT_PREV = :B149 , CTR_TOT_TXNS = :B148 , AMT_INSTAL = :B147 , DAT_MATURITY = :B146 , DAT_OF_RECOVERY = :B145 , CTR_LATE_INSTAL_REMAINING = :B144 , ACCT_TERM_DAYS = :B143 , FRQ_INSTAL = :B142 , RAT_INT_RD = :B141 , AMT_RD_ADVANCE = :B140 , FLG_REPL_CUBE = :B139 , COD_LINE_NO = :B138 , AMT_MATURITY_VALUE = :B137 , RAT_PENALTY = :B136 , DAT_LAST_PENALTY = :B135 , GRACE_DAYS = :B134 , FLG_USE_TIERS_FOR_OD = :B133 , FLG_DR_INT_SRC_CHANGED = :B132 , BAL_TRADING_MIN_REQD = :B131 , FLG_INTEREST_FREEZE = :B130 , COD_CUST_MINOR_STAT = :B129 , FLG_ALLOW_DRWDWN = :B128 , CTR_RETRIES = :B127 , DAT_NEXT_RETRY = :B126 , DAT_MATURITY_EXEC = :B125 , COD_TDS_2 = :B124 , AMT_TAX_ACCR_2 = :B123 , AMT_EXEMPT_LIMIT_2 = :B122 , COD_SC_PKG = :B121 , FLG_DISALLOW_BRN = :B120 , COD_CC_BRN = :B119 , COD_PROD = :B118 , COD_ACCT_NO = :B117 , COD_OFFICR_ID = :B116 , DAT_ACCT_OPEN = :B115 , COD_ACCT_TITLE = :B114 , COD_CUST = :B113 , NAM_CUST_SHRT = :B112 , NAM_NOMINEE = :B111 , COD_CCY = :B110 , COD_ACCT_STAT = :B109 , COD_LANG = :B108 , COD_TDS = :B107 , BAL_ACCT_MIN_REQD = :B106 , FLG_JOINT_ACCT = :B105 , FLG_ADHOC_STMNT = :B104 , FLG_STP_PMNT = :B103 , FLG_SI = :B102 , FLG_SWPOUT = :B101 , FLG_IDD_AUTH = :B100 , FLG_TDS = :B99 , FLG_VAT = :B98 , AMT_EXEMPT_LIMIT = :B97 , FLG_GRP_BONUS = :B96 , FLG_ATM = :B95 , CTR_INT_SC_XFER = :B94 , COD_ACCT_NO_GRP_INT = :B93 , COD_ACCT_NO_GRP_SC = :B92 , RAT_VAR_CR_INT = :B91 , REF_CHQ_NO_LST_ISSD = :B90 , REF_CHQ_NO_LST_USED = :B89 , FLG_SPECIAL_STMNT = :B88 , FLG_REST_ACCT = :B87 , FLG_EMP_ACCT = :B86 , FLG_HOLD_MAIL = :B85 , FLG_MAIL_ADD_CTRL = :B84 , FLG_ADDTNL_ADRS = :B83 , FLG_MEMO = :B82 , FLG_DR_AUTH = :B81 , FLG_PSBOOK = :B80 , AMT_OD_LIMIT = :B79 , DAT_ST_UNCL_ADVNC = :B78 , AMT_UNCLR_ADVNC_LIM = :B77 , RAT_UNCLR_ADVNC_PCT = :B76 , DAT_EXP_UNCLR_ADVNC = :B75 , CTR_DAYS_OD_CURR = :B74 , CTR_DAYS_OD_MTD = :B73 , CTR_DAYS_OD_YTD = :B72 , CTR_DAYS_OD_LST_YR = :B71 , CTR_STMNT_COPIES = :B70 , CTR_DAY_STMNT_GEN = :B69 , BAL_BOOK = :B68 , AMT_UNCLR = :B67 , AMT_AUTH_DR = :B66 , AMT_HLD = :B65 , BAL_AVAILABLE = :B64 , AMT_CLR_TODAY = :B63 , AMT_DR_TODAY = :B62 , AMT_CR_TODAY = :B61 , AMT_DR_MTD = :B60 , AMT_CR_MTD = :B59 , AMT_DR_YTD = :B58 , AMT_CR_YTD = :B57 , CTR_DR_TODAY = :B56 , CTR_CR_T
ODAY = :B55 , CTR_DR_MTD = :B54 , CTR_CR_MTD = :B53 , CTR_DR_YTD = :B52 , CTR_CR_YTD = :B51 , AMT_LAST_DR = :B50 , DAT_LAST_DR = :B49 , AMT_LAST_CR = :B48 , DAT_LAST_CR = :B47 , DAT_LAST_STMNT = :B46 , BAL_LAST_STMNT = :B45 , BAL_MIN_MONTH = :B44 , CTR_YTD_STMNT_NO = :B43 , CTR_NUM_WITHDRAW = :B42 , CTR_NUM_CHQ_WITHDRAW = :B41 , CTR_CHQ_REORDER = :B40 , DAT_LAST_INT_CAP = :B39 , DAT_LAST_SC_CAP = :B38 , AMT_CR_INT_ACCR_LAST_CAP = :B37 , AMT_DR_INT_ACCR_LAST_CAP = :B36 , AMT_TAX_ACCR = :B35 , AMT_ADB_PRODUCT = :B34 , DAT_LAST_INT_COMP = :B33 , BAL_LAST_INT_CAP = :B32 , AMT_TOT_DR = :B31 , AMT_TOT_CR = :B30 , BAL_LAST_SC_CAP = :B29 , DAT_LAST_NSF = :B28 , CTR_NSF_ITEM_YTD = :B27 , CTR_NSF_ITEM = :B26 , FLG_INT_WAIVER = :B25 , FLG_SC_WAIVER = :B24 , FLG_SC_WAIVER_CUST = :B23 , BMP_SC_WAIVER = :B22 , COD_INT_SC_ACCT_NO = :B21 , AMT_YTD_INT_PAID = :B20 , AMT_YTD_INT_RECD = :B19 , AMT_YTD_SC = :B18 , AMT_DR_INT_ACCR = :B17 , AMT_CR_INT_ACCR = :B16 , AMT_DR_INT_COMP = :B15 , AMT_CR_INT_COMP = :B14 , AMT_CR_ROUNDING_DIFFERENCE = :B13 , AMT_DR_ROUNDING_DIFFERENCE = :B12 , CREDIT_CONFIRMATION_BAL = :B11 , DEBIT_CONFIRMATION_BAL = :B10 , COD_AER = :B9 , COD_AMT_UNUSED_LIMIT = :B8 , COD_SC_XFER_ACCT_NO = TO_CHAR(:B7 ), COD_CR_INT_XFER_ACCT_NO = TO_CHAR(:B6 ), COD_DR_INT_XFER_ACCT_NO = TO_CHAR(:B5 ), CTR_PERIODIC_DAYS = :B4 , CTR_ACCR_BASIS_DAYS = :B3 WHERE COD_ACCT_NO = :B2 AND FLG_MNT_STATUS = 'A' AND CTR_UPDAT_SRLNO = :B1 |
| 65zx7xdd3md6m | DECLARE BEGIN :1 := AP_TD_VAL_REDEEM_ACCT(:2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 ) ; END; |
| 675skymxpp9dp | DECLARE BEGIN :1 := PK_FFI_GL_TXN_INQUIRY.AP_FFI_GL_TXN_INQUIRY(:2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 ) ; END; |
| 67bnbrzctgdk0 | SELECT COD_INT_INDX, RAT_INT_VAR FROM CH_INT_RATE_TIER_PLAN WHERE COD_PLAN = :B1 AND COD_INT_TYPE = 'CR' AND COD_TIER_NO = (SELECT MIN(COD_TIER_NO) FROM (SELECT COD_TIER_NO, DECODE(COD_TIER_NO, (MAX(COD_TIER_NO) OVER(PARTITION BY COD_INT_TYPE)), 9.99E18, BAL_INT_TIER) BAL_INT_TIER FROM CH_INT_RATE_TIER_PLAN WHERE COD_PLAN = :B1 AND COD_INT_TYPE = 'CR' AND FLG_MNT_STATUS = 'A') WHERE BAL_INT_TIER >= :B2 AND FLG_MNT_STATUS = 'A' AND DAT_EFFECTIVE = (SELECT MAX(DAT_EFFECTIVE) FROM (SELECT COD_TIER_NO, COD_INT_TYPE, DAT_EFFECTIVE, DECODE(COD_TIER_NO, (MAX(COD_TIER_NO) OVER(PARTITION BY COD_INT_TYPE)), 9.99E18, BAL_INT_TIER) BAL_INT_TIER FROM CH_INT_RATE_TIER_PLAN WHERE COD_PLAN = :B1 AND COD_INT_TYPE = 'CR' AND FLG_MNT_STATUS = 'A') WHERE BAL_INT_TIER >= :B2 )) AND DAT_EFFECTIVE = (SELECT MAX(DAT_EFFECTIVE) FROM (SELECT COD_TIER_NO, COD_INT_TYPE, DAT_EFFECTIVE, DECODE(COD_TIER_NO, (MAX(COD_TIER_NO) OVER(PARTITION BY COD_INT_TYPE)), 9.99E18, BAL_INT_TIER) BAL_INT_TIER FROM CH_INT_RATE_TIER_PLAN WHERE COD_PLAN = :B1 AND COD_INT_TYPE = 'CR' AND FLG_MNT_STATUS = 'A') WHERE BAL_INT_TIER >= :B2 ) AND FLG_MNT_STATUS = 'A' |
| 69skxdk34662k | SELECT amt_instal as amtInstal FROM ch_acct_mast WHERE flg_mnt_status = 'A' AND cod_acct_no = CAST( :1 as CHAR(16)) |
| 6d1qdy8dn2wj1 | UPDATE TD_DEP_PRORATED_TAX_DTLS A SET A.FLG_PAID = 'Y', A.DAT_TAX_PAID = :B3 WHERE A.COD_ACCT_NO = :B2 AND A.COD_DEP_NO = :B1 AND A.FLG_PAID='N' |
| 6dcrrvn2t89yu | SELECT SYSDATE, DATEDIFF ( DD , DAT_LAST_INT_COMP , :B2 ), 0 , 0, 0.0, 0, 0.0 , 0.0 , 0.0 , 0.0 , COD_CC_BRN, COD_PROD, CTR_STMNT_COPIES, FLG_ADDTNL_ADRS, FLG_HOLD_MAIL, FLG_MAIL_ADD_CTRL, AMT_TAX_ACCR , CTR_NUM_CHQ_WITHDRAW, NVL(RAT_INT_RD, 0.00), BMP_SC_WAIVER, COD_OFFICR_ID, COD_CUST, NAM_CUST_SHRT, COD_ACCT_STAT, COD_LANG, FLG_TDS, FLG_GRP_BONUS, COD_ACCT_NO_GRP_INT, FLG_REST_ACCT, FLG_EMP_ACCT, AMT_OD_LIMIT, CTR_DAYS_OD_CURR, CTR_DAYS_OD_MTD, CTR_DAYS_OD_YTD, CTR_DAYS_OD_LST_YR, CTR_DAYS_OD_LST_YR, CTR_DAYS_OVERLINE_CURR, CTR_DAYS_OVERLINE_MTD, CTR_DAYS_OVERLINE_YTD, CTR_DAYS_OVERLINE_LST_YR, BAL_BOOK, BAL_BOOK, AMT_UNCLR, BAL_AVAILABLE, NVL(AMT_DR_TODAY, 0), NVL(AMT_CR_TODAY, 0), NVL(AMT_DR_YTD, 0), NVL(AMT_CR_YTD, 0), NVL(CTR_DR_TODAY, 0), NVL(CTR_CR_TODAY, 0), NVL(CTR_DR_YTD, 0), NVL(CTR_CR_YTD, 0), AMT_LAST_DR, DAT_LAST_DR, AMT_LAST_CR, DAT_LAST_CR, DAT_LAST_INT_CAP, BAL_LAST_INT_CAP, CTR_NSF_ITEM_YTD, NVL(FLG_INT_WAIVER, 'N'), NVL(FLG_SC_WAIVER, 'N'), DAT_ACCT_OPEN, FLG_DORM_SC, DAT_LAST_SC_CAP, BAL_LAST_SC_CAP, FLG_ATM, FLG_ACCT_CLOSE, COD_INT_SC_ACCT_NO, AMT_YTD_INT_PAID, AMT_YTD_SC, AMT_HLD, AMT_DR_INT_ACCR, AMT_CR_INT_ACCR, AMT_YTD_INT_RECD, DAT_LST_PSBK_UPD, AMT_CR_INT_COMP, AMT_DR_INT_COMP, BAL_LST_PSBK, AMT_TOT_DR, AMT_TOT_CR, AMT_CR_INT_COMP, AMT_DR_INT_COMP, AMT_CLR_TODAY, BAL_MIN_MONTH, DAT_LAST_INT_COMP, AMT_BKDT_CR_INT, AMT_BKDT_DR_INT, CTR_NUM_WITHDRAW, AMT_LAST_CR_INT_ACCR, AMT_LAST_DR_INT_ACCR, CTR_UPDAT_SRLNO, COD_TDS, BAL_PREVIOUS, FLG_PREV_BAL_STAT, BAL_ACCT_MIN_REQD, AMT_PERIODIC_PRODUCT, AMT_ADB_PRODUCT, DAT_EXP_UNCLR_ADVNC, DAT_ST_UNCL_ADVNC, AMT_UNCLR_ADVNC_LIM, RAT_UNCLR_ADVNC_PCT, REF_CHQ_NO_LST_ISSD, FLG_ATM, AMT_EXEMPT_LIMIT, CTR_DR_MTD, CTR_CR_MTD, AMT_DR_MTD, AMT_DR_MTD, COD_TDS_2, AMT_TAX_ACCR_2, AMT_EXEMPT_LIMIT_2, 0.0, 0.0, FLG_USE_TIERS_FOR_OD FROM CH_ACCT_MAST WHERE COD_ACCT_NO = :B1 AND FLG_MNT_STATUS = 'A' |
| 6ds0qfh6wz25s | INSERT INTO XFACE_TEMP_CUST_ACCT_INQ (COD_MC_ACCT_NO, COD_ACCT_NO, COD_ACCT_TITLE, COD_PROD, COD_ACCT_TYP, COD_DEP_NO, COD_DAT_VALUE, COD_DEP_INT, COD_FLG_AUTO_RENEW, COD_RENEW_TYP, COD_BAL_BOOK, COD_HOLD_AMT, COD_BAL_AVAILABLE, COD_NET_BAL, COD_PRINCIPLE_BAL, COD_DAT_ACCT_OPEN, COD_CC_BRN, COD_NAM_CC_BRN, COD_ACCT_STATUS, COD_CCY, COD_DAT_MATURITY, COD_DEP_TERM, COD_AMT_OD_LIMIT, COD_INVENTORY_NO) (SELECT A.COD_MC_ACCT_NO, B.COD_ACCT_NO, A.COD_MCA_TITLE, B.COD_PROD, A.COD_MODULE, 0, '', 0, '', '', 0, 0, 0, 0, 0, A.DAT_MCA_OPEN, A.COD_CC_BRN, ' ', A.COD_MCA_STAT, B.COD_CCY, '', '', 0, '' FROM MC_ACCT_MAST A, MC_ACCT_XREF B WHERE A.COD_CUST_ID = :B4 AND A.COD_CUST_ID = B.COD_CUST_ID AND A.COD_MC_ACCT_NO = B.COD_MC_ACCT_NO AND (A.COD_MODULE = DECODE(NVL(:B3 , ''), '', A.COD_MODULE, 'TD', :B3 ) OR ((:B3 = 'CH') AND A.COD_MODULE IN (:B3 , 'RD'))) AND B.COD_PROD = DECODE(NVL(:B2 , 0), 0, B.COD_PROD, :B2 ) AND A.COD_CC_BRN = DECODE(NVL(:B1 , 0), 0, A.COD_CC_BRN, :B1 ) AND A.COD_MODULE IN ('CH', 'TD', 'RD') AND COD_ACCT_NO NOT IN (SELECT COD_ACCT_NO_SWPIN FROM CH_SWEEPIN CS WHERE CS.COD_ACCT_NO = B.COD_ACCT_NO AND CS.FLG_MNT_STATUS = 'A') AND B.COD_PROD NOT IN (SELECT X.COD_PROD FROM BA_PROD_TYPE_MAST P, BA_PROD_PRODTYPE_XREF X WHERE P.COD_PROD_TYPE IN (6, 7) AND P.COD_PROD_TYPE = X.COD_PROD_TYPE AND P.FLG_MNT_STATUS = 'A' AND X.FLG_MNT_STATUS = 'A') AND A.COD_MODULE = B.COD_MODULE AND A.FLG_MNT_STATUS = 'A' AND B.FLG_MNT_STATUS = 'A') |
| 6fuvcmrp9844w | SELECT COD_LAST_MNT_MAKERID FROM EXT_FILE_UPLOAD_MAST A WHERE A.COD_FILE_ID = :B1 AND A.FLG_MNT_STATUS = 'A' |
| 6khu24nwm9ah4 | DECLARE BEGIN :1 := AP_CM_RD_EXCHANGE_RATES(:2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 ) ; END; |
| 6m2tgtmzpygkf | UPDATE EXT_BLKFNDXFER_DETAILRECDTO SET COMMENTS = 'Success', RECORDSTATUS = 5 WHERE FILEID = :B2 AND RECORDID = :B1 AND RECORDSTATUS = 1 |
| 6ph55y3subkjp | SELECT * FROM BA_BANK_MAST WHERE FLG_MNT_STATUS = 'A' |
| 6pmk21y69yrcp | SELECT BAL_AVAILABLE, AMT_HLD, AMT_UNCLR, AMT_AUTH_DR, AMT_OD_LIMIT, 93, NAM_CUST_SHRT, COD_CUST FROM CH_ACCT_MAST WHERE COD_ACCT_NO = :B2 AND FLG_MNT_STATUS = 'A' AND CTR_UPDAT_SRLNO = :B1 |
| 6q02dbx82jzr3 | insert into EXT_BLKFNDXFER_FOOTERRecDTO (TotalAmount, TotalCount, recordType, recordName, data, length, comments, recordStatus, recordId, fileId) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 ) |
| 6q5uv9t089npw | DECLARE BEGIN :1 := PK_AT_AUDIT_TRAIL_LOG.AP_AT_MOW_GLOBAL_AUDIT(:2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 ) ; END; |
| 6q7j7sb1q46xg | UPDATE CH_ACCT_MAST SET BAL_AVAILABLE = BAL_AVAILABLE - NVL(:B8 , 0) + NVL(:B7 , 0) + NVL(:B6 , 0) - NVL(:B5 , 0), CTR_NUM_WITHDRAW = CTR_NUM_WITHDRAW + :B4 , CTR_NUM_CHQ_WITHDRAW = :B3 , CTR_UPDAT_SRLNO = CTR_UPDAT_SRLNO + 1 WHERE COD_ACCT_NO = :B2 AND FLG_MNT_STATUS = 'A' AND CTR_UPDAT_SRLNO = :B1 |
| 6rfh952w08a95 | DECLARE BEGIN :1 := AP_TD_TXN_PAYIN(:2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 ) ; END; |
| 6ugqh71ppc6x6 | select ba.ext_cod_txn_literal as txnLiterals from ba_fw_txn_cod_xref ba, ch_nobook ch where ba.ext_cod_txn_mnemonic in (select trim(rc.cod_ext_task) from xface_addl_details_txnlog rc where rc.ref_txn_no = CAST(:1 as CHAR(40)) and rc.cod_sub_acct_no = CAST(:2 as CHAR(16))) and ba.cod_txn_mnemonic = ch.cod_txn_mnemonic and ch.ref_txn_no = CAST(:3 as CHAR(40)) and ch.cod_acct_no = CAST(:4 as CHAR(16)) |
| 6xu1591k8bzvs | UPDATE EXT_BLKFNDXFER_HEADERRECDTO DTO SET DTO.AMT_TXN_CR_DR = :B2 WHERE FILEID = :B1 |
| 6y6pwnkjd0y02 | SELECT A.FILE_TYPE, A.COD_XF_SYSTEM, A.NAM_HOFF_FILE, A.COD_LAST_MNT_MAKERID, A.COD_LAST_MNT_CHKRID, A.CTR_BATCH_NO, A.TXT_NRRTV, A.DAT_TIM_PROC_START, A.DAT_TIM_PROC_END, A.COD_ORG_BRN, A.DAT_FILE_PROCESS, A.COD_LAST_MNT_MAKERID FROM EXT_FILE_UPLOAD_MAST A WHERE A.COD_FILE_ID = :B1 AND A.FLG_MNT_STATUS = 'A' |
| 70j0v2qhw8xk6 | SELECT COD_CC_BRN, COD_PROD, DAT_LAST_INT_CAP FROM CH_ACCT_MAST WHERE COD_ACCT_NO = :B1 AND FLG_MNT_STATUS = 'A' |
| 7h75jhvpbcanp | insert into EXT_BLKFNDXFER_HEADERRecDTO (DeductionMode, PayDedctFlg, CardNumber, AccountNumber, GLAcctBranch, AccountCurrency, AccountName, RemoveEarmarkFlg, EarmarkCounter, EarmarkPostingDate, EarmarkType, ExtSysTxnMnemonicCode, recordType, recordName, data, length, comments, recordStatus, UserReferenceNumber, recordId, fileId) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 ) |
| 7hpu4yuddyt1m | SELECT COUNT(1) FROM TD_DEP_PRORATED_TAX_DTLS A WHERE A.FLG_PAID = 'N' AND A.FLG_ROW_TYPE = 1 AND COD_ACCT_NO = :B2 AND COD_DEP_NO = :B1 |
| 7p7dx39ukgbc4 | UPDATE CH_ACCT_MAST SET AMT_HLD = AMT_HLD + :B2 , CTR_UPDAT_SRLNO = CTR_UPDAT_SRLNO + 1 WHERE COD_ACCT_NO = :B1 AND FLG_MNT_STATUS = 'A' |
| 7rcxbp0kw697b | insert into VWE_TD_PAYOUT_INSTR_DETAILS (cod_last_mnt_chkrid, cod_last_mnt_makerid, dat_last_mnt, ctr_updat_srlno, cod_mnt_action, FLG_ADD_PENDING_INT, FRQ_INT_COMPOUND, FLG_PRINT, FLG_PART_FULL, COD_PAYOUT_TYPE, COD_ACCT_NO_BENEF, COD_CC_BRN, CTR_DEP_TERM, FRQ_INT_PAY, RAT_DEP_INT_VAR, COD_PAYOUT_MODE, FLG_FIXED_PERCENT, DAT_VALUE, CTR_PRIORITY_NO, NAM_BENEF, COD_CC_NONFW_BRN, AMT_TXN_ACY, FLG_ALL_DEPOSITS, AMOUNT_PERCENT, AMT_PRE_PAYOUT, COD_TXN_CCY, AMT_PAYOUT, FLG_BASE_FOR_RATE, COD_NOTICE_NO, COD_DEP_NO_BENEF, FLG_PAYIN_TYPE, COD_ACCT_NO, COD_DEP_NO, CTR_INST_NO, FLG_MNT_STATUS) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 ) |
| 7v4y0haay5ra8 | SELECT --+PARALLEL(4) B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, SUM(A.AMT_TXN_HOST), COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host FROM CH_ST_CAP_INPUT_TXN_MMDD A, CH_PROD_MAST B WHERE DAT_POST = TO_DATE('21-03-2013', 'DD-MM-YYYY') AND A.COD_PROD_HOST = B.COD_PROD AND A.COD_DRCR_DEST = 'C' AND COD_CCY_HOST = '156' AND B.COD_GL_INT_PAYABLE = '26003' AND a.cod_cc_brn_host = '854' GROUP BY B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host ORDER BY B.COD_GL_INT_PAYABLE, COD_CCY_HOST, COD_CC_BRN_HOST, A.COD_PROD_HOST |
| 7ynn6us6mb6dx | SELECT --+PARALLEL(4) B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, SUM(A.AMT_TXN_HOST), COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host FROM CH_ST_CAP_INPUT_TXN_MMDD A, CH_PROD_MAST B WHERE DAT_POST = TO_DATE('21-03-2013', 'DD-MM-YYYY') AND A.COD_PROD_HOST = B.COD_PROD AND A.COD_DRCR_DEST = 'C' AND COD_CCY_HOST = '156' AND B.COD_GL_INT_PAYABLE = '26003' AND a.cod_cc_brn_host = '846' GROUP BY B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host ORDER BY B.COD_GL_INT_PAYABLE, COD_CCY_HOST, COD_CC_BRN_HOST, A.COD_PROD_HOST |
| 80rw3ujr4ujck | SELECT --+PARALLEL(4) B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, SUM(A.AMT_TXN_HOST), COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host FROM CH_ST_CAP_INPUT_TXN_MMDD A, CH_PROD_MAST B WHERE DAT_POST = TO_DATE('21-03-2013', 'DD-MM-YYYY') AND A.COD_PROD_HOST = B.COD_PROD AND A.COD_DRCR_DEST = 'C' AND COD_CCY_HOST = '156' AND B.COD_GL_INT_PAYABLE = '26003' AND a.cod_cc_brn_host = '851' GROUP BY B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host ORDER BY B.COD_GL_INT_PAYABLE, COD_CCY_HOST, COD_CC_BRN_HOST, A.COD_PROD_HOST |
| 816ugvs59jsyr | UPDATE CH_ACCT_MAST SET BAL_BOOK = (:B7 ).BAL_BOOK() + :B6 - :B5 + :B3 - :B4 , BAL_AVAILABLE = (:B7 ).BAL_AVAILABLE() + :B6 - :B5 + :B3 - :B4 , AMT_CR_INT_ACCR_LAST_CAP = :B3 , CTR_UPDAT_SRLNO = :B2 + 1, COD_ACCT_STAT = 5 WHERE COD_ACCT_NO = :B1 AND FLG_MNT_STATUS = 'A' |
| 84cqxts216bdf | SELECT SUM(DECODE(COD_DRCR, 'C', AMT_TXN, -AMT_TXN)) FROM CH_NOBOOK WHERE DAT_POST < :B2 AND COD_ACCT_NO IN (:B1 , (SELECT A.COD_AGMT_SUB_ACCT_NO FROM XFACE_SUB_ACCT_ADDNL_DTLS A WHERE A.COD_MC_ACCT_NO = :B3 AND A.COD_ACCT_NO = :B1 AND A.COD_DEP_NO = 0)) AND COD_DRCR IS NOT NULL |
| 84rn9fqu4cpnz | SELECT AB.*, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.cod_fcr_hold_no ELSE NULL END FCR_UNHOLD_NO , CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Notice_No ELSE NULL END UNHOLD_COD_NOTICE_NO, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.DAT_POSTING ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN AB.DAT_HOLD_STATUS ELSE NULL END END DAT_UNHOLD_ACTION, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN to_char(auditlogs2.Dat_ACTION, 'HH24:MI:SS') ELSE NULL END UNHOLD_TIME, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Reason ELSE NULL END UNHOLD_HOLD_AUTH, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Last_Mnt_Makerid ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN 'SYSTEM' ELSE NULL END END UNHOLD_MAKER, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Last_Mnt_Chkrid ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN 'SYSTEM' ELSE NULL END END UNHOLD_CHECKER, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Txt_Narrative ELSE NULL END UNHOLD_NARR, CASE WHEN(auditlogs2.cod_action =1 AND cod_hold_status = 3) THEN auditlogs2.COD_PREV_NOTICE_NO ELSE NULL END prev_notice_no FROM (Select * from temp_holdunhold_inq1 tmp WHERE 1 = 1 AND (cod_hold_status = (case when cod_hold_typ = 3 then cod_hold_status else 0 end) or cod_hold_status = (case when cod_hold_typ = 3 then cod_hold_status else 1 end)) AND COD_HOLD_TYP = 3 AND COD_CC_BRN_TXN = 165 ) AB LEFT JOIN ba_hold_audit_log auditlogs2 ON (AB.cod_fcr_hold_no = auditlogs2.Cod_Fcr_Hold_No AND AB.COD_NOTICE_NO = auditlogs2.cod_notice_no AND AB.cod_mc_acct_no = auditlogs2.cod_mc_acct_no) |
| 89kvzhyjv6j1k | SELECT COD_PROD, COD_ACCT_STAT, COD_CC_BRN, COD_CCY, FLG_PSBOOK, FLG_DISALLOW_BRN, BAL_LST_PSBK, FLG_MEMO, FLG_REST_ACCT, FLG_EMP_ACCT, CTR_UPDAT_SRLNO, COD_CUST, BAL_AVAILABLE FROM CH_ACCT_MAST WHERE COD_ACCT_NO = :B1 AND FLG_MNT_STATUS = 'A' FOR UPDATE NOWAIT |
| 8f7vqxvs96nwp | SELECT GROUP_ID FROM BA_PROD_GROUP_LIMIT_DTLS WHERE LIMIT_ID = (SELECT LIMIT_ID FROM BA_PROD_GROUP_LIMIT_DTLS WHERE CHANNEL_ID = :B1 AND GROUP_ID = :B2 AND FLG_MNT_STATUS = 'A' AND FLG_IB = 'N' AND COD_PROD = (SELECT COD_PROD FROM CS_HO_CUSTACCTXREF WHERE COD_ACCT_NO = :B3 ) AND DAT_EFFECTIVE = (SELECT MAX(DAT_EFFECTIVE) FROM BA_PROD_GROUP_LIMIT_DTLS WHERE CHANNEL_ID = :B1 AND GROUP_ID = :B2 AND FLG_MNT_STATUS = 'A' AND FLG_IB = 'N' AND COD_PROD = (SELECT COD_PROD FROM CS_HO_CUSTACCTXREF WHERE COD_ACCT_NO = :B3 ))) AND COD_PROD = (SELECT COD_PROD FROM CS_HO_CUSTACCTXREF WHERE COD_ACCT_NO = :B3 ) AND FLG_IB = 'N' AND CHANNEL_ID = :B1 AND FLG_MNT_STATUS = 'A' |
| 8jf9ytvw0w7nh | SELECT --+PARALLEL(4) B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, SUM(A.AMT_TXN_HOST), COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host FROM CH_ST_CAP_INPUT_TXN_MMDD A, CH_PROD_MAST B WHERE DAT_POST = TO_DATE('21-03-2013', 'DD-MM-YYYY') AND A.COD_PROD_HOST = B.COD_PROD AND A.COD_DRCR_DEST = 'C' AND COD_CCY_HOST = '156' AND B.COD_GL_INT_PAYABLE = '26003' AND a.cod_cc_brn_host = '857' GROUP BY B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host ORDER BY B.COD_GL_INT_PAYABLE, COD_CCY_HOST, COD_CC_BRN_HOST, A.COD_PROD_HOST |
| 8ssqbs7jb9w2y | SELECT COALESCE(THROUGH_CCY, '???'), OFFSET_RECORD, QUOTATION, NO_OF_UNITS FROM CYTB_CCY_PAIR WHERE CCY1 = :B2 AND CCY2 = :B1 |
| 8whg0grxpx198 | select xfacesubac0_.COD_MC_ACCT_NO as COD1_67_0_, xfacesubac0_.COD_ACCT_NO as COD2_67_0_, xfacesubac0_.COD_DEP_NO as COD3_67_0_, xfacesubac0_.COD_CCY as COD4_67_0_, xfacesubac0_.ACCOUNT_PROPERTY as ACCOUNT5_67_0_, xfacesubac0_.INVENTORY_CODE as INVENTORY6_67_0_, xfacesubac0_.INVENTORY_NO as INVENTORY7_67_0_, xfacesubac0_.cod_agmt_sub_acct_no as cod8_67_0_, xfacesubac0_.RECON_CODE as RECON9_67_0_, xfacesubac0_.DEPUTY_IC_CHECK_RETURN_CODE as DEPUTY10_67_0_, xfacesubac0_.DEPUTY_IC_NO as DEPUTY11_67_0_, xfacesubac0_.DEPUTY_IC_TYPE as DEPUTY12_67_0_, xfacesubac0_.DEPUTY_NAME as DEPUTY13_67_0_, xfacesubac0_.MAIN_IC_CHECK_RETURN_CODE as MAIN14_67_0_, xfacesubac0_.MAIN_IC_NAME as MAIN15_67_0_, xfacesubac0_.MAIN_IC_NO as MAIN16_67_0_, xfacesubac0_.MAIN_IC_TYPE as MAIN17_67_0_, xfacesubac0_.CARD_NO as CARD18_67_0_, xfacesubac0_.CARD_PASSBOOK_NO as CARD19_67_0_, xfacesubac0_.BANK_INFORMATION_NO as BANK20_67_0_, xfacesubac0_.FLG_RESTRICT_UNIV_CASHDEP as FLG21_67_0_, xfacesubac0_.FLG_RESTRICT_UNIV_CASHWTHDRW as FLG22_67_0_, xfacesubac0_.FLG_RESTRICT_UNIV_FT_DEBIT as FLG23_67_0_, xfacesubac0_.FLG_RESTRICT_UNIV_FT_CREDIT as FLG24_67_0_, xfacesubac0_.ACCT_NATURE as ACCT25_67_0_, xfacesubac0_.BASIC_ACCOUNT_OPEN_BANK_NAME as BASIC26_67_0_, xfacesubac0_.BASIC_ACCOUNT_NO as BASIC27_67_0_, xfacesubac0_.CAPITAL_PROPERTY as CAPITAL28_67_0_, xfacesubac0_.FLG_AUTO_RENEWAL as FLG29_67_0_, xfacesubac0_.RENEW_TYPE as RENEW30_67_0_, xfacesubac0_.INTEREST_TRANSFER_IN_ACCOUNT as INTEREST31_67_0_, xfacesubac0_.ON_MATURITY_TYPE as ON32_67_0_, xfacesubac0_.TERM_IN_DAYS as TERM33_67_0_, xfacesubac0_.TERM_IN_MONTHS as TERM34_67_0_, xfacesubac0_.MATURITY_DATE as MATURITY35_67_0_, xfacesubac0_.BANK_DEPOSIT_MONTH as BANK36_67_0_, xfacesubac0_.TD_REGULAR_PRD_INT_VAR as TD37_67_0_, xfacesubac0_.PREMAT_REDEM_INT_VAR as PREMAT38_67_0_, xfacesubac0_.INTEREST_CAP_FREQUENCY as INTEREST39_67_0_, xfacesubac0_.INT_PAY_TO_BANK_INTERNAL_ACCT as INT40_67_0_, xfacesubac0_.INTEREST_PAYOUT_ACCOUNT_NO as INTEREST41_67_0_, xfacesubac0_.INTEREST_PAYOUT_ACCOUNT_NAME as INTEREST42_67_0_, xfacesubac0_.PARTIAL_REDEMPTION_ALLOW_TIMES as PARTIAL43_67_0_, xfacesubac0_.FLG_CASH_WITHDRAWAL as FLG44_67_0_, xfacesubac0_.ACCOUNT_OPENING_FILE_NO as ACCOUNT45_67_0_, xfacesubac0_.ACCT_OPENING_FILE_EXPIRE_DATE as ACCT46_67_0_, xfacesubac0_.ACCT_OPENING_FILE_APPROVE_DATE as ACCT47_67_0_, xfacesubac0_.FLG_DORMANCY_ALLOWED as FLG48_67_0_, xfacesubac0_.INTEREST_RATE as INTEREST49_67_0_, xfacesubac0_.INTEREST_EFFECTIVE_DATE as INTEREST50_67_0_, xfacesubac0_.CAPITAL_VERIFICATION_RESULT as CAPITAL51_67_0_, xfacesubac0_.INTEREST_TRANSFER_ACCOUNT as INTEREST52_67_0_, xfacesubac0_.FLG_AGREEMENT_DEPOSIT as FLG53_67_0_, xfacesubac0_.FLG_RESTRICT_ACCT_CLOSURE as FLG54_67_0_, xfacesubac0_.ACCT_MGMT_FEE_COLLECT_ACCOUNT as ACCT55_67_0_, xfacesubac0_.TD_INTEREST_VARIANCE as TD56_67_0_, xfacesubac0_.TD_INT_VAR_EFFECTIVE_DATE as TD57_67_0_, xfacesubac0_.PMI_INTEREST_VARIANCE as PMI58_67_0_, xfacesubac0_.FLAG_ONLINE_UPLOAD as FLAG59_67_0_ from XFACE_SUB_ACCT_ADDNL_DTLS xfacesubac0_ where xfacesubac0_.COD_MC_ACCT_NO=:1 and xfacesubac0_.COD_ACCT_NO=:2 and xfacesubac0_.COD_DEP_NO=:3 |
| 8wjk4954bdx53 | UPDATE TMP_XFACE_AT_INV_USAGE_LOG A SET EXT_TASK_CODE = NVL((SELECT B.COD_EXT_TASK_REV FROM XFACE_ADDL_DETAILS_TXNLOG B WHERE B.REF_TXN_NO = A.REF_TXN_NO AND ROWNUM = 1), EXT_TASK_CODE) WHERE SESSION_ID = :B1 |
| 8xq7nycwspxkg | SELECT COD_ACCT_STAT, DAT_MATURITY, DAT_MATURITY_EXEC FROM CH_ACCT_MAST WHERE COD_ACCT_NO = :B1 AND FLG_MNT_STATUS = 'A' |
| 8yd9kkr5brwbf | SELECT * FROM TD_DEP_MAST WHERE COD_ACCT_NO = :B2 AND COD_DEP_NO = :B1 AND FLG_MNT_STATUS = 'A' |
| 938c75bsr27z7 | SELECT AB.*, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.cod_fcr_hold_no ELSE NULL END FCR_UNHOLD_NO , CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Notice_No ELSE NULL END UNHOLD_COD_NOTICE_NO, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.DAT_POSTING ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN AB.DAT_HOLD_STATUS ELSE NULL END END DAT_UNHOLD_ACTION, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN to_char(auditlogs2.Dat_ACTION, 'HH24:MI:SS') ELSE NULL END UNHOLD_TIME, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Reason ELSE NULL END UNHOLD_HOLD_AUTH, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Last_Mnt_Makerid ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN 'SYSTEM' ELSE NULL END END UNHOLD_MAKER, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Last_Mnt_Chkrid ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN 'SYSTEM' ELSE NULL END END UNHOLD_CHECKER, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Txt_Narrative ELSE NULL END UNHOLD_NARR, CASE WHEN(auditlogs2.cod_action =1 AND cod_hold_status = 3) THEN auditlogs2.COD_PREV_NOTICE_NO ELSE NULL END prev_notice_no FROM (Select * from temp_holdunhold_inq1 tmp WHERE 1 = 1 AND (cod_hold_status = (case when cod_hold_typ = 3 then cod_hold_status else 0 end) or cod_hold_status = (case when cod_hold_typ = 3 then cod_hold_status else 1 end)) AND COD_HOLD_TYP = 3 AND COD_CC_BRN_TXN = 5 ) AB LEFT JOIN ba_hold_audit_log auditlogs2 ON (AB.cod_fcr_hold_no = auditlogs2.Cod_Fcr_Hold_No AND AB.COD_NOTICE_NO = auditlogs2.cod_notice_no AND AB.cod_mc_acct_no = auditlogs2.cod_mc_acct_no) |
| 93ncwaa6wnvca | SELECT SUM(AMT_PAID) FROM CH_RD_INSTAL_DET WHERE COD_ACCT_NO = (:B1 ).COD_ACCT_NO() |
| 95mczs7c1pyr5 | SELECT COUNT(*) FROM CH_INT_RATE_CHANGE, (SELECT DAT_LAST_PROCESS, DAT_PROCESS FROM BA_BANK_MAST WHERE FLG_MNT_STATUS='A')B WHERE DAT_EFF_INT_RATE <= B.DAT_PROCESS AND COD_INT_INDX IN (SELECT COD_INT_INDX FROM CH_INT_RATE_TIER_PLAN WHERE COD_PLAN = :B1 AND FLG_MNT_STATUS = 'A') |
| 97623k4kyprqa | SELECT NVL(SUM(AMT_CR_INT_ACCR), 0) + NVL(SUM(AMT_DR_INT_ACCR), 0) FROM CH_ACCT_MAST WHERE COD_ACCT_NO IN (SELECT COD_ACCT_NO_SWPIN FROM CH_SWEEPIN CS WHERE CS.COD_ACCT_NO = :B2 AND CS.DAT_SWPIN_END >= :B1 AND CS.FLG_MNT_STATUS = 'A') AND FLG_MNT_STATUS = 'A' |
| 98rwky92jnvab | SELECT COD_PROD, DAT_MATURITY FROM CH_ACCT_MAST WHERE COD_ACCT_NO = :B1 |
| 9caaf4hn9bawg | UPDATE CH_ACCT_MAST SET AMT_HLD = AMT_HLD - :B2 , CTR_UPDAT_SRLNO = CTR_UPDAT_SRLNO + 1 WHERE COD_ACCT_NO = :B1 AND FLG_MNT_STATUS = 'A' |
| 9h7j0f296v1cz | SELECT AB.*, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.cod_fcr_hold_no ELSE NULL END FCR_UNHOLD_NO , CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Notice_No ELSE NULL END UNHOLD_COD_NOTICE_NO, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.DAT_POSTING ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN AB.DAT_HOLD_STATUS ELSE NULL END END DAT_UNHOLD_ACTION, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN to_char(auditlogs2.Dat_ACTION, 'HH24:MI:SS') ELSE NULL END UNHOLD_TIME, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Reason ELSE NULL END UNHOLD_HOLD_AUTH, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Last_Mnt_Makerid ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN 'SYSTEM' ELSE NULL END END UNHOLD_MAKER, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Last_Mnt_Chkrid ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN 'SYSTEM' ELSE NULL END END UNHOLD_CHECKER, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Txt_Narrative ELSE NULL END UNHOLD_NARR, CASE WHEN(auditlogs2.cod_action =1 AND cod_hold_status = 3) THEN auditlogs2.COD_PREV_NOTICE_NO ELSE NULL END prev_notice_no FROM (Select * from temp_holdunhold_inq1 tmp WHERE 1 = 1 AND (cod_hold_status = (case when cod_hold_typ = 3 then cod_hold_status else 0 end) or cod_hold_status = (case when cod_hold_typ = 3 then cod_hold_status else 1 end)) AND COD_HOLD_TYP = 3 AND COD_CC_BRN_TXN = 156 ) AB LEFT JOIN ba_hold_audit_log auditlogs2 ON (AB.cod_fcr_hold_no = auditlogs2.Cod_Fcr_Hold_No AND AB.COD_NOTICE_NO = auditlogs2.cod_notice_no AND AB.cod_mc_acct_no = auditlogs2.cod_mc_acct_no) |
| 9mnz54sbf1v76 | SELECT NVL(BAL_AVAILABLE + AMT_UNCLR + AMT_SWEEPIN_LIEN, 0) FROM CH_ACCT_MAST WHERE COD_ACCT_NO = :B1 AND FLG_MNT_STATUS = 'A' |
| 9mv7hjm8vq0qq | SELECT (CASE COD_ACCT_STAT WHEN 20 THEN 8 ELSE COD_ACCT_STAT END), DAT_MATURITY, DAT_LAST_INT_CAP, BAL_AVAILABLE, BAL_BOOK, BAL_BOOK, AMT_OD_LIMIT, AMT_HLD, DAT_LAST_DR, DAT_LAST_CR, AMT_HLD, AMT_CR_INT_ACCR, AMT_DR_INT_ACCR, DAT_MATURITY, DAT_ACCT_OPEN FROM CH_ACCT_MAST WHERE COD_ACCT_NO = :B1 AND FLG_MNT_STATUS = 'A' |
| 9prycrbhgvfd8 | SELECT COD_CC_BRN FROM CH_ACCT_MAST WHERE COD_ACCT_NO = :B1 AND FLG_MNT_STATUS = 'A' |
| 9rfvhaznqv76y | SELECT CURR.COD_TDS, CURR.COD_TDS_2, ( ( CURR.BAL_INT_ACCR + CURR.BAL_INT_COMP + CURR.BAL_INT_PAID + CURR.BAL_INT_PMI + CURR.BAL_INT_PENALTY ) - ( CURR.BAL_INT_ACCR_WV + CURR.BAL_INT_COMP_WV + CURR.BAL_INT_PAID_WV + CURR.BAL_INT_PMI_WV + CURR.BAL_INT_PENALTY_WV ) ) - ( ( PREV.BAL_INT_ACCR + PREV.BAL_INT_COMP + PREV.BAL_INT_PAID + PREV.BAL_INT_PMI + PREV.BAL_INT_PENALTY ) - ( PREV.BAL_INT_ACCR_WV + PREV.BAL_INT_COMP_WV + PREV.BAL_INT_PAID_WV + PREV.BAL_INT_PMI_WV + PREV.BAL_INT_PENALTY_WV ) ) AMT_DEP_NEGATIVE_INC, CURR.TAX_RATE_AT FROM TS_INCOME_TAX_LOG CURR, TS_TMP_INCOME_TAX_LOG PREV WHERE CURR.FIN_YEAR = PREV.FIN_YEAR AND CURR.COD_CUST = PREV.COD_CUST AND CURR.COD_CC_BRN = PREV.COD_CC_BRN AND CURR.COD_ACCT_NO = PREV.COD_ACCT_NO AND CURR.COD_DEP_NO = PREV.COD_DEP_NO AND PREV.TXN_REF_NO = :B6 AND CURR.FIN_YEAR = :B5 AND CURR.COD_CUST = :B4 AND CURR.COD_CC_BRN = :B3 AND CURR.COD_ACCT_NO = :B2 AND CURR.COD_DEP_NO = :B1 |
| 9vfnkgbbrxp56 |
select termdeposi0_.COD_ACCT_NO as COD1_264_4_, termdeposi0_.FLG_MNT_STATUS as FLG2_264_4_, termdeposi0_.dat_last_mnt as dat3_264_4_, termdeposi0_.cod_last_mnt_chkrid as cod4_264_4_, termdeposi0_.cod_last_mnt_makerid as cod5_264_4_, termdeposi0_.cod_mnt_action as cod6_264_4_, termdeposi0_.FLG_LIEN_TAKEN as FLG7_264_4_, termdeposi0_.FLG_REST_ACCT as FLG8_264_4_, termdeposi0_.FLG_EMP_ACCT as FLG9_264_4_, termdeposi0_.dat_acct_open as dat10_264_4_, termdeposi0_.AMT_CLOSING_BAL as AMT11_264_4_, termdeposi0_.COD_IBAN_NO as COD12_264_4_, termdeposi0_.DAT_LAST_CONTACT as DAT13_264_4_, termdeposi0_.DAT_LAST_STMNT_GEN as DAT14_264_4_, termdeposi0_.COD_CUST_MINOR_STAT as COD15_264_4_, termdeposi0_.FLG_BLOCKED as FLG16_264_4_, termdeposi0_.COD_REASON as COD17_264_4_, termdeposi0_.COD_LANG as COD18_264_4_, termdeposi0_.ctr_updat_srlno as ctr19_264_4_, termdeposi0_.COD_CUST as COD20_264_4_, termdeposi0_.fk_cust_status as fk21_264_4_, termdeposi0_.cod_ccy as cod22_264_4_, termdeposi0_.fk_ccy_status as fk23_264_4_, termdeposi0_.COD_OFFICR_ID as COD24_264_4_, termdeposi0_.fk_officr_status as fk25_264_4_, termdeposi0_.cod_cc_brn as cod26_264_4_, termdeposi0_.fk_brn_status as fk27_264_4_, termdeposi0_.cod_prod as cod28_264_4_, termdeposi0_.nam_cust_nominee as nam29_264_4_, termdeposi0_.nominee_id as nominee30_264_4_, termdeposi0_.flg_psbook as flg31_264_4_, termdeposi0_.flg_sc_waiver as flg32_264_4_, termdeposi0_.FLG_MEMO as FLG33_264_4_, termdeposi0_.amt_exempt_lmt_2 as amt34_264_4_, termdeposi0_.cod_tds_2 as cod35_264_4_, termdeposi0_.amt_exempt_lmt as amt36_264_4_, termdeposi0_.cod_tds as cod37_264_4_, termdeposi0_.cod_acct_title as cod38_264_4_, termdeposi0_.amt_running_bal as amt39_264_4_, termdeposi0_.COD_ACCT_STAT as COD40_264_4_, termdeposi0_.COD_CUST_TAXABLE as COD41_264_4_, customer1_.COD_CUST_ID as COD1_190_0_, customer1_.FLG_MNT_STATUS as FLG2_190_0_, customer1_.NAM_CUST_SHRT as NAM3_190_0_, customer1_.COD_OFFICR_ID as COD4_190_0_, customer1_.COD_CUST_NATL_ID as COD5_190_0_, customer1_.COD_NATL_ID_OLD as COD6_190_0_, customer1_.CIF_TYPE as CIF7_190_0_, customer1_.FLG_REST_CUST as FLG8_190_0_, customer1_.dat_cif_type_change as dat9_190_0_, customer1_.COD_CUST_PHONETIC as COD10_190_0_, customer1_.COD_MID_PHONETIC as COD11_190_0_, customer1_.COD_FIRST_PHONETIC as COD12_190_0_, customer1_.FLG_MEMBER as FLG13_190_0_, customer1_.COD_MEMBER_NO as COD14_190_0_, customer1_.COD_CUST_LANG as COD15_190_0_, customer1_.FLG_IC_TYP as FLG16_190_0_, customer1_.FLG_CUST_TYP as FLG17_190_0_, customer1_.COD_TDS as COD18_190_0_, customer1_.COD_TDS_2 as COD19_190_0_, customer1_.TXT_CUST_NATNLTY as TXT20_190_0_, customer1_.COD_CC_HOMEBRN as COD21_190_0_, customer1_.DAT_CUST_OPEN as DAT22_190_0_, customer1_.cod_last_mnt_chkrid as cod23_190_0_, customer1_.cod_last_mnt_makerid as cod24_190_0_, customer1_.dat_last_mnt as dat25_190_0_, customer1_.ctr_updat_srlno as ctr26_190_0_, customer1_.cod_mnt_action as cod27_190_0_, customer1_.FLG_KIO as FLG28_190_0_, customer1_.REF_CUST_IT_NUM as REF29_190_0_, customer1_.FLG_KEY_CHG as FLG30_190_0_, customer1_.FLG_REPLICATE as FLG31_190_0_, customer1_.FLG_LOCK_FAC as FLG32_190_0_, customer1_.flg_blocked as flg33_190_0_, customer1_.cod_block_reason as cod34_190_0_, customer1_.COD_EMPLOYEE_ID as COD35_190_0_, customer1_.NAM_IC_Issuer as NAM36_190_0_, customer1_.DAT_IC_Issue as DAT37_190_0_, customer1_.DAT_IC_Expiry as DAT38_190_0_, customer1_.FLG_Dom_Overseas as FLG39_190_0_, customer1_.TXT_Cust_region as TXT40_190_0_, customer1_.FLG_Composite_Stat as FLG41_190_0_, customer1_.FLG_Statement_Freq as FLG42_190_0_, customer1_.FLG_All_One as FLG43_190_0_, customer1_.COD_Cust_Class as COD44_190_0_, customer1_.dat_next_stmt as dat45_190_0_, customer1_.dat_last_stmt as dat46_190_0_, customer1_.External_Customer_IC as External47_190_0_, customer1_.External_Customer_IC_TYPE as External48_190_0_, customer1_.COD_CUSTADR_TYPE as COD49_190_0_, cust
omer1_.COD_CUST_REGION as COD50_190_0_, customer1_.TXT_STMT_REGION as TXT51_190_0_, customer1_.COD_ACCT_NO_DEFAULT as COD52_190_0_, customer1_.FLG_CUST_STATUS as FLG53_190_0_, customer1_.COD_TYP_ACCOM as COD54_190_0_, customer1_.COD_BANK_CARD as COD55_190_0_, customer1_.REF_CUST_EMAIL as REF56_190_0_, customer1_.REF_CUST_TELEX as REF57_190_0_, customer1_.REF_PHONE_MOBILE as REF58_190_0_, customer1_.COD_CUSTMOB_INTERNATION_CODE as COD59_190_0_, customer1_.TXT_MOB_EMAIL_ADD as TXT60_190_0_, customer1_.FLG_CUST_MEMO as FLG61_190_0_, customer1_.NAM_CUST_FULL as NAM62_190_0_, customer1_.dat_birth_cust as dat63_190_0_, customer1_.FLG_LOC_GLOB as FLG64_190_0_, customer1_.FLG_STAFF as FLG65_190_0_, customer1_.FLG_SPL_CUST as FLG66_190_0_, customer1_.REF_CUST_FAX as REF67_190_0_, customer1_.FLG_IC_VALIDITY as FLG68_190_0_, customer1_.cod_cust_marstat as cod69_190_0_, customer1_.txt_cust_sex as txt70_190_0_, customer1_.FLG_MINOR as FLG71_190_0_, customer1_.COD_GUARDIAN_TYPE as COD72_190_0_, customer1_.cod_cust_status as cod73_190_0_, customer1_.TXT_CUST_EDUCN as TXT74_190_0_, customer1_.COD_CUST_BLDGRP as COD75_190_0_, customer1_.cod_cust_introducer_id as cod76_190_0_, customer1_.NAM_CUST_MID as NAM77_190_0_, customer1_.NAM_CUST_LAST as NAM78_190_0_, customer1_.NAM_CUST_FIRST as NAM79_190_0_, customer1_.TXT_CUST_PREFIX as TXT80_190_0_, customer1_.NAM_CUST_EMP as NAM81_190_0_, customer1_.CTR_CUST_SPOUSES as CTR82_190_0_, customer1_.CTR_DPNDT_CHLDRN as CTR83_190_0_, customer1_.CTR_DPNDT_OTHRS as CTR84_190_0_, customer1_.NAM_CUST_SPOUSE as NAM85_190_0_, customer1_.TXT_SPOUSE_OCCPN as TXT86_190_0_, customer1_.TXT_PROFESS_CAT as TXT87_190_0_, customer1_.COD_SIGN_TYP as COD88_190_0_, customer1_.TXT_ETHNIC_ORIGIN as TXT89_190_0_, customer1_.TXT_LGL_RSDNC_STAT as TXT90_190_0_, customer1_.COD_INCOME_CAT as COD91_190_0_, customer1_.TXT_CUST_RESIDENCE as TXT92_190_0_, customer1_.TXT_CUST_DESGN as TXT93_190_0_, customer1_.nam_mother_maiden as nam94_190_0_, customer1_.CREDIT_RATING as CREDIT95_190_0_, customer1_.TXT_IC_ISSUE_REGION as TXT96_190_0_, customer1_.NAM_CNTRY_INCORP as NAM97_190_0_, customer1_.DAT_INCORPORATED as DAT98_190_0_, customer1_.COD_BUSINESS_REGNO as COD99_190_0_, customer1_.COD_BUSINESS_CAT as COD100_190_0_, customer1_.TXT_BUSINESS_TYP as TXT101_190_0_, customer1_.COD_LIAB_NO as COD102_190_0_, customer1_.DAT_REVISION as DAT103_190_0_, customer1_.AMT_LIMIT_TOT as AMT104_190_0_, customer1_.COD_CCY_LIMIT as COD105_190_0_, customer1_.FX_CUST_CLEAN_RISK_LIMIT as FX106_190_0_, customer1_.SEC_CLEAN_RISK_LIMIT as SEC107_190_0_, customer1_.SEC_CUST_CLEAN_RISK_LIMIT as SEC108_190_0_, customer1_.SEC_PSTL_RISK_LIMIT as SEC109_190_0_, customer1_.SEC_CUST_PSTL_RISK_LIMIT as SEC110_190_0_, customer1_.LAST_RENEW_DATE as LAST111_190_0_, customer1_.FLG_UNADV as FLG112_190_0_, customer1_.FLG_DOC_COMPLETE as FLG113_190_0_, decode(customer1_.flg_typ_class, 'B', 'C', customer1_.flg_typ_class) as clazz_0_, currency2_.cod_ccy as cod1_100_1_, currency2_.FLG_MNT_STATUS as FLG2_100_1_, currency2_.NAM_CCY_SHORT as NAM3_100_1_, currency2_.NAM_CURRENCY as NAM4_100_1_, currency2_.TXT_DEC_CCY_SYM as TXT5_100_1_, currency2_.NAM_DEC_CCY as NAM6_100_1_, currency2_.MLT_UNIT_RAT_QUOT as MLT7_100_1_, currency2_.FLG_APPROVED_CCY as FLG8_100_1_, currency2_.COD_CCY_ISO as COD9_100_1_, currency2_.RAT_CCY_VARIANCE as RAT10_100_1_, currency2_.TXT_CCY_SYM as TXT11_100_1_, currency2_.NAM_CCY_COUNTRY as NAM12_100_1_, currency2_.CTR_CCY_DEC as CTR13_100_1_, currency2_.NAM_DEC_CCY_SHORT as NAM14_100_1_, currency2_.FLG_CCY_CONV as FLG15_100_1_, currency2_.CTR_CCY_ROUND_TO as CTR16_100_1_, currency2_.CTR_DENM as CTR17_100_1_, currency2_.CTR_CCY_FLOAT as CTR18_100_1_, currency2_.COD_CCY_SWIFT as COD19_100_1_, currency2_.AMT_EURO_CHQ_GRNTY as AMT20_100_1_, currency2_.cod_last_mnt_chkrid as cod21_100_1_, currency2_.cod_last_mnt_makerid as cod22_100_1_, currency2_.dat_last_mnt as dat23_100_1_, cur
rency2_.ctr_updat_srlno as ctr24_100_1_, currency2_.cod_mnt_action as cod25_100_1_, user3_.COD_USER_ID as COD1_124_2_, user3_.FLG_MNT_STATUS as FLG2_124_2_, user3_.COD_HOST_TEMPL as COD3_124_2_, user3_.COD_BRANCH_TEMPL as COD4_124_2_, user3_.FLG_STATUS as FLG5_124_2_, user3_.DAT_LAST_SIGN_ON as DAT6_124_2_, user3_.FLG_LOGIN_STATE as FLG7_124_2_, user3_.NAM_USER as NAM8_124_2_, user3_.DAT_PROF_ST as DAT9_124_2_, user3_.DAT_PROF_END as DAT10_124_2_, user3_.DAT_VAC_ST as DAT11_124_2_, user3_.DAT_VAC_END as DAT12_124_2_, user3_.DAT_NEXT_PRI_PSWD_CH as DAT13_124_2_, user3_.DAT_NEXT_SEC_PSWD_CH as DAT14_124_2_, user3_.COD_LANG as COD15_124_2_, user3_.COD_CC_BRN as COD16_124_2_, user3_.cod_last_mnt_chkrid as cod17_124_2_, user3_.cod_last_mnt_makerid as cod18_124_2_, user3_.dat_last_mnt as dat19_124_2_, user3_.COD_USERNO as COD20_124_2_, user3_.ctr_updat_srlno as ctr21_124_2_, user3_.CTR_NO_FAILED_DAY as CTR22_124_2_, user3_.CTR_NO_FAILED_SEQ as CTR23_124_2_, user3_.FLG_LOGIN_USR_MODE as FLG24_124_2_, user3_.cod_mnt_action as cod25_124_2_, user3_.COD_PR_PSWD as COD26_124_2_, user3_.COD_SC_PSWD as COD27_124_2_, user3_.FLG_PSWD_RESET as FLG28_124_2_, user3_.COD_TERM_ID as COD29_124_2_, user3_.COD_EMPLOYEE_ID as COD30_124_2_, user3_.COD_ORGANIZATION as COD31_124_2_, user3_.COD_DIVISION as COD32_124_2_, user3_.COD_DEPARTMENT as COD33_124_2_, user3_.TXT_EMAIL_ID as TXT34_124_2_, user3_.COD_USER_ID_EXT as COD35_124_2_, user3_.FLG_DUAL_PSWD as FLG36_124_2_, user3_.COD_PREV_PSWD_COUNT as COD37_124_2_, user3_.COD_PSWD_CHG as COD38_124_2_, user3_.COD_ACCESS_DOMAIN as COD39_124_2_, branch4_.COD_CC_BRN as COD1_99_3_, branch4_.FLG_MNT_STATUS as FLG2_99_3_, branch4_.NAM_BRANCH as NAM3_99_3_, branch4_.NAM_BRANCH_SHRT as NAM4_99_3_, branch4_.FLG_DEPT_BUDGET as FLG5_99_3_, branch4_.COD_BRN_TYPE as COD6_99_3_, branch4_.COD_CC_LEVEL as COD7_99_3_, branch4_.COD_HL_COST_CENTRE as COD8_99_3_, branch4_.COD_CC_IB_LEVEL as COD9_99_3_, branch4_.COD_HL_IB_COST_CC as COD10_99_3_, branch4_.COD_COMP_CENTRE as COD11_99_3_, branch4_.COD_MAIN_BRANCH as COD12_99_3_, branch4_.COD_CLG_SECTOR as COD13_99_3_, branch4_.CTR_LAST_BATCH as CTR14_99_3_, branch4_.FLG_FINWARE as FLG15_99_3_, branch4_.FLG_TAX_COLLECT_BRN as FLG16_99_3_, branch4_.COD_CC_BRN_REMIT_TAX as COD17_99_3_, branch4_.COD_LCY as COD18_99_3_, branch4_.TXT_CC_ADD2 as TXT19_99_3_, branch4_.TXT_CC_ADD1 as TXT20_99_3_, branch4_.TXT_CC_ADD3 as TXT21_99_3_, branch4_.NAM_CC_CITY as NAM22_99_3_, branch4_.TXT_CC_ZIP as TXT23_99_3_, branch4_.NAM_CC_STATE as NAM24_99_3_, branch4_.NAM_CC_COUNTRY as NAM25_99_3_, branch4_.dat_last_mnt as dat26_99_3_, branch4_.cod_last_mnt_chkrid as cod27_99_3_, branch4_.cod_last_mnt_makerid as cod28_99_3_, branch4_.ctr_updat_srlno as ctr29_99_3_, branch4_.cod_mnt_action as cod30_99_3_, branch4_.COD_CC_BRN_XREF as COD31_99_3_, branch4_.cod_fin_inst_id as cod32_99_3_ from vwe_td_acct_mast termdeposi0_ left outer join vwe_ci_custmast customer1_ on termdeposi0_.COD_CUST=customer1_.COD_CUST_ID and termdeposi0_.fk_cust_status=customer1_.FLG_MNT_STATUS left outer join vwe_ba_ccy_code currency2_ on termdeposi0_.cod_ccy=currency2_.cod_ccy and termdeposi0_.fk_ccy_status=currency2_.FLG_MNT_STATUS left outer join sm_user_profile user3_ on termdeposi0_.COD_OFFICR_ID=user3_.COD_USER_ID and termdeposi0_.fk_officr_status=user3_.FLG_MNT_STATUS left outer join BA_CC_BRN_MAST branch4_ on termdeposi0_.cod_cc_brn=branch4_.COD_CC_BRN and termdeposi0_.fk_brn_status=branch4_.FLG_MNT_STATUS where termdeposi0_.COD_ACCT_NO=:1 and termdeposi0_.FLG_MNT_STATUS=:2 |
| 9xma3r47dg6u2 | SELECT FLG_TOPUP_ALLOW FROM TD_PROD_MAST PROD, TD_DEP_MAST DEP WHERE PROD.COD_PROD = DEP.COD_PROD AND DEP.COD_ACCT_NO = :B2 AND DEP.COD_DEP_NO = :B1 AND PROD.FLG_MNT_STATUS = 'A' AND DEP.FLG_MNT_STATUS = 'A' |
| 9z03dzwy8wx6x | DELETE FROM TEMP_PS_PSBK_DTLS WHERE SESSION_ID = :B1 |
| a2tw0a9mkm9yt | select count(1) as count FROM vwe_rec_txn_log WHERE ref_txn_no =:1 |
| a4u074qg2k1w1 | SELECT NVL(MAX(SRNO), 0) FROM CH_ACCT_CUST_XREF_AUDIT |
| a80fmavkbphth | update vwe_ci_custmast set NAM_CUST_SHRT=:1 , COD_OFFICR_ID=:2 , COD_CUST_NATL_ID=:3 , COD_NATL_ID_OLD=:4 , CIF_TYPE=:5 , FLG_REST_CUST=:6 , dat_cif_type_change=:7 , COD_CUST_PHONETIC=:8 , COD_MID_PHONETIC=:9 , COD_FIRST_PHONETIC=:10 , FLG_MEMBER=:11 , COD_MEMBER_NO=:12 , COD_CUST_LANG=:13 , FLG_IC_TYP=:14 , FLG_CUST_TYP=:15 , COD_TDS=:16 , COD_TDS_2=:17 , TXT_CUST_NATNLTY=:18 , COD_CC_HOMEBRN=:19 , DAT_CUST_OPEN=:20 , cod_last_mnt_chkrid=:21 , cod_last_mnt_makerid=:22 , dat_last_mnt=:23 , ctr_updat_srlno=:24 , cod_mnt_action=:25 , FLG_KIO=:26 , REF_CUST_IT_NUM=:27 , FLG_KEY_CHG=:28 , FLG_REPLICATE=:29 , FLG_LOCK_FAC=:30 , flg_blocked=:31 , cod_block_reason=:32 , COD_EMPLOYEE_ID=:33 , NAM_IC_Issuer=:34 , DAT_IC_Issue=:35 , DAT_IC_Expiry=:36 , FLG_Dom_Overseas=:37 , TXT_Cust_region=:38 , FLG_Composite_Stat=:39 , FLG_Statement_Freq=:40 , FLG_All_One=:41 , COD_Cust_Class=:42 , dat_next_stmt=:43 , dat_last_stmt=:44 , External_Customer_IC=:45 , External_Customer_IC_TYPE=:46 , COD_CUSTADR_TYPE=:47 , COD_CUST_REGION=:48 , TXT_STMT_REGION=:49 , COD_ACCT_NO_DEFAULT=:50 , FLG_CUST_STATUS=:51 , COD_TYP_ACCOM=:52 , COD_BANK_CARD=:53 , REF_CUST_EMAIL=:54 , REF_CUST_TELEX=:55 , REF_PHONE_MOBILE=:56 , COD_CUSTMOB_INTERNATION_CODE=:57 , TXT_MOB_EMAIL_ADD=:58 , FLG_CUST_MEMO=:59 , NAM_CUST_FULL=:60 , dat_birth_cust=:61 , FLG_LOC_GLOB=:62 , FLG_STAFF=:63 , FLG_SPL_CUST=:64 , REF_CUST_FAX=:65 , FLG_IC_VALIDITY=:66 , cod_cust_marstat=:67 , txt_cust_sex=:68 , FLG_MINOR=:69 , COD_GUARDIAN_TYPE=:70 , cod_cust_status=:71 , TXT_CUST_EDUCN=:72 , COD_CUST_BLDGRP=:73 , cod_cust_introducer_id=:74 , NAM_CUST_MID=:75 , NAM_CUST_LAST=:76 , NAM_CUST_FIRST=:77 , TXT_CUST_PREFIX=:78 , NAM_CUST_EMP=:79 , CTR_CUST_SPOUSES=:80 , CTR_DPNDT_CHLDRN=:81 , CTR_DPNDT_OTHRS=:82 , NAM_CUST_SPOUSE=:83 , TXT_SPOUSE_OCCPN=:84 , TXT_PROFESS_CAT=:85 , COD_SIGN_TYP=:86 , TXT_ETHNIC_ORIGIN=:87 , TXT_LGL_RSDNC_STAT=:88 , COD_INCOME_CAT=:89 , TXT_CUST_RESIDENCE=:90 , TXT_CUST_DESGN=:91 , nam_mother_maiden=:92 , CREDIT_RATING=:93 , TXT_IC_ISSUE_REGION=:94 where COD_CUST_ID=:95 and FLG_MNT_STATUS=:96 |
| a9ngx5c79xyxb | INSERT INTO TEMP_PS_PSBK_DTLS (COD_RECORD_TYP, COD_MC_ACCT_NO, COD_ACCT_NO, COD_DEP_NO, MC_PKG_CODE, REF_TXN_NO, REF_SYS_TR_AUD_NO, REF_USR_NO, CTR_BATCH_NO, COD_CC_BRN_TXN, COD_USERNO, COD_AUTH_ID, DAT_TXN, DAT_VALUE, DAT_POST, REMARK, PURPOSE_CODE, AMT_TXN, COD_MC_ACCT_CCY, COD_TXN_CCY, COD_DRCR, COD_MSG_TYP, AMT_RUNNING_BAL, DEP_VALUE_DATE, DAT_MATURITY, AMT_INT, AMT_TAX, RAT_DEP_INT, CTR_DEP_TERM_DAYS, CTR_DEP_TERM_MONTHS, COD_PAGE_NO, COD_LINE_NO, ROW_NUM, COD_TXN_MNEMONIC, SESSION_ID, TXT_PURPOSE_DESC, REF_SUB_SEQ_NO, GAS_METER_POINT, COD_MODULE, COD_PASSBK_LITERAL, DAT_ACCT_OPEN) SELECT COD_RECORD_TYP, COD_MC_ACCT_NO, COD_ACCT_NO, COD_DEP_NO, MC_PKG_CODE, REF_TXN_NO, REF_SYS_TR_AUD_NO, REF_USR_NO, CTR_BATCH_NO, COD_CC_BRN_TXN, COD_USERNO, COD_AUTH_ID, DAT_TXN, DAT_VALUE, DAT_POST, REMARK, PURPOSE_CODE, AMT_TXN, COD_MC_ACCT_CCY, COD_TXN_CCY, COD_DRCR, COD_MSG_TYP, AMT_RUNNING_BAL, DEP_VALUE_DATE, DAT_MATURITY, AMT_INT, AMT_TAX, RAT_DEP_INT, CTR_DEP_TERM_DAYS, CTR_DEP_TERM_MONTHS, COD_PAGE_NO, COD_LINE_NO, ROWNUM, COD_TXN_MNEMONIC, SESSION_ID, TXT_PURPOSE_DESC, REF_SUB_SEQ_NO, GAS_METER_POINT, COD_MODULE, COD_PASSBK_LITERAL, DAT_ACCT_OPEN FROM (SELECT COD_RECORD_TYP, COD_MC_ACCT_NO, COD_ACCT_NO, COD_DEP_NO, MC_PKG_CODE, REF_TXN_NO, REF_SYS_TR_AUD_NO, REF_USR_NO, CTR_BATCH_NO, COD_CC_BRN_TXN, COD_USERNO, COD_AUTH_ID, DAT_TXN, DAT_VALUE, DAT_POST, REMARK, PURPOSE_CODE, AMT_TXN, COD_MC_ACCT_CCY, COD_TXN_CCY, COD_DRCR, COD_MSG_TYP, AMT_RUNNING_BAL, DEP_VALUE_DATE, DAT_MATURITY, AMT_INT, AMT_TAX, RAT_DEP_INT, CTR_DEP_TERM_DAYS, CTR_DEP_TERM_MONTHS, COD_PAGE_NO, COD_LINE_NO, ROW_NUM, COD_TXN_MNEMONIC, SESSION_ID, TXT_PURPOSE_DESC, REF_SUB_SEQ_NO, GAS_METER_POINT, COD_MODULE, COD_PASSBK_LITERAL, DAT_ACCT_OPEN FROM TEMP_PS_PSBK_DTLS_TEMP WHERE SESSION_ID = :B1 ORDER BY COD_RECORD_TYP DESC, (CASE WHEN AMT_TXN IS NULL THEN COD_MODULE END), (CASE WHEN AMT_TXN IS NULL THEN DAT_ACCT_OPEN END), DAT_TXN, COD_USERNO, COD_ACCT_NO, COD_DEP_NO, (CASE WHEN COD_MODULE IN ('CH', 'RD') THEN 0 ELSE CTR_BATCH_NO END), CASE WHEN COD_MSG_TYP = 1 THEN (CASE WHEN COD_MODULE IN ('CH', 'RD') THEN 0 ELSE REF_SYS_TR_AUD_NO END) END ASC, CASE WHEN COD_MSG_TYP = 2 THEN (CASE WHEN COD_MODULE IN ('CH', 'RD') THEN 0 ELSE REF_SYS_TR_AUD_NO END) END DESC, CASE WHEN COD_MSG_TYP = 1 THEN (CASE WHEN COD_MODULE IN ('CH', 'RD') THEN 0 ELSE REF_SUB_SEQ_NO END) END ASC, CASE WHEN COD_MSG_TYP = 2 THEN (CASE WHEN COD_MODULE IN ('CH', 'RD') THEN 0 ELSE REF_SUB_SEQ_NO END) END DESC, COD_MSG_TYP, (CASE WHEN (COD_MSG_TYP = 2 AND COD_DRCR = 'D') THEN 'C' WHEN (COD_MSG_TYP = 2 AND COD_DRCR = 'C') THEN 'D' ELSE COD_DRCR END), AMT_TXN) INNERQUERY |
| amfux2phhr1am |
SELECT NVL(SUM(DECODE(COD_DRCR, 'C', AMT_TXN, -AMT_TXN)), 0) FROM (SELECT COD_DRCR, AMT_INT_RECOVERED INT_RECOVERED, AMT_TAX, AMT_INT, (CASE WHEN COD_PASSBK_LITERAL = 'RENEW_REINVEST_PAYIN' AND NVL(RENEW_TYPE, ' ') IN ('PO', 'LI') THEN 0 WHEN COD_DEP_NO > 1 AND BAL_INT_PAID = 0 AND COD_PASSBK_LITERAL = 'RENEW_REINVEST_PAYIN' THEN ((SELECT TDMI.BAL_INT_PAID - AMT_TAX - AMT_INT_RECOVERED FROM TD_DEP_MAST TDMI WHERE TDMI.COD_DEP_NO = (INNERQUERY.COD_DEP_NO - 1) AND TDMI.FLG_MNT_STATUS = 'A' AND TDMI.COD_ACCT_NO = INNERQUERY.COD_ACCT_NO)) WHEN COD_DEP_NO > 1 AND COD_PASSBK_LITERAL = 'RENEW_REINVEST_PAYIN' THEN (SELECT TDMI.BAL_INT_PAID - AMT_TAX - AMT_INT_RECOVERED FROM TD_DEP_MAST TDMI WHERE TDMI.COD_DEP_NO = (INNERQUERY.COD_DEP_NO - 1) AND TDMI.FLG_MNT_STATUS = 'A' AND TDMI.COD_ACCT_NO = INNERQUERY.COD_ACCT_NO) WHEN COD_USERNO = 24046 THEN AMT_TXN ELSE AMT_TXN - (AMT_INT - AMT_TAX - AMT_INT_RECOVERED) END) AS AMT_TXN FROM (SELECT :B3 AS COD_ACCT_NO, TD.COD_DEP_NO AS COD_DEP_NO, COD_DRCR, TD.COD_USERNO AS COD_USERNO, AMT_TXN_ACY AS AMT_TXN, INT_AMT AS AMT_INT, TAX_AMT AS AMT_TAX, TD.COD_TXN_MNEMONIC AS COD_TXN_MNEMONIC, COD_PASSBK_LITERAL AS COD_PASSBK_LITERAL, TD.BAL_INT_PAID, TD.BAL_FOR_RATE_EARNED, TD.AMT_INT_RECOVERED, RENEW_TYPE FROM (SELECT TDN.COD_ACCT_NO, TDN.COD_DEP_NO, REF_TXN_NO, REF_SYS_TR_AUD_NO, REF_USR_NO, REF_SUB_SEQ_NO, CTR_BATCH_NO, COD_CC_BRN_TXN, COD_USERNO, DAT_TXN, DAT_POST, COD_DRCR, COD_MSG_TYP, COD_PSBK_LINE_NO, COD_PASSBK_LITERAL, (SUM(DECODE(TDN.COD_PASSBK_LITERAL, 'REN_PEND_INT', AMT_TXN_ACY, 'PRM_PENALTY_INT', AMT_TXN_ACY, 'INT_PAYABLE', AMT_TXN_ACY, 'POST_RED_PMI_CR', AMT_TXN_ACY, 'SWP_PRE_RED_INT', AMT_TXN_ACY, 'INT_COLLECT_CHQ', AMT_TXN_ACY, 'PRM_PEND_INT', AMT_TXN_ACY, 'POST_RED_PEND_INT', AMT_TXN_ACY, 0)) OVER(PARTITION BY REF_TXN_NO)) INT_AMT, (SUM(DECODE(TDN.COD_PASSBK_LITERAL, 'TAX_COMP_TOTAL', AMT_TXN_ACY, 'SWP_TOTAL_TAX', AMT_TXN_ACY, 'POST_RED_PMI_TOT_TAX', AMT_TXN_ACY, 'PRM_TOTAL_TAX', AMT_TXN_ACY, 'RTX_TOT_ADDL_TAX', AMT_TXN_ACY, 'INT_PAYABLE_TAX', AMT_TXN_ACY, 'TAX_RECOVERED', AMT_TXN_ACY, 0)) OVER(PARTITION BY REF_TXN_NO)) TAX_AMT, (SUM(DECODE(TDN.COD_PASSBK_LITERAL, 'PRM_INT_PAID_DEDUCT', AMT_TXN_ACY, 0)) OVER(PARTITION BY REF_TXN_NO)) AMT_INT_RECOVERED, COD_TXN_MNEMONIC, AMT_TXN_ACY, COD_BANK_LITERAL, TDM.BAL_FOR_RATE_EARNED AS BAL_FOR_RATE_EARNED, TDM.BAL_INT_PAID AS BAL_INT_PAID, NVL(RENEW_TYPE, ' ') AS RENEW_TYPE FROM TD_NOBOOK TDN, TD_DEP_MAST TDM, XFACE_SUB_ACCT_ADDNL_DTLS SUB WHERE TDN.COD_ACCT_NO = :B3 AND TDM.COD_ACCT_NO = :B3 AND TDM.FLG_MNT_STATUS = 'A' AND TDM.COD_DEP_NO = TDN.COD_DEP_NO AND TDN.COD_BANK_LITERAL <> 'SPL' AND TDN.COD_ORG_DEP_NO <> 0 AND TDN.COD_DEP_NO = SUB.COD_DEP_NO AND TDN.COD_ACCT_NO = SUB.COD_ACCT_NO AND SUB.COD_ACCT_NO = :B3 AND DAT_TXN < :B2 AND DAT_TXN >= :B1 ORDER BY TDN.COD_PSBK_LINE_NO) TD WHERE TD.COD_DRCR IN ('C', 'D') AND ((TD.COD_BANK_LITERAL = 'TDP' AND TD.COD_PASSBK_LITERAL = 'NET_TD_PAYIN') OR (TD.COD_PASSBK_LITERAL NOT IN ('INT_COMP', 'NET_TD_PAYIN', 'BAT_MAT_PAY_TD_ACCT', 'INT_PAID_BAT_XFER_SB', 'INT_COLLECT_CHQ', 'POST_RED_PEND_INT', 'SI_FROM_SAVINGS'))) AND TD.COD_TXN_MNEMONIC NOT IN (1358, 3113, 3203, 3103, 1398) AND COD_PASSBK_LITERAL IN (SELECT COD_PASSBK_LITERAL FROM TD_TXNLIT_MNEM_XREF WHERE CTR_TXN_LEG = 0 OR (CTR_TXN_LEG != 0 AND CTR_GRP_NO NOT IN (SELECT CTR_GRP_NO FROM TD_TXNLIT_MNEM_XREF WHERE CTR_TXN_LEG = 0))) ORDER BY TD.DAT_TXN, TD.COD_DEP_NO, TD.COD_USERNO, TD.CTR_BATCH_NO, TD.REF_SYS_TR_AUD_NO DESC, TD.REF_SUB_SEQ_NO, TD.COD_MSG_TYP, (CASE WHEN (TD.COD_MSG_TYP = 400 AND TD.COD_DRCR = 'D') THEN 'C' WHEN (TD.COD_MSG_TYP = 400 AND TD.COD_DRCR = 'C') THEN 'D' ELSE TD.COD_DRCR END), TD.AMT_TXN_ACY) INNERQUERY)
|
| arnkbsnzhha77 | SELECT * FROM CH_ACCT_MAST WHERE COD_ACCT_NO = :B1 AND FLG_MNT_STATUS = 'A' FOR UPDATE NOWAIT |
| audsj8zdfgxd5 | SELECT funds.COD_HOLD_NO, funds.AMT_HOLD, funds.DAT_HOLD_START, funds.DAT_HOLD_END, funds.COD_HOLD_STATUS, funds.AMT_HOLD, auditlogs.FLG_DEDUCT_FIRST_INST, auditlogs.TYP_DEDUCT_FIRST_INST, auditlogs.COD_MCACCT_FIRST_INST, auditlogs.NAM_BANK_PAYEE, funds.HOLD_TYPE, auditlogs.COD_MCA_TITLE, auditlogs.COD_BANK_PAYEE , auditlogs.AMT_HLD , auditlogs.COD_FCR_HOLD_NO FROM ba_hold_funds funds, ba_hold_audit_log auditlogs, mc_acct_mast mc WHERE funds.cod_notice_no = auditlogs.cod_notice_no AND funds.cod_mc_acct_no = auditlogs.cod_mc_acct_no AND funds.cod_mc_acct_no = mc.cod_mc_acct_no AND auditlogs.cod_mc_acct_no = mc.cod_mc_acct_no AND auditlogs.cod_action = decode (funds.cod_rule_extn, 9, 0, 0, 1, 1, 3, 0) AND funds.cod_hold_no >= auditlogs.cod_fcr_hold_no AND funds.COD_MC_ACCT_NO = NVL('203414286100019 ', funds.COD_MC_ACCT_NO) AND funds.HOLD_TYPE = 3 AND to_char(auditlogs.DAT_POSTING, 'YYYY-MM-DD') = '2012-06-14' AND auditlogs.COD_NOTICE_TYP = 0 AND trim(funds.COD_NOTICE_NO) = trim('2001西民执字第22号') AND auditlogs.COD_HOLD_TYP = 3 ORDER BY funds.COD_HOLD_NO, auditlogs.COD_FCR_HOLD_NO |
| av5zpv0z84pg7 | SELECT COD_PENALTY_INDX FROM CH_RD_PROD_RATES WHERE COD_PROD = :B2 AND TERM_UNIT = (:B1 ).TERM_UNIT() AND TERM_SLAB = (:B1 ).TERM_SLAB() |
| av6ff76h7r0uj | UPDATE MC_PSBK_MAST SET COD_PSBK_LINE_NO = :B6 , DAT_LST_PSBK_UPDATE = :B5 , COD_PSBK_STATUS = :B4 , FLG_PSBK_CHANGE = :B3 WHERE COD_STOCK = :B2 AND COD_PSBK_NO = :B1 AND COD_MC_ACCT_NO IN (SELECT COD_MC_ACCT_NO FROM TEMP_PS_PSBK_DTLS WHERE SESSION_ID = :B7 ) |
| b3cfsvnwqdnpt | SELECT COD_PROD, COD_ACCT_STAT, COD_CC_BRN, COD_CCY, FLG_PSBOOK, FLG_DISALLOW_BRN, BAL_LST_PSBK, FLG_MEMO, FLG_REST_ACCT, FLG_EMP_ACCT, CTR_UPDAT_SRLNO, CTR_NUM_WITHDRAW, CTR_FUNDS_CR_TODAY, COD_CUST, BAL_AVAILABLE FROM CH_ACCT_MAST WHERE COD_ACCT_NO = :B1 AND FLG_MNT_STATUS = 'A' FOR UPDATE NOWAIT |
| b3y0wwrf4fctz | SELECT (BAL_AVAILABLE + AMT_SWEEPIN_LIEN - AMT_HLD -:B2 ), AMT_OD_LIMIT, BAL_AVAILABLE, OD_PARENT_LIMIT_ID, COD_CC_BRN, COD_PROD, COD_CUST, COD_CCY FROM CH_ACCT_MAST WHERE COD_ACCT_NO = :B1 AND FLG_MNT_STATUS = 'A' |
| b4xxmbvc6rjqq | SELECT COD_CUST, COD_CC_BRN, COD_CCY, BAL_AVAILABLE, AMT_UNCLR, FLG_REPL_CUBE, COD_ACCT_STAT, DAT_EXP_UNCLR_ADVNC, DAT_ST_UNCL_ADVNC, AMT_UNCLR_ADVNC_LIM, AMT_SWEEPIN_LIEN, RAT_UNCLR_ADVNC_PCT, NVL(COD_LINE_NO, 'NOLINE'), (NVL(CREDIT_CONFIRMATION_BAL, 0) - NVL(DEBIT_CONFIRMATION_BAL, 0)) FROM CH_ACCT_MAST WHERE COD_ACCT_NO = :B1 AND FLG_MNT_STATUS = 'A' |
| b5bfnf93zqspq | UPDATE CH_ACCT_MAST SET COD_ACCT_STAT = :B3 , BAL_AVAILABLE = :B2 WHERE COD_ACCT_NO = :B1 |
| b7mrhhrzz023n | UPDATE EXT_BLKFNDXFER_HEADERRECDTO SET COMMENTS = 'Success', RECORDSTATUS = 5, REF_TXN_NO = :B2 WHERE FILEID = :B1 AND RECORDSTATUS = 1 |
| bbq3cvfqxya49 | SELECT * FROM BA_BANK_MAST WHERE FLG_MNT_STATUS = 'A' |
| bc5fhujsn06jc | SELECT QUOTATION FROM CYTM_CCY_PAIR_DEFN WHERE CCY1 = :B2 AND CCY2 = :B1 |
| bkqmbyzha1sh5 | SELECT :B2 + NVL(SUM(DECODE(COD_DRCR, 'D', AMT_TXN, -AMT_TXN)), 0.00) FROM CH_NOBOOK CH WHERE CH.COD_ACCT_NO = :B1 AND CH.FLG_PASBKUPD = 'N' |
| bm4vn81n70zs3 | DECLARE BEGIN :1 := AP_OL_CH_CASH_DEP(:2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , :99 , :100 , :101 , :102 , :103 , :104 , :105 , :106 , :107 , :108 , :109 , :110 , :111 , :112 , :113 , :114 , :115 , :116 , :117 , :118 , :119 , :120 , :121 , :122 , :123 , :124 , :125 , :126 , :127 , :128 , :129 , :130 , :131 , :132 , :133 , :134 , :135 , :136 , :137 , :138 , :139 , :140 , :141 , :142 , :143 , :144 , :145 , :146 , :147 , :148 , :149 , :150 , :151 , :152 , :153 , :154 , :155 , :156 , :157 , :158 , :159 , :160 , :161 , :162 , :163 , :164 , :165 , :166 , :167 , :168 , :169 , :170 , :171 , :172 , :173 , :174 , :175 , :176 , :177 , :178 , :179 , :180 , :181 , :182 , :183 , :184 , :185 , :186 , :187 , :188 , :189 , :190 , :191 , :192 , :193 , :194 , :195 , :196 , :197 , :198 , :199 , :200 , :201 , :202 , :203 , :204 , :205 , :206 , :207 , :208 , :209 , :210 , :211 , :212 , :213 , :214 , :215 , :216 , :217 , :218 , :219 , :220 , :221 , :222 , :223 , :224 , :225 , :226 , :227 , :228 , :229 , :230 , :231 , :232 , :233 , :234 , :235 , :236 , :237 , :238 , :239 ) ; END; |
| bpb5sc6jrjry9 | SELECT --+PARALLEL(4) B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, SUM(A.AMT_TXN_HOST), COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host FROM CH_ST_CAP_INPUT_TXN_MMDD A, CH_PROD_MAST B WHERE DAT_POST = TO_DATE('21-03-2013', 'DD-MM-YYYY') AND A.COD_PROD_HOST = B.COD_PROD AND A.COD_DRCR_DEST = 'C' AND COD_CCY_HOST = '156' AND B.COD_GL_INT_PAYABLE = '26003' AND a.cod_cc_brn_host = '848' GROUP BY B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host ORDER BY B.COD_GL_INT_PAYABLE, COD_CCY_HOST, COD_CC_BRN_HOST, A.COD_PROD_HOST |
| br2yrgywumbjd | DECLARE BEGIN :1 := PK_CH_DEBIT_ACCT.AP_CH_REMOVE_HOLD(:2 , :3 , :4 , :5 ) ; END; |
| br6wwg6p79cj2 | SELECT BAL_ACCT_MIN_INITIAL_PAYIN, COD_CCY FROM CH_ACCT_MAST WHERE COD_ACCT_NO = :B1 AND FLG_MNT_STATUS = 'A' |
| bu5dpun53pvkk | SELECT --+PARALLEL(4) B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, SUM(A.AMT_TXN_HOST), COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host FROM CH_ST_CAP_INPUT_TXN_MMDD A, CH_PROD_MAST B WHERE DAT_POST = TO_DATE('21-03-2013', 'DD-MM-YYYY') AND A.COD_PROD_HOST = B.COD_PROD AND A.COD_DRCR_DEST = 'C' AND COD_CCY_HOST = '156' AND B.COD_GL_INT_PAYABLE = '26003' AND a.cod_cc_brn_host = '845' GROUP BY B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host ORDER BY B.COD_GL_INT_PAYABLE, COD_CCY_HOST, COD_CC_BRN_HOST, A.COD_PROD_HOST |
| bxc3y73pk5ntu | INSERT INTO tmp_xface_td_tmp_rtd_interest (COD_ACCT_NO, COD_DEP_NO, DAT_EFF_FROM, DAT_EFF_TO, NO_OF_DAYS, EFFECTIVE_RATE, INTEREST_VAR, AMT_BASE, FLG_INT_TYPE, AMT_INTEREST, DAT_PROCESS, CTR_RULE_REF_NO, REF_TXN_NO) SELECT COD_ACCT_NO, COD_DEP_NO, DAT_EFF_FROM, DAT_EFF_TO, NO_OF_DAYS, EFFECTIVE_RATE, INTEREST_VAR, AMT_BASE, FLG_INT_TYPE, AMT_INTEREST, DAT_PROCESS, CTR_RULE_REF_NO, REF_TXN_NO FROM td_tmp_rtd_interest x WHERE cod_acct_no = :1 AND dat_process = to_date(:2 , 'YYYYMMDD') AND (x.flg_int_type like 'P%' or x.flg_int_type in ('M', 'N')) |
| c2852fs8utn09 | SELECT b.cod_mc_acct_no as "McAccountNo" , b.cod_mca_title "McTitle" FROM mc_acct_xref a , mc_acct_mast b WHERE COD_ACCT_NO = :1 AND a.cod_mc_acct_no = b.cod_mc_acct_no |
| c3848dp9xht19 | begin pk_cm_entity_context.set_entity_in_context(:1 ); end; |
| c3ap36zu0stkv | SELECT (CASE cod_acct_stat WHEN 1 THEN 0 WHEN 5 THEN 0 ELSE a.amt_cr_int_accr + a.amt_cr_int_accr_adj + (a.amt_cr_int_comp * (datediff(dd, a.dat_last_int_comp, (select dat_process from ba_bank_mast)))) END) as amtCrIntAccr, (CASE COD_ACCT_STAT WHEN 1 THEN 0 WHEN 5 THEN 0 ELSE (A.AMT_DR_INT_ACCR + A.AMT_DR_INT_ACCR_ADJ + (A.AMT_DR_INT_COMP * (DATEDIFF(DD, A.DAT_LAST_INT_COMP, (select dat_process from ba_bank_mast))))) * -1 END) as amtDrIntAccr FROM ch_acct_mast a WHERE a.flg_mnt_status = 'A' AND a.cod_acct_no = CAST( :1 as CHAR(16)) |
| c4y5gqjh4a2va | select customerli0_.COD_CUST_ID as COD1_86_0_, customerli0_.NAM_CUST_SHRT as NAM2_86_0_, customerli0_.REF_CUST_EMAIL as REF3_86_0_, customerli0_.REF_PHONE_MOBILE as REF4_86_0_, customerli0_.COD_CUST_LANG as COD5_86_0_, customerli0_.NAM_CUST_MID as NAM6_86_0_, customerli0_.NAM_CUST_LAST as NAM7_86_0_, customerli0_.NAM_CUST_FIRST as NAM8_86_0_, customerli0_.TXT_CUST_PREFIX as TXT9_86_0_ from ci_custmast customerli0_ where customerli0_.COD_CUST_ID=:1 and ( customerli0_.FLG_MNT_STATUS = 'A') |
| c5y810g6w6fzb | DECLARE BEGIN :1 := AP_OL_ACCT_OPEN(:2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 ) ; END; |
| c5ybs7uyuyt9k | SELECT DAT_MATURITY FROM CH_ACCT_MAST WHERE COD_ACCT_NO = :B1 AND FLG_MNT_STATUS = 'A' |
| c997gg0sacab8 | BEGIN :1 := FCR44HOST.PK_XFACE_AUDIT_TRAIL.AT_INV_USAGE_LOG(:2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 ); END; |
| c9z1wpcj9d327 | select * from fcr44host.actb_history where ac_branch in (select cod_cc_brn from fcr44host.ba_move_branch_mmdd) and trn_dt=date '2013-3-20' |
| ca275sx5a7kg1 | BEGIN :1 := FCR44HOST.PK_XFACE_AUDIT_TRAIL.AT_REAL_TIME_IB_FT_TXN_INQ(:2 , :3 , :4 , :5 , :6 , :7 ); END; |
| cfgm6cx9yytd5 | UPDATE CH_ACCT_MAST SET BAL_AVAILABLE = BAL_AVAILABLE - :B3 , CTR_UPDAT_SRLNO = CTR_UPDAT_SRLNO + 1 WHERE COD_ACCT_NO = :B2 AND FLG_MNT_STATUS = 'A' AND CTR_UPDAT_SRLNO = :B1 |
| ch4nr38a3x4z9 | SELECT DAT_LINKED FROM MC_PSBK_MAST WHERE COD_MC_ACCT_NO = :B3 AND COD_PSBK_NO = :B2 AND COD_STOCK = :B1 AND FLG_MNT_STATUS = 'A' |
| cn0rg4rp52npa | SELECT BAL_AVAILABLE, BAL_ACCT_MIN_REQD, AMT_HLD, AMT_SWEEPIN_LIEN, (NVL(CREDIT_CONFIRMATION_BAL, 0) - NVL(DEBIT_CONFIRMATION_BAL, 0)), AMT_OD_LIMIT FROM CH_ACCT_MAST WHERE COD_ACCT_NO = :B2 AND FLG_MNT_STATUS = 'A' AND CTR_UPDAT_SRLNO = :B1 |
| crq8x15f5s3fu | SELECT AB.*, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.cod_fcr_hold_no ELSE NULL END FCR_UNHOLD_NO , CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Notice_No ELSE NULL END UNHOLD_COD_NOTICE_NO, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.DAT_POSTING ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN AB.DAT_HOLD_STATUS ELSE NULL END END DAT_UNHOLD_ACTION, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN to_char(auditlogs2.Dat_ACTION, 'HH24:MI:SS') ELSE NULL END UNHOLD_TIME, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Reason ELSE NULL END UNHOLD_HOLD_AUTH, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Last_Mnt_Makerid ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN 'SYSTEM' ELSE NULL END END UNHOLD_MAKER, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Last_Mnt_Chkrid ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN 'SYSTEM' ELSE NULL END END UNHOLD_CHECKER, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Txt_Narrative ELSE NULL END UNHOLD_NARR, CASE WHEN(auditlogs2.cod_action =1 AND cod_hold_status = 3) THEN auditlogs2.COD_PREV_NOTICE_NO ELSE NULL END prev_notice_no FROM (Select * from temp_holdunhold_inq1 tmp WHERE 1 = 1 AND (cod_hold_status = (case when cod_hold_typ = 3 then cod_hold_status else 0 end) or cod_hold_status = (case when cod_hold_typ = 3 then cod_hold_status else 1 end)) AND COD_HOLD_TYP = 3 AND COD_CC_BRN_TXN = 214 ) AB LEFT JOIN ba_hold_audit_log auditlogs2 ON (AB.cod_fcr_hold_no = auditlogs2.Cod_Fcr_Hold_No AND AB.COD_NOTICE_NO = auditlogs2.cod_notice_no AND AB.cod_mc_acct_no = auditlogs2.cod_mc_acct_no) |
| cv0cwpxqx7uph | UPDATE BA_TEMP_CHANGE_FIELD_LOG SET NEW_FIELD_VALUE = :B6 WHERE NAME_TABLE = :B5 AND COD_FIELD_NAME = :B4 AND CTR_TABLE_NO = :B3 AND ROW_NO = :B2 AND CTR_CHANGE_NO = :B1 AND SESSION_ID = USERENV('SESSIONID') |
| cv84vtpqvnc6u | DECLARE BEGIN :1 := PK_BA_FUNDS_XFER_LMT_CHECK.VALIDATE_LIMIT(:2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 ) ; END; |
| cyqd3sdrn8wyb | SELECT NVL(M.BAL_AVAILABLE, 0), NVL(M.BAL_BOOK, 0), NVL(M.AMT_HLD, 0), COD_ACCT_NO FROM CH_ACCT_MAST M WHERE COD_ACCT_NO IN (SELECT A.COD_AGMT_SUB_ACCT_NO FROM XFACE_SUB_ACCT_ADDNL_DTLS A WHERE A.COD_MC_ACCT_NO = :B4 AND A.COD_ACCT_NO = :B3 AND A.COD_CCY = :B2 AND A.COD_DEP_NO = :B1 ) AND M.FLG_MNT_STATUS = 'A' AND M.COD_ACCT_STAT NOT IN (1, 5) |
| czgq66tca91mz | SELECT TO_DATE(TO_CHAR(MIN(DAT_TXN), 'YYYYMMDDHH24MISS'), 'YYYYMMDDHH24MISS') FROM CH_NOBOOK WHERE COD_ACCT_NO = :B1 AND FLG_PASBKUPD = 'N' |
| d3rnyn7umv5pq | SELECT * FROM XFACE_TEMP_ACCT_BAS_INFO A FOR UPDATE OF A.COD_PROD_NAM, A.COD_DEP_NO, A.COD_INT_RATE, A.COD_FLG_AUTO_RENEW, A.COD_CASH_REMIT_FLG, A.COD_ACCT_NATURE, A.COD_WITHDR_METHOD, A.COD_CASH_INTR_BRN_TXN_FLG, A.COD_FUND_INTR_BRN_TXN_FLG, A.COD_BAL_BOOK, A.COD_HOLD_AMT, A.COD_STOP_PAY_AMT, A.COD_BAL_AVAILABLE, A.COD_NET_BAL, A.COD_DAT_LAST_CAPITALIZATION, A.COD_DAT_MATURITY, A.COD_DEP_TERM, A.COD_INVENTORY_COD, A.COD_INVENTORY_NO, A.COD_INVENTORY_STATUS, A.COD_PAY_VERIFY_AMT, A.COD_PAYER_PAYEE_NAM_FLG, A.COD_FUND_ATTR, A.COD_BULK_ACCT_OPEN_FLG, A.COD_ACCT_CLOSURE_FLG, A.COD_ASSIGNED_ACCT, A.COD_ACCRUE_INT_AMT, A.COD_DUE_INT_AMT, A.COD_INT_PAYOUT_ACCT, A.COD_FIRST_CHK_PERSON, A.COD_FIRST_CHK_PERSON_TELNO, A.COD_SECOND_CHK_PERSON, A.COD_SECOND_CHK_PERSON_TELNO, A.COD_CAPITAL_VERIFY_RESULT, A.COD_AGREEMENT_DEPOSIT_FLG, A.COD_PARENT_ACCT_FLG, A.COD_REG_PERIOD_INT NOWAIT |
| dk5w2zsbdj9v6 | SELECT --+PARALLEL(4) B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, SUM(A.AMT_TXN_HOST), COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host FROM CH_ST_CAP_INPUT_TXN_MMDD A, CH_PROD_MAST B WHERE DAT_POST = TO_DATE('21-03-2013', 'DD-MM-YYYY') AND A.COD_PROD_HOST = B.COD_PROD AND A.COD_DRCR_DEST = 'C' AND COD_CCY_HOST = '156' AND B.COD_GL_INT_PAYABLE = '26003' AND a.cod_cc_brn_host = '853' GROUP BY B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host ORDER BY B.COD_GL_INT_PAYABLE, COD_CCY_HOST, COD_CC_BRN_HOST, A.COD_PROD_HOST |
| dsams610dbvv6 | SELECT RAT_INT_VAR FROM CH_INT_RATE_TIER_PLAN WHERE COD_PLAN = :B1 AND TRIM(COD_INT_TYPE) = 'CR' AND COD_TIER_NO = (SELECT MIN(COD_TIER_NO) FROM (SELECT COD_TIER_NO, DECODE(COD_TIER_NO, (MAX(COD_TIER_NO) OVER (PARTITION BY COD_INT_TYPE)), 9.99E18, BAL_INT_TIER) BAL_INT_TIER FROM CH_INT_RATE_TIER_PLAN WHERE COD_PLAN = :B1 AND TRIM(COD_INT_TYPE) = 'CR' AND FLG_MNT_STATUS = 'A') WHERE BAL_INT_TIER >= :B2 AND FLG_MNT_STATUS = 'A' AND DAT_EFFECTIVE = (SELECT MAX(DAT_EFFECTIVE) FROM (SELECT COD_TIER_NO, COD_INT_TYPE, DAT_EFFECTIVE, DECODE(COD_TIER_NO, (MAX(COD_TIER_NO) OVER (PARTITION BY COD_INT_TYPE)), 9.99E18, BAL_INT_TIER) BAL_INT_TIER FROM CH_INT_RATE_TIER_PLAN WHERE COD_PLAN = :B1 AND TRIM(COD_INT_TYPE) = 'CR' AND FLG_MNT_STATUS = 'A') WHERE BAL_INT_TIER >= :B2 )) AND DAT_EFFECTIVE = (SELECT MAX(DAT_EFFECTIVE) FROM (SELECT COD_TIER_NO, COD_INT_TYPE, DAT_EFFECTIVE , DECODE(COD_TIER_NO, (MAX(COD_TIER_NO) OVER (PARTITION BY COD_INT_TYPE)), 9.99E18, BAL_INT_TIER) BAL_INT_TIER FROM CH_INT_RATE_TIER_PLAN WHERE COD_PLAN = :B1 AND TRIM(COD_INT_TYPE) = 'CR' AND FLG_MNT_STATUS = 'A') WHERE BAL_INT_TIER >= :B2 ) AND FLG_MNT_STATUS = 'A' |
| dtxzgpqrkaxxj | SELECT NVL(BAL_ACCT_MAX, 0) FROM CI_CUST_IC_TYPES_XREF WHERE FLG_CUST_TYP = (SELECT FLG_CUST_TYP FROM CI_CUSTMAST WHERE FLG_MNT_STATUS = 'A' AND COD_CUST_ID = (SELECT COD_CUST FROM CH_ACCT_MAST WHERE COD_ACCT_NO = :B1 AND FLG_MNT_STATUS = 'A')) AND FLG_IC_TYP = (SELECT FLG_IC_TYP FROM CI_CUSTMAST WHERE FLG_MNT_STATUS = 'A' AND COD_CUST_ID = (SELECT COD_CUST FROM CH_ACCT_MAST WHERE COD_ACCT_NO = :B1 AND FLG_MNT_STATUS = 'A')) AND FLG_MNT_STATUS = 'A' |
| duhfg5b4scrmg | SELECT INNERQUERY.COD_CARD_NO, INNERQUERY.COD_CARD_TYP, INNERQUERY.COD_STOCK_NO FROM (SELECT C.COD_CARD_NO, C.COD_CARD_TYP, C.COD_STOCK_NO FROM CM_CARD_MCA_XREF_HIST C WHERE C.COD_MC_ACCT_NO = :B1 AND C.COD_CARD_TYP IN ('738', '781') ORDER BY C.DAT_DELINKED DESC) INNERQUERY WHERE ROWNUM = 1 |
| dwu6dg45gkcw6 | INSERT INTO XFACE_AT_REAL_TIME_IB_FT_TXN (DAT_TXN, REF_TXN_NO, COD_TXN_BRN, TXT_NAM_BRN_DR, TXT_NAM_BRN_CR, COD_ACCT_NO_DR, NAM_ACCT_TITLE_DR, COD_ACCT_NO_CR, NAM_ACCT_TITLE_CR, AMT_TXN, TXT_TXN_DESC, COD_USER_ID, COD_AUTH_ID, COD_BUSINESS_TYPE, SESSION_ID) SELECT CH.DAT_POST, X.REF_USR_NO, X.COD_EXT_BRANCH, (SELECT NAM_BRANCH_SHRT FROM BA_CC_BRN_MAST WHERE COD_CC_BRN = X.COD_CC_BRN_SUB_ACCT), (SELECT NAM_BRANCH_SHRT FROM BA_CC_BRN_MAST WHERE COD_CC_BRN = X.COD_CC_BRN_OTHR_ACCT), TRIM(X.COD_ACCT_NO), M.COD_MCA_TITLE, TRIM(X.COD_OTHER_ACCT_NO), (SELECT COD_MCA_TITLE FROM MC_ACCT_MAST WHERE COD_MC_ACCT_NO = X.COD_OTHER_ACCT_NO), CH.AMT_TXN, (CASE CH.COD_TXN_MNEMONIC WHEN 5003 THEN (CASE NVL(X.COD_EXT_TASK, '0') WHEN '0' THEN SUBSTR(NVL(CH.TXT_TXN_DESC, (SELECT TXT_TXN_DESC FROM BA_TXN_MNEMONIC BA WHERE FLG_MNT_STATUS = 'A' AND BA.COD_TXN_MNEMONIC = CH.COD_TXN_MNEMONIC)), 1, 20) ELSE SUBSTR(X.TXT_TXN_NARRATIVE, 1, 20) END) ELSE(CASE NVL(X.COD_EXT_TASK, '0') WHEN '0' THEN SUBSTR((SELECT TXT_TXN_DESC FROM BA_TXN_MNEMONIC BA WHERE FLG_MNT_STATUS = 'A' AND BA.COD_TXN_MNEMONIC = CH.COD_TXN_MNEMONIC), 1, 20) ELSE SUBSTR(X.TXT_TXN_NARRATIVE, 1, 20) END) END), X.COD_USER_ID, X.COD_AUTH_ID, X.TXN_BUSINESS_TYPE, :B1 FROM XFACE_ADDL_DETAILS_TXNLOG X, MC_ACCT_MAST M, CH_NOBOOK CH, TMP_XFACE_CORP_ACCOUNT TMP WHERE X.COD_EXT_TASK = (CASE WHEN X.COD_CHNL_ID = 'OBL' THEN (CASE WHEN X.COD_EXT_TASK = :B7 THEN '' ELSE X.COD_EXT_TASK END) ELSE :B6 END) AND CH.DAT_POST BETWEEN :B5 AND :B4 AND X.FLG_CA_TT = 'T' AND X.FLG_DR_CR = 'D' AND X.COD_CC_BRN_SUB_ACCT = :B3 AND X.COD_ACCT_NO = M.COD_MC_ACCT_NO AND M.COD_MCA_TITLE = NVL(:B2 , M.COD_MCA_TITLE) AND M.FLG_MNT_STATUS = 'A' AND X.COD_MODULE = 'CH' AND X.REF_TXN_NO = CH.REF_TXN_NO AND X.COD_SUB_ACCT_NO = CH.COD_ACCT_NO AND X.FLG_DR_CR = CH.COD_DRCR AND SUBSTR(X.REF_KEY_NO, 1, INSTR(X.REF_KEY_NO, '~', 1, 1) - 1) = CH.CTR_BATCH_NO AND SUBSTR(X.REF_KEY_NO, (INSTR(X.REF_KEY_NO, '~', 1, 1) + 1), (INSTR(X.REF_KEY_NO, '~', 1, 2) - (INSTR(X.REF_KEY_NO, '~', 1, 1) + 1))) = CH.REF_SYS_TR_AUD_NO AND SUBSTR(X.REF_KEY_NO, INSTR(X.REF_KEY_NO, '~', 1, 2) + 1) = CH.REF_SUB_SEQ_NO AND X.REF_TXN_NO_ORG IS NULL AND NOT EXISTS (SELECT B.REF_TXN_NO_ORG FROM XFACE_ADDL_DETAILS_TXNLOG B WHERE B.REF_TXN_NO_ORG = X.REF_TXN_NO) AND TMP.SESSION_ID = :B1 AND TMP.COD_ACCT_NO = CH.COD_ACCT_NO AND TMP.COD_ACCT_NO = X.COD_SUB_ACCT_NO ORDER BY CH.DAT_TXN DESC, CH.AMT_TXN DESC |
| dy8b6hq43tz50 | SELECT mc.cod_acct_no as mcSubAccountNo FROM mc_acct_xref mc, ch_acct_mast ch WHERE mc.cod_mc_acct_no = :1 AND mc.cod_ccy = :2 AND ch.cod_acct_no = mc.cod_acct_no AND ch.cod_acct_stat = 5 AND ch.flg_mnt_status = 'A' ORDER BY ch.dat_last_mnt DESC |
| f0m27qkmnbs01 | SELECT --+PARALLEL(4) B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, SUM(A.AMT_TXN_HOST), COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host FROM CH_ST_CAP_INPUT_TXN_MMDD A, CH_PROD_MAST B WHERE DAT_POST = TO_DATE('21-03-2013', 'DD-MM-YYYY') AND A.COD_PROD_HOST = B.COD_PROD AND A.COD_DRCR_DEST = 'C' AND COD_CCY_HOST = '156' AND B.COD_GL_INT_PAYABLE = '26003' AND a.cod_cc_brn_host = '847' GROUP BY B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host ORDER BY B.COD_GL_INT_PAYABLE, COD_CCY_HOST, COD_CC_BRN_HOST, A.COD_PROD_HOST |
| f1p2dkhruyq04 | DELETE XFACE_TEMP_ACCT_BAS_INFO WHERE SESSION_ID = :B1 |
| fa3j9swa56kdr | UPDATE CH_NOBOOK SET COD_PSBK_NO = :B9 , COD_PSBK_LINE_NO = :B8 , FLG_PASBKUPD = 'Y' WHERE COD_ACCT_NO = :B7 AND DAT_TXN = :B6 AND REF_TXN_NO = :B5 AND REF_SUB_SEQ_NO = :B4 AND CTR_BATCH_NO = :B3 AND REF_SYS_TR_AUD_NO = :B2 AND COD_DRCR = :B1 |
| fb52y2z8hdptn | DECLARE BEGIN :1 := PK_XFACE_INQ_CONSOLIDATED_ACCT.AP_INQ_CONSOLIDATED_ACCT(:2 , :3 , :4 , :5 , :6 , :7 ) ; END; |
| fc5sq9gk8crqy | INSERT INTO XFACE_AT_MCA_OPEN_CLOSE_LOG (DAT_ACCT_OPEN, COD_CC_BRN, REF_TXN_NO, REF_USR_NO, COD_MC_ACCT_NO, EXTERNAL_CUSTOMER_IC_TYPE, EXTERNAL_CUSTOMER_IC, COD_GL_CODE, NAM_PRODUCT, ACCT_PROPERTY, FLG_CUST_TYPE, INDUSTRY_TYPE, CTR_TERM, DAT_APPROVAL, AMT_LOG, DEPUTY_NAME, DEPUTY_IC_TYPE, DEPUTY_IC_NO, FLG_IC_VERIFIED, COD_USER_ID, COD_AUTH_ID, COD_ACCT_TITLE, FLG_ACCT_OPEN_CLOSE, TXN_DATE, FLG_CASH_REMIT, DAT_PROCESS, DAT_ACCT_CLOSE, INQUIRED_BRN_CODE, COD_CARD_ALLINONE_NO) SELECT A.DAT_ACCT_OPEN, (SELECT D.COD_EXTERNAL_BRANCH FROM BA_EXT_BRANCH_XREF D WHERE D.COD_CC_BRN = A.COD_CC_BRN AND D.FLG_MNT_STATUS = 'A'), A.REF_TXN_NO, A.REF_USR_NO, A.COD_MC_ACCT_NO, A.FLG_CUST_TYPE, A.EXTERNAL_CUSTOMER_IC, A.COD_GL_CODE, A.NAM_PRODUCT, A.COD_PROD_TYPE, A.FLG_CUST_TYPE, A.INDUSTRY_TYPE, A.CTR_TERM, PK_XFACE_AUDIT_TRAIL.GET_DAT_ACCT_APPROVAL(A.COD_MC_ACCT_NO), A.AMT_LOG, A.DEPUTY_NAME, A.DEPUTY_IC_TYPE, A.DEPUTY_IC_NO, A.FLG_IC_VERIFIED, A.COD_USER_ID, A.COD_AUTH_ID, A.NAM_CUST_SHRT, NVL2(A.DAT_ACCT_CLOSE, '1', '0'), A.DAT_TXN, A.COD_PROD_TYPE, PK_BA_GLOBAL.DAT_PROCESS, A.DAT_ACCT_CLOSE, (SELECT D.COD_EXTERNAL_BRANCH FROM BA_EXT_BRANCH_XREF D WHERE D.COD_CC_BRN = M.COD_CC_BRN AND D.FLG_MNT_STATUS = 'A'), NULL FROM AT_MCA_OPEN_CLOSE_LOG A, MC_ACCT_MAST M WHERE A.COD_PROD_TYPE = NVL(:B5 , A.COD_PROD_TYPE) AND A.COD_PROD = NVL(:B4 , A.COD_PROD) AND A.COD_CCY IN (0, NVL(:B3 , A.COD_CCY)) AND A.DAT_ACCT_CLOSE IS NULL AND A.DAT_ACCT_OPEN BETWEEN NVL(:B2 , A.DAT_ACCT_OPEN) AND NVL(:B1 , A.DAT_ACCT_OPEN) AND M.COD_MC_ACCT_NO = A.COD_MC_ACCT_NO AND M.COD_CC_BRN IN (SELECT COD_CC_BRN FROM GTT_LOWER_BRANCH WHERE SESSION_ID = :B6 ) AND M.FLG_MNT_STATUS = 'A' AND A.FLG_REVERSE = 'N' |
| fkt6r66zc3871 | SELECT --+PARALLEL(4) B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, SUM(A.AMT_TXN_HOST), COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host FROM CH_ST_CAP_INPUT_TXN_MMDD A, CH_PROD_MAST B WHERE DAT_POST = TO_DATE('21-03-2013', 'DD-MM-YYYY') AND A.COD_PROD_HOST = B.COD_PROD AND A.COD_DRCR_DEST = 'C' AND COD_CCY_HOST = '156' AND B.COD_GL_INT_PAYABLE = '26003' AND a.cod_cc_brn_host = '852' GROUP BY B.COD_GL_INT_PAYABLE, A.COD_TXN_MNEMONIC, COD_CCY_HOST, A.COD_CC_BRN_HOST, a.cod_prod_host ORDER BY B.COD_GL_INT_PAYABLE, COD_CCY_HOST, COD_CC_BRN_HOST, A.COD_PROD_HOST |
| fncvutyxcczzb | update vwe_ci_custmast set NAM_CUST_SHRT=:1 , COD_OFFICR_ID=:2 , COD_CUST_NATL_ID=:3 , COD_NATL_ID_OLD=:4 , CIF_TYPE=:5 , FLG_REST_CUST=:6 , dat_cif_type_change=:7 , COD_CUST_PHONETIC=:8 , COD_MID_PHONETIC=:9 , COD_FIRST_PHONETIC=:10 , FLG_MEMBER=:11 , COD_MEMBER_NO=:12 , COD_CUST_LANG=:13 , FLG_IC_TYP=:14 , FLG_CUST_TYP=:15 , COD_TDS=:16 , COD_TDS_2=:17 , TXT_CUST_NATNLTY=:18 , COD_CC_HOMEBRN=:19 , DAT_CUST_OPEN=:20 , cod_last_mnt_chkrid=:21 , cod_last_mnt_makerid=:22 , dat_last_mnt=:23 , ctr_updat_srlno=:24 , cod_mnt_action=:25 , FLG_KIO=:26 , REF_CUST_IT_NUM=:27 , FLG_KEY_CHG=:28 , FLG_REPLICATE=:29 , FLG_LOCK_FAC=:30 , flg_blocked=:31 , cod_block_reason=:32 , COD_EMPLOYEE_ID=:33 , NAM_IC_Issuer=:34 , DAT_IC_Issue=:35 , DAT_IC_Expiry=:36 , FLG_Dom_Overseas=:37 , TXT_Cust_region=:38 , FLG_Composite_Stat=:39 , FLG_Statement_Freq=:40 , FLG_All_One=:41 , COD_Cust_Class=:42 , dat_next_stmt=:43 , dat_last_stmt=:44 , External_Customer_IC=:45 , External_Customer_IC_TYPE=:46 , COD_CUSTADR_TYPE=:47 , COD_CUST_REGION=:48 , TXT_STMT_REGION=:49 , COD_ACCT_NO_DEFAULT=:50 , FLG_CUST_STATUS=:51 , COD_TYP_ACCOM=:52 , COD_BANK_CARD=:53 , REF_CUST_EMAIL=:54 , REF_CUST_TELEX=:55 , REF_PHONE_MOBILE=:56 , COD_CUSTMOB_INTERNATION_CODE=:57 , TXT_MOB_EMAIL_ADD=:58 , FLG_CUST_MEMO=:59 , NAM_CUST_FULL=:60 , dat_birth_cust=:61 , FLG_LOC_GLOB=:62 , FLG_STAFF=:63 , FLG_SPL_CUST=:64 , REF_CUST_FAX=:65 , FLG_IC_VALIDITY=:66 , NAM_CNTRY_INCORP=:67 , DAT_INCORPORATED=:68 , COD_BUSINESS_REGNO=:69 , COD_BUSINESS_CAT=:70 , TXT_BUSINESS_TYP=:71 , COD_LIAB_NO=:72 , CREDIT_RATING=:73 , DAT_REVISION=:74 , AMT_LIMIT_TOT=:75 , COD_CCY_LIMIT=:76 , FX_CUST_CLEAN_RISK_LIMIT=:77 , SEC_CLEAN_RISK_LIMIT=:78 , SEC_CUST_CLEAN_RISK_LIMIT=:79 , SEC_PSTL_RISK_LIMIT=:80 , SEC_CUST_PSTL_RISK_LIMIT=:81 , LAST_RENEW_DATE=:82 , FLG_UNADV=:83 , FLG_DOC_COMPLETE=:84 where COD_CUST_ID=:85 and FLG_MNT_STATUS=:86 |
| fupqz8tghywt9 | UPDATE CH_ACCT_MAST SET BAL_AVAILABLE = BAL_AVAILABLE + :B4 , CTR_FUNDS_CR_TODAY = CTR_FUNDS_CR_TODAY + :B3 , CTR_UPDAT_SRLNO = CTR_UPDAT_SRLNO + 1 WHERE COD_ACCT_NO = :B2 AND FLG_MNT_STATUS = 'A' AND CTR_UPDAT_SRLNO = :B1 |
| fvudx1j8k7cvh | DECLARE BEGIN :1 := AP_TD_TXN_REDEEM_POST(:2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 ) ; END; |
| fy9pud8ukfxpj | insert into xf_ol_st_ext_txn_xref (DAT_POST, DAT_LOG, ref_usr_no, DAT_TXN, REF_SYS_TR_AUD_NO, CTR_BATCH_NO, COD_MSG_TYP, cod_user_id, SUB_SEQ_NO, COD_ORG_BRN, COD_ORG_BANK, channel_id, REF_TXN_NO) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 ) |
| fyh4kmmzygp7j | delete from vwe_ci_custmast_signatory where cod_cust_id=:1 and flg_mnt_status=:2 |
| g39hma9tk8s49 |
select termdeposi0_.COD_PROD as COD1_266_0_, termdeposi0_.FLG_MNT_STATUS as FLG2_266_0_, termdeposi0_.NAM_PRODUCT as NAM3_266_0_, termdeposi0_.COD_PROD_TYPE as COD4_266_0_, termdeposi0_.cod_last_mnt_chkrid as cod5_266_0_, termdeposi0_.cod_last_mnt_makerid as cod6_266_0_, termdeposi0_.CTR_UPDAT_SRLNO as CTR7_266_0_, termdeposi0_.FLG_RECALCULATE_INT as FLG8_266_0_, termdeposi0_.DAT_LAST_MNT as DAT9_266_0_, termdeposi0_.cod_mnt_action as cod10_266_0_, termdeposi0_.DAT_PROD_END as DAT11_266_0_, termdeposi0_.cod_ccy as cod12_266_0_, termdeposi0_.AMT_DEP_MIN1 as AMT13_266_0_, termdeposi0_.AMT_WITHDRAW_UNIT as AMT14_266_0_, termdeposi0_.AMT_LIM_IB_WITHDRAW as AMT15_266_0_, termdeposi0_.AMT_DEP_MIN2 as AMT16_266_0_, termdeposi0_.AMT_UNIT_INCR_DEP as AMT17_266_0_, termdeposi0_.AMT_DEP_MIN as AMT18_266_0_, termdeposi0_.AMT_DEP_MAX as AMT19_266_0_, termdeposi0_.AMT_MIN_ORDER as AMT20_266_0_, termdeposi0_.AMT_MIN_WITHDR as AMT21_266_0_, termdeposi0_.AMT_DEP_MIN_TOP_UP as AMT22_266_0_, termdeposi0_.AMT_UNIT_INCR_DEP_TOP_UP as AMT23_266_0_, termdeposi0_.cod_passbk_lvl as cod24_266_0_, termdeposi0_.COD_SC_PKG as COD25_266_0_, termdeposi0_.FLG_PARTIAL_PRD_INT as FLG26_266_0_, termdeposi0_.FRQ_PMI_ACCRUAL as FRQ27_266_0_, termdeposi0_.TXT_MSG_ADV as TXT28_266_0_, termdeposi0_.FLG_POST as FLG29_266_0_, termdeposi0_.FLG_PMI_RECOMPUTE as FLG30_266_0_, termdeposi0_.FLG_PMI_INCL_VAR as FLG31_266_0_, termdeposi0_.FLG_DISALLOW_MULT_DEPOSITS as FLG32_266_0_, termdeposi0_.FLG_TOPUP_ALLOW as FLG33_266_0_, termdeposi0_.COD_DORMANCY_PLAN as COD34_266_0_, termdeposi0_.COD_REST_PRINC_OPT as COD35_266_0_, termdeposi0_.COD_GL_REPL_COST as COD36_266_0_, termdeposi0_.CTR_RENEW_GRACE_PRD as CTR37_266_0_, termdeposi0_.REN_RATE as REN38_266_0_, termdeposi0_.CTR_FORCE_RENEW_TERM as CTR39_266_0_, termdeposi0_.COD_AUTO_RENEW_REDEM_OPT as COD40_266_0_, termdeposi0_.COD_INT_PAY_OPT as COD41_266_0_, termdeposi0_.COD_PROD_REINVEST as COD42_266_0_, termdeposi0_.FLG_RENEW_MAT_DATE as FLG43_266_0_, termdeposi0_.CTR_AUTO_RENEW_TERM as CTR44_266_0_, termdeposi0_.CTR_MAT_NOT_LEAD_DAYS as CTR45_266_0_, termdeposi0_.CTR_UNCLAIM_DEP_XFER_DAYS as CTR46_266_0_, termdeposi0_.FLG_UNCLAIM_OPT as FLG47_266_0_, termdeposi0_.CTR_NTC_LEAD_DAYS as CTR48_266_0_, termdeposi0_.COD_INT_PMI_BAS as COD49_266_0_, termdeposi0_.COD_INT_PRE_MAT_WD_BAS as COD50_266_0_, termdeposi0_.COD_BROKEN_PRE_MAT_WD_BASIS as COD51_266_0_, termdeposi0_.FLG_PMI_INT_COMP_INCLUDE as FLG52_266_0_, termdeposi0_.CTR_MAX_REDEEM_ALLOWED as CTR53_266_0_, termdeposi0_.COD_INT_VAR_TYP as COD54_266_0_, termdeposi0_.COD_ISSUER_DD as COD55_266_0_, termdeposi0_.COD_ISSUER_BC as COD56_266_0_, termdeposi0_.COD_ISSUER_EXTERNAL_TRF as COD57_266_0_, termdeposi0_.COD_INT_INDX_PENALTY as COD58_266_0_, termdeposi0_.COD_INDX_POST_MAT as COD59_266_0_, termdeposi0_.COD_INT_COMP_BAS as COD60_266_0_, termdeposi0_.COD_INT_PAY_BAS as COD61_266_0_, termdeposi0_.FRQ_INT_COMPOUND as FRQ62_266_0_, termdeposi0_.FRQ_STMT_GEN as FRQ63_266_0_, termdeposi0_.UNCLM_DEP_PROC_FREQ as UNCLM64_266_0_, termdeposi0_.FRQ_PRD_INT_PAYMENT as FRQ65_266_0_, termdeposi0_.FRQ_INT_PAYMENT as FRQ66_266_0_, termdeposi0_.flg_taxable as flg67_266_0_, termdeposi0_.NAM_POST_MATURITY_INT as NAM68_266_0_, termdeposi0_.NAM_PENALTY_ROUTINE as NAM69_266_0_, termdeposi0_.COD_ACCR_START_MTH as COD70_266_0_, termdeposi0_.COD_INT_ACCR_BAS as COD71_266_0_, termdeposi0_.COD_ACCR_START_WK_DAY as COD72_266_0_, termdeposi0_.FRQ_ACCRUAL as FRQ73_266_0_, termdeposi0_.COD_BROKEN_ACCR_BASIS as COD74_266_0_, termdeposi0_.RAT_MAX_VAR as RAT75_266_0_, termdeposi0_.RAT_MAX as RAT76_266_0_, termdeposi0_.RAT_PENALTY as RAT77_266_0_, termdeposi0_.RAT_MIN as RAT78_266_0_, termdeposi0_.RAT_MIN_VAR as RAT79_266_0_, termdeposi0_.COD_INT_RATE_CTRL as COD80_266_0_, termdeposi0_.TXN_PROFIT_RATIO as TXN81_266_0_, termdeposi0_.FLG_PENALTY_RATE as FLG82_266_0_, termdeposi0_.FLG_ADD_PENDING_INT as FLG83_266_0_, termdeposi0_.FLG
_DISC_INTEREST as FLG84_266_0_, termdeposi0_.FLG_PART_WITHDRAW as FLG85_266_0_, termdeposi0_.FLG_PSC_FAC as FLG86_266_0_, termdeposi0_.FLG_NEGOTIABLE as FLG87_266_0_, termdeposi0_.FLG_RED_REN_UNCLAIMED_ACCTS as FLG88_266_0_, termdeposi0_.FLG_COMP_UPD_RUNNING_BAL as FLG89_266_0_, termdeposi0_.FLG_LIEN_ALLOWED as FLG90_266_0_, termdeposi0_.FLG_DENM_DEPS as FLG91_266_0_, termdeposi0_.FLG_PENALTY_ROUTINE as FLG92_266_0_, termdeposi0_.FLG_INT_HOLIDAY as FLG93_266_0_, termdeposi0_.FLG_TRAN_SAME_CUST as FLG94_266_0_, termdeposi0_.FLG_DEBIT_FAC as FLG95_266_0_, termdeposi0_.CTR_LOCKIN_TERM as CTR96_266_0_, termdeposi0_.FLG_DEP_TERM_UNIT as FLG97_266_0_, termdeposi0_.COD_CCY_TDS as COD98_266_0_, termdeposi0_.CTR_HIST_RETEN_PRD as CTR99_266_0_, termdeposi0_.CTR_ACCT_RETEN_PRD as CTR100_266_0_, termdeposi0_.CTR_DEP_INCR_TERM as CTR101_266_0_, termdeposi0_.CTR_DEP_TERM_MAX as CTR102_266_0_, termdeposi0_.CTR_DEP_TERM_MIN2 as CTR103_266_0_, termdeposi0_.CTR_DEP_TERM_MIN1 as CTR104_266_0_, termdeposi0_.CTR_DEP_TERM_MIN as CTR105_266_0_, termdeposi0_.CTR_MIN_DEP_INT_PRD as CTR106_266_0_, termdeposi0_.CTR_TERM_MIN_PENALTY as CTR107_266_0_, termdeposi0_.COD_DISC_TYPE as COD108_266_0_, termdeposi0_.FLG_PREMAT_REDEEM as FLG109_266_0_, termdeposi0_.FLG_RED_PAY_BY_LOAN as FLG110_266_0_, termdeposi0_.FLG_RED_PAY_BY_CHQ as FLG111_266_0_, termdeposi0_.FLG_RED_PAY_BY_GL as FLG112_266_0_, termdeposi0_.FLG_RED_PAY_REINVEST as FLG113_266_0_, termdeposi0_.FLG_RED_PAY_INT_XFER as FLG114_266_0_, termdeposi0_.FLG_RED_PAY_BY_CASH as FLG115_266_0_, termdeposi0_.FLG_REDEEM_OPT as FLG116_266_0_, termdeposi0_.FLG_RED_PAY_EXT_XFER as FLG117_266_0_, termdeposi0_.FLG_RED_PAY_BY_DD as FLG118_266_0_, termdeposi0_.FLG_INT_PAY_EXT_XFER as FLG119_266_0_, termdeposi0_.FLG_INT_PAY_INT_XFER as FLG120_266_0_, termdeposi0_.FLG_INT_PAY_BY_DD as FLG121_266_0_, termdeposi0_.FLG_INT_PAY_BY_GL as FLG122_266_0_, termdeposi0_.FLG_INT_PAY_BY_CASH as FLG123_266_0_, termdeposi0_.FLG_INT_PAY_BY_LOAN as FLG124_266_0_, termdeposi0_.FLG_INT_PAY_REINVEST as FLG125_266_0_, termdeposi0_.FLG_INT_PAY_BY_CHQ as FLG126_266_0_, termdeposi0_.FLG_PAYIN_BY_GL as FLG127_266_0_, termdeposi0_.FLG_PAYIN_BY_CASA as FLG128_266_0_, termdeposi0_.FLG_PAYIN_BY_CHQ as FLG129_266_0_, termdeposi0_.FLG_PAYIN_BY_CASH as FLG130_266_0_, termdeposi0_.COD_GL_MAT_DEP_OUTST as COD131_266_0_, termdeposi0_.COD_GL_INT_ACCRUED as COD132_266_0_, termdeposi0_.COD_GL_INT_EXPENSE as COD133_266_0_, termdeposi0_.COD_GL_TAX_WITHLD as COD134_266_0_, termdeposi0_.COD_GL_UNCLAIM_DEP_XFER as COD135_266_0_, termdeposi0_.COD_GL_INT_PAYABLE as COD136_266_0_, termdeposi0_.COD_GL_RED_PAYABLE as COD137_266_0_, termdeposi0_.COD_GL_PAYOUT as COD138_266_0_, termdeposi0_.COD_GL_INT_DISC as COD139_266_0_, termdeposi0_.COD_GL_INT_COMPOUNDED as COD140_266_0_, termdeposi0_.COD_GL_PAYMENT as COD141_266_0_, termdeposi0_.COD_GL_TAX_WITHLD_2 as COD142_266_0_, termdeposi0_.COD_GL_TAX_WITHLD_ADDL1 as COD143_266_0_, termdeposi0_.COD_GL_TAX_WITHLD_ADDL1_2 as COD144_266_0_, termdeposi0_.COD_GL_TAX_WITHLD_ADDL2 as COD145_266_0_, termdeposi0_.COD_GL_TAX_WITHLD_ADDL2_2 as COD146_266_0_, termdeposi0_.COD_GL_REGULAR_DEP as COD147_266_0_, termdeposi0_.COD_FMT_INT_FAILED as COD148_266_0_, termdeposi0_.COD_FMT_INT_REMIT as COD149_266_0_, termdeposi0_.COD_FMT_DEP_RENEWED as COD150_266_0_, termdeposi0_.COD_FMT_RED_FAILED as COD151_266_0_, termdeposi0_.COD_FMT_DEP_CON as COD152_266_0_, termdeposi0_.COD_FMT_INT_ADJUST as COD153_266_0_, termdeposi0_.COD_PSBK_ID as COD154_266_0_, termdeposi0_.ID_DEP_DENM1 as ID155_266_0_, termdeposi0_.ID_DEP_DENM2 as ID156_266_0_, termdeposi0_.ID_DEP_DENM3 as ID157_266_0_, termdeposi0_.ID_DEP_DENM4 as ID158_266_0_, termdeposi0_.ID_DEP_DENM5 as ID159_266_0_, termdeposi0_.ID_DEP_DENM6 as ID160_266_0_, termdeposi0_.ID_DEP_DENM7 as ID161_266_0_, termdeposi0_.ID_DEP_DENM8 as ID162_266_0_, termdeposi0_.ID_DEP_DENM9 as ID163_266_0_, termdeposi0_.ID_DEP_DENM10 as ID164
_266_0_, termdeposi0_.ID_DEP_DENM11 as ID165_266_0_, termdeposi0_.ID_DEP_DENM12 as ID166_266_0_, termdeposi0_.ID_DEP_DENM13 as ID167_266_0_, termdeposi0_.ID_DEP_DENM14 as ID168_266_0_, termdeposi0_.ID_DEP_DENM15 as ID169_266_0_, termdeposi0_.ID_DEP_DENM16 as ID170_266_0_, termdeposi0_.ID_DEP_DENM17 as ID171_266_0_, termdeposi0_.ID_DEP_DENM18 as ID172_266_0_, termdeposi0_.ID_DEP_DENM19 as ID173_266_0_, termdeposi0_.ID_DEP_DENM20 as ID174_266_0_, termdeposi0_.TXT_DEP_DENM1 as TXT175_266_0_, termdeposi0_.TXT_DEP_DENM2 as TXT176_266_0_, termdeposi0_.TXT_DEP_DENM3 as TXT177_266_0_, termdeposi0_.TXT_DEP_DENM4 as TXT178_266_0_, termdeposi0_.TXT_DEP_DENM5 as TXT179_266_0_, termdeposi0_.TXT_DEP_DENM6 as TXT180_266_0_, termdeposi0_.TXT_DEP_DENM7 as TXT181_266_0_, termdeposi0_.TXT_DEP_DENM8 as TXT182_266_0_, termdeposi0_.TXT_DEP_DENM9 as TXT183_266_0_, termdeposi0_.TXT_DEP_DENM10 as TXT184_266_0_, termdeposi0_.TXT_DEP_DENM11 as TXT185_266_0_, termdeposi0_.TXT_DEP_DENM12 as TXT186_266_0_, termdeposi0_.TXT_DEP_DENM13 as TXT187_266_0_, termdeposi0_.TXT_DEP_DENM14 as TXT188_266_0_, termdeposi0_.TXT_DEP_DENM15 as TXT189_266_0_, termdeposi0_.TXT_DEP_DENM16 as TXT190_266_0_, termdeposi0_.TXT_DEP_DENM17 as TXT191_266_0_, termdeposi0_.TXT_DEP_DENM18 as TXT192_266_0_, termdeposi0_.TXT_DEP_DENM19 as TXT193_266_0_, termdeposi0_.TXT_DEP_DENM20 as TXT194_266_0_, termdeposi0_.FLG_AUTO_CARRY_FWD_DEP_VAR as FLG195_266_0_, termdeposi0_.SLAB_CHG_ON_RED as SLAB196_266_0_, termdeposi0_.AMT_CDF_LIMIT_USD as AMT197_266_0_ from td_prod_mast termdeposi0_ where termdeposi0_.COD_PROD=:1 and termdeposi0_.FLG_MNT_STATUS=:2 |
| g7y88gsq1rbch | DECLARE BEGIN :1 := PK_XFACE_INQ_MOVE_IN_OUT.AP_XFACE_MOVE_IN_OUT(:2 , :3 , :4 , :5 ) ; END; |
| ga6x380kh2uz1 | SELECT DTLS.COD_MC_ACCT_NO, DTLS.COD_ACCT_NO, COD_ACCT_BRN, COD_INSTR_NO, DTLS.COD_PROD, COD_SWP_TYPE, COD_SWP_EXEC_TYPE, FRQ_SWPOUT, DAT_SWPOUT_START, DAT_SWPOUT_END, TXT_SWPOUT_NARR, MC_PKG_CODE, COD_PROD_SUB_ACCT, COD_PROD_IDENTIFIER, COD_CCY_SUB_ACCT, RAT_SUB_ACCT_VAR, FRQ_INT_COMP, FRQ_INT_PAY, CTR_TERM_MONTHS, CTR_TERM_DAYS, AMT_BASE, DTLS.COD_MNT_ACTION, DTLS.COD_LAST_MNT_MAKERID, DTLS.COD_LAST_MNT_CHKRID, DTLS.DAT_LAST_MNT, DTLS.FLG_MNT_STATUS, DTLS.CTR_UPDAT_SRLNO, DTLS.COD_ENTITY_VPD, DAT_NEXT_SWPOUT, BAL_MIN_RET_SWPOUT, AMT_MAX_SWPOUT, AMT_ECONOMIC_SWPOUT, SWEEP_OUT_LEVEL, COD_CCY_SWPOUT, COD_SWP_OUT, AGREEMENT_ID, FLG_SWEEPIN_PROVIDER, SWEEPOUT_TIME, COD_ACCT_NO_BENEF , CH.AGMT_STAT, SWEEP_PERCENTAGE, DTLS.AMT_INCREMENTAL, DTLS.CTR_FUND_TRANSFER FROM MC_SWP_DTLS DTLS , CH_SWEEP_AGMT CH, CH_ACCT_MAST CA WHERE DAT_NEXT_SWPOUT <= :B4 AND DTLS.COD_ACCT_NO = CA.COD_ACCT_NO AND CA.COD_ACCT_STAT NOT IN (1, 5) AND CA.FLG_MNT_STATUS = 'A' AND ((:B6 BETWEEN DAT_SWPOUT_START AND DAT_SWPOUT_END) OR (DAT_SWPOUT_END BETWEEN :B5 AND :B4 )) AND DAT_NEXT_SWPOUT <= DAT_SWPOUT_END AND DTLS.COD_ACCT_NO = DECODE(:B3 , 'O', :B2 , DTLS.COD_ACCT_NO) AND DTLS.FLG_MNT_STATUS = 'A' AND (DTLS.CTR_FUND_TRANSFER = 0 OR DTLS.CTR_FUND_TRANSFER > DTLS.CTR_SUCC_TRANSFER) AND DTLS.AGREEMENT_ID = CH.AGMT_ID(+) AND (CH.AGMT_STAT = 'A' OR CH.AGMT_ID IS NULL) AND DTLS.COD_SWP_EXEC_TYPE = DECODE(:B1 , 0, COD_SWP_EXEC_TYPE, :B1 ) |
| gd0z9rpr5kb0m |
INSERT INTO TEMP_PS_PSBK_DTLS (COD_RECORD_TYP, COD_MC_ACCT_NO, COD_ACCT_NO, COD_DEP_NO, MC_PKG_CODE, REF_TXN_NO, REF_USR_NO, CTR_BATCH_NO, COD_CC_BRN_TXN, COD_USERNO, COD_AUTH_ID, DAT_TXN, DAT_VALUE, DAT_POST, REMARK, PURPOSE_CODE, TXT_PURPOSE_DESC, AMT_TXN, COD_MC_ACCT_CCY, COD_TXN_CCY, COD_DRCR, COD_MSG_TYP, AMT_RUNNING_BAL, DEP_VALUE_DATE, DAT_MATURITY, AMT_INT, AMT_TAX, RAT_DEP_INT, CTR_DEP_TERM_DAYS, CTR_DEP_TERM_MONTHS, COD_PAGE_NO, COD_LINE_NO, SESSION_ID, REF_SUB_SEQ_NO, REF_SYS_TR_AUD_NO, GAS_METER_POINT, COD_MODULE, COD_PASSBK_LITERAL, ROW_NUM) SELECT COD_RECORD_TYP, COD_MC_ACCT_NO, COD_ACCT_NO, COD_DEP_NO, MC_PKG_CODE, REF_TXN_NO, REF_USR_NO, CTR_BATCH_NO, COD_CC_BRN_TXN, COD_USERNO, COD_AUTH_ID, DAT_TXN, DAT_VALUE, DAT_POST, REMARK, PURPOSE_CODE, TXT_PURPOSE_DESC, AMT_TXN, COD_MC_ACCT_CCY, COD_TXN_CCY, COD_DRCR, COD_MSG_TYP, AMT_RUNNING_BAL, DEP_VALUE_DATE, DAT_MATURITY, AMT_INT, AMT_TAX, RAT_DEP_INT, CTR_DEP_TERM_DAYS, CTR_DEP_TERM_MONTHS, COD_PAGE_NO, COD_LINE_NO, SESSION_ID, REF_SUB_SEQ_NO, REF_SYS_TR_AUD_NO, GAS_METER_POINT, COD_MODULE, COD_PASSBK_LITERAL, ROWNUM FROM (SELECT 0 AS COD_RECORD_TYP, :B10 AS COD_MC_ACCT_NO, CH.COD_ACCT_NO AS COD_ACCT_NO, 0 AS COD_DEP_NO, :B11 AS MC_PKG_CODE, CH.REF_TXN_NO AS REF_TXN_NO, CH.REF_USR_NO AS REF_USR_NO, CH.CTR_BATCH_NO AS CTR_BATCH_NO, CH.COD_CC_BRN_TXN AS COD_CC_BRN_TXN, CH.COD_USERNO AS COD_USERNO, XF.COD_AUTH_ID AS COD_AUTH_ID, CH.DAT_TXN AS DAT_TXN, CH.DAT_VALUE AS DAT_VALUE, CH.DAT_POST AS DAT_POST, AP_XFACE_GET_TXN_LITERAL(VAR_P_COD_TASK_DERIVED => (CASE WHEN (XF.COD_SERVICE_ID = '015' AND CH.COD_TXN_MNEMONIC = 5001) THEN 'EOD' WHEN (XF.COD_SERVICE_ID = '019' AND CH.COD_TXN_MNEMONIC = '1321' AND XF.FLG_CA_TT = 'T') THEN XF.COD_EXT_TASK WHEN (XF.COD_SERVICE_ID = '019' AND CH.COD_TXN_MNEMONIC = '1321' AND XF.FLG_CA_TT = 'C') THEN XF.COD_EXT_TASK ELSE NVL(XF.COD_EXT_TASK, 'EOD') END), VAR_P_COD_TXN_MNEMONIC => (CASE WHEN (XF.COD_SERVICE_ID = '019' AND CH.COD_TXN_MNEMONIC = '1321' AND XF.FLG_CA_TT = 'T') THEN 1006 WHEN (XF.COD_SERVICE_ID = '019' AND CH.COD_TXN_MNEMONIC = '1321' AND XF.FLG_CA_TT = 'C') THEN 1401 ELSE DECODE(NVL(XF.COD_EXT_TASK, 'EOD'), 'EOD', NVL(GET_XFACE_ALT_MNEMONIC_CODE(CH.COD_TXN_MNEMONIC, CH.COD_TXN_LITERAL), CH.COD_TXN_MNEMONIC), CH.COD_TXN_MNEMONIC) END), VAR_P_COD_MSG_TYP => (CASE WHEN (XF.FLG_ONLINE_UPLOAD = 'U' AND CH.AMT_TXN <= 0 AND CH.COD_MSG_TYP IN (200, 1)) THEN 400 ELSE (CASE CH.COD_MSG_TYP WHEN 1 THEN 200 WHEN 2 THEN 400 ELSE CH.COD_MSG_TYP END) END), VAR_COD_MC_ACCT_NO => :B10 , VAR_P_PSBK_NO => :B9 , VAR_P_PSBK_TYPE => :B8 , VAR_P_ALL_IN_ONE_NO => :B7 ) AS REMARK, ACC_PURPOSE_CODE AS PURPOSE_CODE, GET_PURPOSE_CODE(ACC_PURPOSE_CODE, COD_TXN_MNEMONIC) AS TXT_PURPOSE_DESC, AMT_TXN AS AMT_TXN, :B6 AS COD_MC_ACCT_CCY, COD_TXN_CCY AS COD_TXN_CCY, COD_DRCR AS COD_DRCR, (CASE COD_MSG_TYP WHEN 200 THEN 1 ELSE 2 END) AS COD_MSG_TYP, :B5 AS AMT_RUNNING_BAL, NULL AS DEP_VALUE_DATE, NULL AS DAT_MATURITY, DECODE(COD_TXN_LITERAL, 'CIN', AMT_TXN_TCY, NULL) AS AMT_INT, DECODE(COD_TXN_LITERAL, 'TAX', AMT_TXN_TCY, NULL) AS AMT_TAX, NULL AS RAT_DEP_INT, NULL AS CTR_DEP_TERM_DAYS, NULL AS CTR_DEP_TERM_MONTHS, NULL AS COD_PAGE_NO, NULL AS COD_LINE_NO, :B4 AS SESSION_ID, CH.REF_SUB_SEQ_NO AS REF_SUB_SEQ_NO, CH.REF_SYS_TR_AUD_NO AS REF_SYS_TR_AUD_NO, XF.TXT_TXN_NARRATIVE AS GAS_METER_POINT, 'CH' AS COD_MODULE, CH.TXT_TXN_DESC AS COD_PASSBK_LITERAL FROM CH_NOBOOK CH, XFACE_ADDL_DETAILS_TXNLOG XF WHERE CH.COD_ACCT_NO = :B3 AND CH.DAT_TXN <= :B2 AND CH.DAT_TXN >= :B1 AND CH.COD_ACCT_NO = XF.COD_SUB_ACCT_NO(+) AND CH.REF_TXN_NO = XF.REF_TXN_NO(+) AND TRIM(TO_CHAR(CH.CTR_BATCH_NO)) || '~' || TRIM(TO_CHAR(CH.REF_SYS_TR_AUD_NO)) || '~' || TRIM(TO_CHAR(CH.REF_SUB_SEQ_NO)) = NVL(XF.REF_KEY_NO(+), TRIM(TO_CHAR(CH.CTR_BATCH_NO)) || '~' || TRIM(TO_CHAR(CH.REF_SYS_TR_AUD_NO)) || '~' || TRIM(TO_CHAR(CH.REF_
SUB_SEQ_NO))) AND FLG_PASBKUPD = 'N' ORDER BY CH.DAT_TXN, CH.COD_MSG_TYP, (CASE WHEN (CH.COD_MSG_TYP = 400 AND CH.COD_DRCR = 'D') THEN 'C' WHEN (CH.COD_MSG_TYP = 400 AND CH.COD_DRCR = 'C') THEN 'D' ELSE CH.COD_DRCR END), CH.AMT_TXN) INNERQUERY |
| gjqqsdcmf1s5q | SELECT DECODE(FLAG_ONLINE_UPLOAD, 'U', 'Y', 'O', 'N'), ACCOUNT_PROPERTY, INTEREST_TRANSFER_IN_ACCOUNT FROM XFACE_SUB_ACCT_ADDNL_DTLS A, MC_ACCT_XREF B WHERE A.COD_MC_ACCT_NO = B.COD_MC_ACCT_NO AND B.COD_MC_ACCT_NO = :B1 AND A.COD_CCY = B.COD_CCY AND B.FLG_MNT_STATUS = 'A' |
| gks2z61hq8m6u | SELECT COD_MC_ACCT_NO, COD_ACCT_NO, COD_CCY, COD_ACCT_TYP, COD_CC_BRN, COD_ACCT_TITLE, COD_PROD, COD_PROD_NAM, COD_CUSTID, COD_DEP_NO, COD_DAT_VALUE, COD_INT_RATE, COD_FLG_AUTO_RENEW, COD_CASH_REMIT_FLG, COD_ACCT_NATURE, COD_WITHDR_METHOD, COD_CASH_INTR_BRN_TXN_FLG, COD_FUND_INTR_BRN_TXN_FLG, COD_BAL_BOOK, COD_HOLD_AMT, COD_STOP_PAY_AMT, COD_BAL_AVAILABLE, COD_NET_BAL, COD_DAT_ACCT_OPEN, COD_ACCT_STATUS, COD_DAT_ACCT_CLOSE, COD_DAT_LAST_CAPITALIZATION, COD_DAT_MATURITY, COD_DEP_TERM, COD_INVENTORY_COD, COD_INVENTORY_NO, COD_INVENTORY_STATUS, COD_PAY_VERIFY_AMT, COD_PAYER_PAYEE_NAM_FLG, COD_FUND_ATTR, COD_BULK_ACCT_OPEN_FLG, COD_ACCT_CLOSURE_FLG, COD_ASSIGNED_ACCT, COD_ACCRUE_INT_AMT, COD_DUE_INT_AMT, COD_REG_PERIOD_INT, COD_INT_PAYOUT_ACCT, COD_FIRST_CHK_PERSON, COD_FIRST_CHK_PERSON_TELNO, COD_SECOND_CHK_PERSON, COD_SECOND_CHK_PERSON_TELNO, COD_CAPITAL_VERIFY_RESULT, COD_AGREEMENT_DEPOSIT_FLG, COD_PARENT_ACCT_FLG, COD_OFFICIER_ID, COD_ACCT_NO_BENEF, AMT_DR_INT_ACCR, COD_PIN_STAT, CHG_MIGRATED_PSBK FROM XFACE_TEMP_ACCT_BAS_INFO |
| gpa08sdz7mmyg | INSERT INTO TMP_XFACE_AT_INV_USAGE_LOG (SESSION_ID, COD_MC_PSBK_CARD_NO, COD_MC_ACCT_NO, NAM_CUST_SHRT, COD_STOCK, COD_STOCK_NO, COD_IV_STAT, NARRATIVE, DAT_TXN, COD_HOME_BRN, COD_ISSUE_BRN, COD_USER_ID, COD_AUTH_ID, COD_TXN_BRN, COD_TXN_USER_ID, REF_TXN_NO, REF_USR_NO, DAT_PROCESS, EXT_TASK_CODE, FLG_PRIMARY, SEQ_NUM) SELECT SESSION_ID, COD_MC_PSBK_CARD_NO, COD_MC_ACCT_NO, NAM_CUST_SHRT, COD_STOCK, COD_STOCK_NO, COD_IV_STAT, NARRATIVE, DAT_TXN, COD_HOME_BRN, COD_ISSUE_BRN, COD_USER_ID, COD_AUTH_ID, COD_TXN_BRN, COD_TXN_USER_ID, REF_TXN_NO, REF_USR_NO, DAT_PROCESS, EXT_TASK_CODE, FLG_PRIMARY, ROWNUM FROM (SELECT :B9 AS SESSION_ID, A.COD_MC_ACCT_NO AS COD_MC_PSBK_CARD_NO, A.COD_MC_ACCT_NO AS COD_MC_ACCT_NO, A.NAM_CUST_SHRT AS NAM_CUST_SHRT, A.COD_STOCK AS COD_STOCK, A.COD_STOCK_NO AS COD_STOCK_NO, A.COD_IV_STAT AS COD_IV_STAT, A.NARRATIVE AS NARRATIVE, A.DAT_TXN AS DAT_TXN, (SELECT COD_EXTERNAL_BRANCH FROM BA_EXT_BRANCH_XREF WHERE COD_CC_BRN = A.COD_HOME_BRN AND FLG_MNT_STATUS = 'A') AS COD_HOME_BRN, B.COD_EXTERNAL_BRANCH AS COD_ISSUE_BRN, A.COD_USER_ID AS COD_USER_ID, A.COD_AUTH_ID AS COD_AUTH_ID, (SELECT COD_EXTERNAL_BRANCH FROM BA_EXT_BRANCH_XREF WHERE COD_CC_BRN = A.COD_TXN_BRN AND FLG_MNT_STATUS = 'A') AS COD_TXN_BRN, A.COD_TXN_USER_ID AS COD_TXN_USER_ID, A.REF_TXN_NO AS REF_TXN_NO, A.REF_USR_NO AS REF_USR_NO, :B8 AS DAT_PROCESS, A.EXT_COD_TASK AS EXT_TASK_CODE, A.FLG_PRIMARY_MCA AS FLG_PRIMARY FROM AT_INV_USAGE_LOG A, BA_EXT_BRANCH_XREF B WHERE A.COD_ISSUE_BRN IN (SELECT COD_CC_BRN FROM GTT_LOWER_BRANCH WHERE SESSION_ID = :B9 ) AND A.COD_ISSUE_BRN = B.COD_CC_BRN AND B.FLG_MNT_STATUS = 'A' AND TRUNC(A.DAT_TXN) BETWEEN TRUNC(NVL(:B7 , A.DAT_TXN)) AND TRUNC(NVL(:B6 , A.DAT_TXN)) AND A.COD_IV_STAT = NVL(:B5 , A.COD_IV_STAT) AND A.COD_STOCK_NO = NVL(NVL(:B4 , :B3 ), A.COD_STOCK_NO) AND A.COD_STOCK = CAST(NVL(NVL(:B2 , :B1 ), A.COD_STOCK) AS CHAR(10)) AND A.FLG_DISPLAY = 'Y' ORDER BY A.DAT_SYSTEM ASC, A.FLG_PRIMARY_MCA DESC) INNERQUERY |
| gqbuymkzgjp1d | SELECT AB.*, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.cod_fcr_hold_no ELSE NULL END FCR_UNHOLD_NO , CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Notice_No ELSE NULL END UNHOLD_COD_NOTICE_NO, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.DAT_POSTING ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN AB.DAT_HOLD_STATUS ELSE NULL END END DAT_UNHOLD_ACTION, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN to_char(auditlogs2.Dat_ACTION, 'HH24:MI:SS') ELSE NULL END UNHOLD_TIME, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Reason ELSE NULL END UNHOLD_HOLD_AUTH, CASE WHEN(auditlogs2.cod_action in (2, 4) OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Last_Mnt_Makerid ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN 'SYSTEM' ELSE NULL END END UNHOLD_MAKER, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Cod_Last_Mnt_Chkrid ELSE CASE WHEN(AB.COD_HOLD_STATUS = 4) THEN 'SYSTEM' ELSE NULL END END UNHOLD_CHECKER, CASE WHEN(auditlogs2.cod_action in (2, 4)OR (auditlogs2.cod_action =1 AND cod_hold_status = 3)) THEN auditlogs2.Txt_Narrative ELSE NULL END UNHOLD_NARR, CASE WHEN(auditlogs2.cod_action =1 AND cod_hold_status = 3) THEN auditlogs2.COD_PREV_NOTICE_NO ELSE NULL END prev_notice_no FROM (Select * from temp_holdunhold_inq1 tmp WHERE 1 = 1 AND (cod_hold_status = (case when cod_hold_typ = 3 then cod_hold_status else 0 end) or cod_hold_status = (case when cod_hold_typ = 3 then cod_hold_status else 1 end)) AND COD_HOLD_TYP = 3 AND COD_CC_BRN_TXN = 750 ) AB LEFT JOIN ba_hold_audit_log auditlogs2 ON (AB.cod_fcr_hold_no = auditlogs2.Cod_Fcr_Hold_No AND AB.COD_NOTICE_NO = auditlogs2.cod_notice_no AND AB.cod_mc_acct_no = auditlogs2.cod_mc_acct_no) |
| gwrjkqrbumphx | BEGIN :1 := FCR44HOST.pk_xface_audit_trail.at_mca_open_close_log(:2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 ); END; |
| gx82nv3n6pkuk | SELECT DISTINCT X.COD_STOCK, X.COD_STOCK_NO, X.DAT_POST, X.COD_BANK FROM IV_MCA_XREF X WHERE X.COD_STOCK IN (SELECT DISTINCT B.COD_STOCK FROM ST_FW_INST_SITE_XREF A, IV_STOCK_MAST B WHERE A.COD_INSTR_TYPE IN ('734', '735', '736', '737', '738', '747', '748', '754', '760', '778', '781') AND A.COD_INSTR_TYPE = B.COD_INSTR_TYPE AND A.FLG_MNT_STATUS = 'A' AND B.FLG_MNT_STATUS = 'A') AND X.COD_MC_ACCT_NO = :B1 AND X.LINK_STATUS = 'A' |
| gx87sann8asuf | BEGIN aw_trunc_proc(ora_dict_obj_type, ora_dict_obj_name, ora_dict_obj_owner); END; |
| gxdsmz8q6mdns | SELECT (CASE WHEN NVL(A.BAL_BOOK, 0) > 0 THEN A.BAL_BOOK - :B3 ELSE NVL(A.BAL_BOOK, 0) END), (CASE WHEN NVL(A.BAL_AVAILABLE, 0) > 0 THEN A.BAL_AVAILABLE - :B3 ELSE NVL(A.BAL_AVAILABLE, 0) END), (CASE WHEN NVL(A.BAL_AVAILABLE, 0) > 0 THEN A.BAL_AVAILABLE - :B3 ELSE A.BAL_AVAILABLE END) + NVL(AMT_SWEEPIN_LIEN, 0) - NVL(AMT_HLD, 0) - NVL(BAL_ACCT_MIN_REQD, 0) + NVL(AMT_OD_LIMIT, 0) + (NVL(CREDIT_CONFIRMATION_BAL, 0) - NVL(DEBIT_CONFIRMATION_BAL, 0)), A.AMT_HLD, A.DAT_LAST_INT_CAP, DATEDIFF('MM', A.DAT_ACCT_OPEN, A.DAT_MATURITY), A.DAT_MATURITY, (CASE COD_ACCT_STAT WHEN 1 THEN 0 WHEN 5 THEN 0 ELSE A.AMT_CR_INT_ACCR + A.AMT_CR_INT_ACCR_ADJ + (A.AMT_CR_INT_COMP * (DATEDIFF(DD, A.DAT_LAST_INT_COMP, :B2 ))) END), A.COD_OFFICR_ID, RAT_INT_RD, (CASE COD_ACCT_STAT WHEN 1 THEN 0 WHEN 5 THEN 0 ELSE (A.AMT_DR_INT_ACCR + A.AMT_DR_INT_ACCR_ADJ + (A.AMT_DR_INT_COMP * (DATEDIFF(DD, A.DAT_LAST_INT_COMP, :B2 )))) * -1 END), COD_ACCT_STAT, NVL(AMT_SWEEPIN_LIEN, 0), NVL(BAL_ACCT_MIN_REQD, 0), NVL(AMT_OD_LIMIT, 0), NVL(CREDIT_CONFIRMATION_BAL, 0), NVL(DEBIT_CONFIRMATION_BAL, 0) FROM CH_ACCT_MAST A WHERE A.COD_ACCT_NO = :B1 AND A.FLG_MNT_STATUS = 'A' |