DBA Data[Home] [Help]

APPS.IBY_PYO_TRANSACTION dependencies on IBY_PAYMENT_METHODS_B

Line 738: iby_payment_methods_b ipm ,

734: hz_locations ebl ,
735: hz_code_assignments hca ,
736: hz_locations ibl ,
737: hz_code_assignments hca1 ,
738: iby_payment_methods_b ipm ,
739: iby_ext_bank_accounts ieba ,
740: (SELECT party_id ,
741: bank_code
742: FROM hz_organization_profiles

Line 948: , iby_payment_methods_b ipm

944: , idpa.document_sequence_value
945: , idpa.document_category_code
946: FROM iby_docs_payable_all idpa
947: , iby_payments_all ipa
948: , iby_payment_methods_b ipm
949: WHERE idpa.payment_id = ipa.payment_id
950: AND idpa.payment_method_code = ipm.payment_method_code
951: AND ipa.payment_instruction_id = p_payment_instruction_id
952: AND idpa.document_status in ('PAYMENT_CREATED');