DBA Data[Home] [Help]

APPS.CSE_ASSET_UTIL_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 842: FROM po_distributions_all pda,

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

Line 851: FROM po_distributions_all pda,

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