APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_TRXN_EXT_AUTHS_V

Line 1852: FROM iby_trxn_ext_auths_v x, iby_fndcpt_sys_eft_pf_b sp,

1848: CURSOR c_auths
1849: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
1850: IS
1851: SELECT NVL(sp.settle_require_vrfy_flag,'Y')
1852: FROM iby_trxn_ext_auths_v x, iby_fndcpt_sys_eft_pf_b sp,
1853: iby_fndcpt_user_eft_pf_b up
1854: WHERE (x.trxn_extension_id = ci_extension_id)
1855: AND (DECODE(x.instrument_type,
1856: IBY_FNDCPT_COMMON_PUB.G_INSTR_TYPE_BANKACCT,x.process_profile_code,

Line 2840: FROM iby_trxn_ext_auths_v

2836: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
2837: IS
2838: SELECT authorization_id, authorization_date, authorization_code,
2839: avs_code, instr_sec_code_check, pmt_sys_err_code, pmt_sys_err_msg
2840: FROM iby_trxn_ext_auths_v
2841: WHERE (trxn_extension_id = ci_extension_id)
2842: ORDER BY
2843: DECODE(authorization_result_code, 'AUTH_SUCCESS',10,
2844: 'AUTH_PENDING',5, 0) DESC;

Line 3093: FROM iby_trxn_ext_auths_v

3089: CURSOR c_auth
3090: (ci_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
3091: IS
3092: SELECT authorization_id
3093: FROM iby_trxn_ext_auths_v
3094: WHERE (trxn_extension_id = ci_extension_id)
3095: AND (authorization_status = 0);
3096:
3097: