APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_SYS_SECURITY_SUBKEYS

Line 4981: iby_sys_security_subkeys k

4977: SELECT x.trxn_extension_id, x.instr_sec_code_length,
4978: NVL(x.encrypted,'N'), s.segment_cipher_text, k.subkey_cipher_text,
4979: s.sec_segment_id
4980: FROM iby_fndcpt_tx_extensions x, iby_security_segments s,
4981: iby_sys_security_subkeys k
4982: WHERE (NVL(x.encrypted,'N') = 'Y')
4983: AND (NOT instrument_security_code IS NULL)
4984: AND (x.instr_code_sec_segment_id = s.sec_segment_id(+))
4985: AND (s.sec_subkey_id = k.sec_subkey_id(+));

Line 5027: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,

5023: END Decrypt_Extensions;
5024:
5025: FUNCTION Get_Security_Code
5026: (p_sys_sec_key IN iby_security_pkg.DES3_KEY_TYPE,
5027: p_subkey_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
5028: p_sec_code_cipher IN iby_security_segments.segment_cipher_text%TYPE,
5029: p_sec_code_len IN iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE
5030: )
5031: RETURN iby_fndcpt_tx_extensions.instrument_security_code%TYPE

Line 5061: l_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;

5057: IS
5058: l_sec_code iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
5059: l_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;
5060: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
5061: l_subkey_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5062: l_encrypted iby_fndcpt_tx_extensions.encrypted%TYPE;
5063: lx_err_code VARCHAR2(100);
5064:
5065: CURSOR c_extension

Line 5071: iby_sys_security_subkeys k

5067: IS
5068: SELECT x.instrument_security_code, x.instr_sec_code_length,
5069: NVL(x.encrypted,'N'), s.segment_cipher_text, k.subkey_cipher_text
5070: FROM iby_fndcpt_tx_extensions x, iby_security_segments s,
5071: iby_sys_security_subkeys k
5072: WHERE (trxn_extension_id = ci_extension_id)
5073: AND (x.instr_code_sec_segment_id = s.sec_segment_id(+))
5074: AND (s.sec_subkey_id = k.sec_subkey_id(+));
5075: