838:
839:
840: CURSOR payables_ccid_cur (c_transaction_id IN NUMBER,c_instance_id IN NUMBER) IS
841: SELECT pda.code_combination_id
842: FROM po_distributions_all pda,
843: rcv_transactions rt,
844: csi_transactions ct
845: WHERE pda.po_distribution_id = rt.po_distribution_id
846: AND rt.transaction_id = ct.source_dist_ref_id2
847: AND ct.transaction_id = c_transaction_id
848: AND ct.transaction_type_id = 105 -- rec in to project
849: UNION
850: SELECT pda.variance_account_id
851: FROM po_distributions_all pda,
852: ap_invoice_distributions_all aida ,
853: csi_transactions ct
854: WHERE pda.po_distribution_id = aida.po_distribution_id
855: AND aida.invoice_distribution_id = ct.source_dist_ref_id2