APPS.IGIPMSLR dependencies on AP_INVOICE_DISTRIBUTIONS

Line 37: FROM ap_invoice_distributions dist

33: , dist.distribution_line_number, dist.dist_code_combination_id
34: , dist.description, dist.accounting_date, gsob.chart_of_accounts_id
35: , dist.base_amount, dist.exchange_rate, dist.exchange_date,
36: dist.exchange_rate_type, gsob.currency_code functional_currency_code
37: FROM ap_invoice_distributions dist
38: , gl_sets_of_books gsob
39: WHERE dist.distribution_line_number = cp_distribution_line_number
40: AND dist.set_of_books_id = gsob.set_of_books_id
41: AND dist.invoice_id = cp_invoice_id

Line 158: FROM ap_invoice_distributions

154: l_date DATE := null;
155:
156: CURSOR c_acc_date is
157: SELECT accounting_date
158: FROM ap_invoice_distributions
159: WHERE invoice_id = fp_invoice_id
160: AND set_of_books_id = fp_sob_id
161: AND distribution_line_number =
162: fp_dist_line_num

Line 170: from ap_invoice_distributions

166: FROM gl_period_statuses
167: WHERE application_id = AP_APPLICATION_ID
168: AND set_of_books_id = fp_sob_id
169: AND period_name = ( select period_name
170: from ap_invoice_distributions
171: where invoice_id = fp_invoice_id AND
172: distribution_line_number =
173: fp_dist_line_num ) ;
174: BEGIN