DBA Data[Home] [Help]

APPS.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on IBY_TRXN_EXTENSIONS_V

Line 1310: FROM iby_trxn_extensions_v ibyt

1306: ibyt.card_issuer_name
1307: /*modified by cgopinee for PA-DSS one off strategy*/
1308: ||' , ' ||
1309: decode(encrypted,'A','',TO_CHAR(TO_DATE(ibyt.card_expirydate), 'MM/YYYY')) AS cc_number
1310: FROM iby_trxn_extensions_v ibyt
1311: WHERE ibyt.trxn_extension_id = p_trxn_extension_id;
1312: BEGIN
1313: -- start debug log
1314: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 1385: FROM iby_trxn_extensions_v ibyt

1381: l_cc_cvv2 VARCHAR2 (2000) := '';
1382:
1383: CURSOR csr_cc_dtls IS
1384: SELECT ibyt.instrument_security_code AS cc_cvv2
1385: FROM iby_trxn_extensions_v ibyt
1386: WHERE ibyt.trxn_extension_id = p_trxn_extension_id;
1387: BEGIN
1388: -- start debug log
1389: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN