[Home] [Help]
40: aba.multi_currency_allowed_flag,
41: aba.check_digits,
42: csh.rowid,
43: NVL(csh.statement_complete_flag,'N')
44: FROM ce_bank_accts_gt_v aba, --ce_bank_accounts_v aba,
45: ce_statement_headers csh
46: WHERE aba.bank_account_id = NVL(p_bank_account_id,aba.bank_account_id)
47: AND aba.bank_account_id = csh.bank_account_id
48: AND csh.statement_number
7121:
7122: IF (x_bank_account_id is not null)
7123: select ACCOUNT_OWNER_ORG_ID
7124: into p_le_id
7125: from ce_bank_accts_gt_v --ce_BANK_ACCOUNTS_v
7126: where BANK_ACCOUNT_ID = x_bank_account_id;
7127:
7128: select AMOUNT_TOLERANCE_OLD,
7129: PERCENT_TOLERANCE_OLD,