DBA Data[Home] [Help]

APPS.IGIPMSMD dependencies on AP_INVOICE_DISTRIBUTIONS

Line 31: FROM ap_invoice_distributions dist

27: IS
28: SELECT dist.invoice_id, dist.set_of_books_id, dist.period_name, dist.amount
29: , dist.distribution_line_number, dist.dist_code_combination_id
30: , dist.description
31: FROM ap_invoice_distributions dist
32: WHERE dist.distribution_line_number = cp_distribution_line_number
33: AND dist.invoice_id = cp_invoice_id
34: ;
35:

Line 162: l_amount ap_invoice_distributions_all.amount%TYPE := NULL;

158: , p_duration in number
159: ) IS
160:
161: l_currency_code ap_invoices_all.invoice_currency_code%TYPE := NULL;
162: l_amount ap_invoice_distributions_all.amount%TYPE := NULL;
163: l_running_amount ap_invoice_distributions_all.amount%TYPE := NULL;
164: l_total_amount ap_invoice_distributions_all.amount%TYPE := NULL;
165: l_mpp_dist_line_num igi_mpp_ap_invoice_dists_det.mpp_dist_line_number%TYPE;
166: l_period_name igi_mpp_ap_invoice_dists_det.period_name%TYPE;

Line 163: l_running_amount ap_invoice_distributions_all.amount%TYPE := NULL;

159: ) IS
160:
161: l_currency_code ap_invoices_all.invoice_currency_code%TYPE := NULL;
162: l_amount ap_invoice_distributions_all.amount%TYPE := NULL;
163: l_running_amount ap_invoice_distributions_all.amount%TYPE := NULL;
164: l_total_amount ap_invoice_distributions_all.amount%TYPE := NULL;
165: l_mpp_dist_line_num igi_mpp_ap_invoice_dists_det.mpp_dist_line_number%TYPE;
166: l_period_name igi_mpp_ap_invoice_dists_det.period_name%TYPE;
167:

Line 164: l_total_amount ap_invoice_distributions_all.amount%TYPE := NULL;

160:
161: l_currency_code ap_invoices_all.invoice_currency_code%TYPE := NULL;
162: l_amount ap_invoice_distributions_all.amount%TYPE := NULL;
163: l_running_amount ap_invoice_distributions_all.amount%TYPE := NULL;
164: l_total_amount ap_invoice_distributions_all.amount%TYPE := NULL;
165: l_mpp_dist_line_num igi_mpp_ap_invoice_dists_det.mpp_dist_line_number%TYPE;
166: l_period_name igi_mpp_ap_invoice_dists_det.period_name%TYPE;
167:
168: FUNCTION isVariableDuration ( fp_accounting_rule_id in number)