APPS.AP_WEB_EXPORT_ER dependencies on AP_EXP_REPORT_DISTS

Line 138: ap_exp_report_dists xd

134: xl.receipt_conversion_rate,
135: xl.receipt_currency_amount,xd.amount ,
136: xd.report_distribution_id
137: FROM ap_expense_report_lines xl,
138: ap_exp_report_dists xd
139: WHERE xd.report_line_id = xl.report_line_id
140: and xl.report_header_id = l_report_header_id
141: and xd.report_header_id = l_report_header_id
142: and xd.receipt_currency_amount is null

Line 178: update ap_exp_report_dists set

174: --------------------------------------------------------------------
175: IF (l_prev_line_id <> 0 AND l_prev_line_id <> l_report_line_id) THEN
176: IF ( l_prev_ln_receipt_curr_amt - l_total_dist_rec_curr_amt <> 0 ) THEN
177: l_dist_rec_curr_amt := l_dist_rec_curr_amt + (l_prev_ln_receipt_curr_amt - l_total_dist_rec_curr_amt);
178: update ap_exp_report_dists set
179: receipt_currency_amount = l_dist_rec_curr_amt,
180: receipt_currency_code = l_receipt_currency_code,
181: receipt_conversion_rate = l_receipt_conversion_rate
182: where report_distribution_id = l_prev_dist_id;

Line 198: update ap_exp_report_dists set

194: l_dist_rec_curr_amt := ap_utilities_pkg.ap_round_currency(l_dist_rec_curr_amt,l_receipt_currency_code);
195: l_total_dist_rec_curr_amt := l_total_dist_rec_curr_amt + l_dist_rec_curr_amt;
196: l_prev_dist_id := l_report_distribution_id;
197:
198: update ap_exp_report_dists set
199: receipt_currency_amount = l_dist_rec_curr_amt,
200: receipt_currency_code = l_receipt_currency_code,
201: receipt_conversion_rate = l_receipt_conversion_rate
202: where report_distribution_id = l_report_distribution_id;

Line 212: update ap_exp_report_dists set

208: -- To the last distribution, add the difference amount if any left
209: -------------------------------------------------------------------
210: IF ( l_ln_receipt_curr_amt - l_total_dist_rec_curr_amt <> 0 ) THEN
211: l_dist_rec_curr_amt := l_dist_rec_curr_amt + (l_ln_receipt_curr_amt - l_total_dist_rec_curr_amt);
212: update ap_exp_report_dists set
213: receipt_currency_amount = l_dist_rec_curr_amt,
214: receipt_currency_code = l_receipt_currency_code,
215: receipt_conversion_rate = l_receipt_conversion_rate
216: where report_distribution_id = l_prev_dist_id;