DBA Data[Home] [Help]

APPS.PA_INVOICE_CURRENCY dependencies on PA_PROJECT_CUSTOMERS

Line 282: /* for Invoice generation, select currency code and conversion attribute from pa_project_customers. */

278: IF g1_debug_mode = 'Y' THEN
279: PA_MCB_INVOICE_PKG.log_message('recalculATE: ' || ' Selecting Inv Trans Currency COde');
280: END IF;
281:
282: /* for Invoice generation, select currency code and conversion attribute from pa_project_customers. */
283:
284: select inv_currency_code,
285: -- nvl(inv_rate_date,P_Bill_Thru_Date), /* commented for mcb2 to use invoice_date */
286: nvl(inv_rate_date,NVL(l_invoice_date,P_Bill_Thru_Date)),

Line 293: from pa_project_customers

289: into l_inv_currency_code,
290: l_inv_rate_date,
291: l_inv_rate_type,
292: l_inv_exchange_rate
293: from pa_project_customers
294: where project_id = P_Project_Id
295: and customer_id = P_Customer_id ;
296:
297: IF g1_debug_mode = 'Y' THEN