APPS.PA_MC_CURRENCY_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 1095: ap_invoice_distributions ap

1091: x_amount,
1092: l_reporting_curr_code
1093: FROM gl_sets_of_books sob,
1094: ap_mc_invoice_dists mc,
1095: ap_invoice_distributions ap
1096: WHERE ap.invoice_id = x_invoice_id
1097: AND ap.distribution_line_number = x_line_num
1098: AND mc.invoice_id = ap.invoice_id
1099: AND mc.distribution_line_number = ap.distribution_line_number

Line 1124: ap_invoice_distributions ap

1120: x_exchange_date,
1121: x_exchange_rate_type,
1122: x_amount
1123: FROM ap_mc_invoice_dists mc,
1124: ap_invoice_distributions ap
1125: WHERE ap.invoice_id = x_invoice_id
1126: AND ap.distribution_line_number = x_line_num
1127: AND mc.invoice_id = ap.invoice_id
1128: AND mc.distribution_line_number = ap.distribution_line_number

Line 1144: ap_invoice_distributions ap

1140: x_exchange_date,
1141: x_exchange_rate_type,
1142: x_amount
1143: FROM ap_mc_invoice_dists mc,
1144: ap_invoice_distributions ap
1145: WHERE ap.invoice_id = x_invoice_id
1146: AND ap.distribution_line_number = x_line_num
1147: AND mc.invoice_id = ap.invoice_id
1148: AND mc.distribution_line_number = ap.distribution_line_number

Line 1769: ap_invoice_distributions_all b

1765:
1766: SELECT nvl(b.exchange_date,a.invoice_date)
1767: INTO l_exchange_date
1768: FROM ap_invoices_all a,
1769: ap_invoice_distributions_all b
1770: WHERE a.invoice_id = p_system_reference2
1771: AND a.invoice_id = b.invoice_id
1772: AND b.distribution_line_number = p_system_reference3;
1773:

Line 1783: ap_invoice_distributions_all b,

1779:
1780: SELECT nvl(b.exchange_date,a.invoice_date)
1781: INTO l_exchange_date
1782: FROM ap_invoices_all a,
1783: ap_invoice_distributions_all b,
1784: ap_invoice_payments c
1785: WHERE c.invoice_payment_id = l_inv_pay_id
1786: AND c.invoice_id = p_system_reference2
1787: AND c.invoice_id = b.invoice_id