DBA Data[Home] [Help]

APPS.ECE_AP_PAYMENT dependencies on IBY_PAYMENT_METHODS_B

Line 745: iby_payment_methods_b ipm ,

741: hz_locations ebl ,
742: hz_code_assignments hca ,
743: hz_locations ibl ,
744: hz_code_assignments hca1 ,
745: iby_payment_methods_b ipm ,
746: iby_ext_bank_accounts ieba ,
747: (SELECT party_id ,
748: bank_code
749: FROM hz_organization_profiles

Line 954: , iby_payment_methods_b ipm

950: , idpa.document_sequence_value
951: , idpa.document_category_code
952: FROM iby_docs_payable_all idpa
953: , iby_payments_all ipa
954: , iby_payment_methods_b ipm
955: WHERE idpa.payment_id = ipa.payment_id
956: AND idpa.payment_method_code = ipm.payment_method_code
957: AND ipa.payment_instruction_id = p_payment_instruction_id
958: AND idpa.document_status in ('PAYMENT_CREATED');