DBA Data[Home] [Help]

APPS.IGIPMSMD dependencies on AP_INVOICES

Line 142: from ap_invoices

138: RETURN VARCHAR2
139: IS
140: CURSOR C_curr IS
141: SELECT invoice_currency_code
142: from ap_invoices
143: where invoice_id = fp_invoice_id
144: ;
145: BEGIN
146: FOR l_curr in C_curr LOOP

Line 161: l_currency_code ap_invoices_all.invoice_currency_code%TYPE := NULL;

157: , p_start_date in date
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;