738: iby_payment_methods_b ipm ,
739: iby_ext_bank_accounts ieba ,
740: (SELECT party_id ,
741: bank_code
742: FROM hz_organization_profiles
743: WHERE sysdate >= effective_start_date
744: AND(effective_end_date IS NULL
745: OR effective_end_date > sysdate)
746: ) bapr,