[Home] [Help]
95: IF P_Check_Id is not NULL THEN
96: BEGIN
97: SELECT ipb.iban
98: INTO l_iban_number
99: FROM ap_checks_all ac, iby_payee_all_bankacct_v ipb /* External Bank Uptake */
100: WHERE ac.check_id = P_check_id
101: AND ipb.ext_bank_account_id = ac.external_bank_account_id
102: AND ipb.party_id = ac.party_id;
103: EXCEPTION