DBA Data[Home] [Help]

APPS.CSE_ASSET_UTIL_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 888: FROM po_distributions_all pda,

884:
885:
886: CURSOR payables_ccid_cur (c_transaction_id IN NUMBER,c_instance_id IN NUMBER) IS
887: SELECT pda.code_combination_id
888: FROM po_distributions_all pda,
889: rcv_transactions rt,
890: csi_transactions ct
891: WHERE pda.po_distribution_id = rt.po_distribution_id
892: AND rt.transaction_id = ct.source_dist_ref_id2

Line 897: FROM po_distributions_all pda,

893: AND ct.transaction_id = c_transaction_id
894: AND ct.transaction_type_id = 105 -- rec in to project
895: UNION
896: SELECT pda.variance_account_id
897: FROM po_distributions_all pda,
898: ap_invoice_distributions_all aida ,
899: csi_transactions ct
900: WHERE pda.po_distribution_id = aida.po_distribution_id
901: AND aida.invoice_distribution_id = ct.source_dist_ref_id2