DBA Data[Home] [Help]

APPS.PAAP_PWP_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 651: po_dIstributions_all pod,

647: sum(apd.amount) ProjInvAmount,
648: sum(ap_pay_hd.amount) Disc_Taken_On_Invoice /* Bug# 7833675 */
649: from
650: ap_invoice_dIstributions_all apd,
651: po_dIstributions_all pod,
652: ap_payment_hist_dists ap_pay_hd
653: where apd.project_Id = p_project_Id
654: and apd.invoice_id = p_invoice_id
655: and apd.posted_flag = 'Y'

Line 676: po_dIstributions_all pod

672: p_Expenditure_Item_Date Date,
673: p_po_header_id Number) Is
674: select sum(apd.amount) ProjRtngAmount from
675: ap_invoice_dIstributions_all apd,
676: po_dIstributions_all pod
677: where apd.project_Id = p_project_Id
678: and apd.invoice_id = p_invoice_id
679: and apd.posted_flag = 'Y'
680: and pod.po_dIstribution_id(+) = apd.po_distribution_id