[Home] [Help]
136: debit_auth_method IBY_TRXN_SUMMARIES_ALL.debit_auth_method%TYPE,
137: debit_auth_reference IBY_TRXN_SUMMARIES_ALL.debit_auth_reference%TYPE,
138: capture_transaction_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
139: int_bank_country VARCHAR2(60),
140: settle_req_vrfy IBY_FNDCPT_SYS_EFT_PF_B.SETTLE_REQUIRE_VRFY_FLAG%TYPE,
141: auth_count PLS_INTEGER,
142: auth_dirdeb_instruction_code IBY_TRXN_SUMMARIES_ALL.dirdeb_instruction_code%TYPE,
143: card_subtype_code IBY_TRXN_CORE.card_subtype_code%TYPE,
144: card_data_level IBY_TRXN_CORE.card_data_level%TYPE
2266: CURSOR c_auths
2267: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
2268: IS
2269: SELECT NVL(sp.settle_require_vrfy_flag,'Y')
2270: FROM iby_trxn_ext_auths_v x, iby_fndcpt_sys_eft_pf_b sp,
2271: iby_fndcpt_user_eft_pf_b up
2272: WHERE (x.trxn_extension_id = ci_extension_id)
2273: AND (DECODE(x.instrument_type,
2274: IBY_FNDCPT_COMMON_PUB.G_INSTR_TYPE_BANKACCT,x.process_profile_code,
4791: IBY_TRXN_SUMMARIES_ALL captures,
4792: IBY_EXTERNAL_PAYERS_ALL auth_payer,
4793: IBY_BEPINFO bep,
4794: IBY_FNDCPT_USER_EFT_PF_B eft_user,
4795: IBY_FNDCPT_SYS_EFT_PF_B eft_sys,
4796: CE_BANK_ACCOUNTS int_ba,
4797: --CE_BANK_BRANCHES_V branch
4798: HZ_PARTIES BranchParty,
4799: HZ_ORGANIZATION_PROFILES BranchOrgProfile,