APPS.MTL_MOVEMENT_RPT_PKG dependencies on AP_INVOICES

Line 70: from ap_invoices

66: and l_movement_type in ('A','AA'))
67: then
68: begin
69: select exchange_rate into l_exchange_rate
70: from ap_invoices
71: where invoice_id = l_invoice_id;
72: exception when no_data_found
73: then l_exchange_rate := null;
74: end;

Line 143: from ap_invoices

139: and l_movement_type in ('A','AA'))
140: then
141: begin
142: select exchange_date into l_exchange_date
143: from ap_invoices
144: where invoice_id = l_invoice_id;
145: exception when no_data_found
146: then l_exchange_date := null;
147: end;

Line 345: from ap_invoices

341: -- (Required for Where Clause of select and updates) --
342: -------------------------------------------------------
343: update mtl_movement_statistics mms
344: set invoice_date_reference = (select invoice_date
345: from ap_invoices
346: where invoice_id = mms.invoice_id)
347: where mms.movement_type = P_MOVEMENT_TYPE
348: and mms.entity_org_id = P_LEGAL_ENTITY_ID
349: and mms.movement_status = 'O'