APPS.PA_MC_CURRENCY_PKG dependencies on AP_MC_INVOICE_DISTS

Line 1063: x_err_stage := ' Select from ap_mc_invoice_dists';

1059:
1060: l_old_stack := x_err_stack;
1061: x_err_code := 0;
1062: x_err_stack := x_err_stack ||'->PA_MC_CURRENCY_PKG.get_ap_rate';
1063: x_err_stage := ' Select from ap_mc_invoice_dists';
1064:
1065: -- To get the ap rates logic used : FC:Foreign curr, PC:Pri Curr,Rep:Reporting
1066: -- If foreign curr inv, then ap.amount = FC amount, ap.base_Amount = PC amt
1067: -- and mc.base_amount = Rep Amount, mc.amount = FC or PC amt.

Line 1094: ap_mc_invoice_dists mc,

1090: x_exchange_rate_type,
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

Line 1123: FROM ap_mc_invoice_dists mc,

1119: INTO x_exchange_rate,
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

Line 1143: FROM ap_mc_invoice_dists mc,

1139: INTO x_exchange_rate,
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