165: IS
166: SELECT DISTINCT aid.dist_code_combination_id
167: FROM iby_payments_all ipa,
168: iby_docs_payable_all idpa,
169: ap_invoice_distributions aid
170: WHERE ipa.payment_id = p_payment_id
171: and ipa.payment_id = idpa.payment_id
172: and idpa.calling_app_id = 200
173: and idpa.document_type = 'INVOICE'