eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_FNDCPT_EXTRACT_GEN_PVT dependencies on IBY_EXT_BANK_ACCOUNTS

Line 1332: l_iban iby_ext_bank_accounts.iban%TYPE;

1328: FUNCTION get_assignment_iban
1329: ( p_assign_id IN iby_debit_authorizations.external_bank_account_use_id%TYPE )
1330: RETURN varchar2
1331: IS
1332: l_iban iby_ext_bank_accounts.iban%TYPE;
1333: BEGIN
1334:
1335: IF (p_assign_id IS NULL) THEN
1336: RETURN NULL;

Line 1343: ,iby_ext_bank_accounts ext_ba

1339: SELECT iby_ext_bankacct_pub.Uncipher_Bank_Number (ext_ba.iban, ext_ba.iban_sec_segment_id, iby_utility_pvt.get_view_param('SYS_KEY'),
1340: ibk.subkey_cipher_text, ibs.segment_cipher_text, ibs.encoding_scheme, ext_ba.ba_mask_setting, ext_ba.ba_unmask_length)
1341: INTO l_iban
1342: FROM iby_pmt_instr_uses_all iu
1343: ,iby_ext_bank_accounts ext_ba
1344: ,iby_sys_security_subkeys ibk
1345: ,iby_security_segments ibs
1346: WHERE iu.instrument_payment_use_id = p_assign_id
1347: AND iu.instrument_type = 'BANKACCOUNT'