DBA Data[Home] [Help]

APPS.PA_INVOICE_CURRENCY dependencies on PA_PROJECT_CUSTOMERS

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

301: IF g1_debug_mode = 'Y' THEN
302: PA_MCB_INVOICE_PKG.log_message('recalculATE: ' || ' Selecting Inv Trans Currency COde');
303: END IF;
304:
305: /* for Invoice generation, select currency code and conversion attribute from pa_project_customers. */
306:
307: select inv_currency_code,
308: -- nvl(inv_rate_date,P_Bill_Thru_Date), /* commented for mcb2 to use invoice_date */
309: nvl(inv_rate_date,NVL(l_invoice_date,P_Bill_Thru_Date)),

Line 316: from pa_project_customers

312: into l_inv_currency_code,
313: l_inv_rate_date,
314: l_inv_rate_type,
315: l_inv_exchange_rate
316: from pa_project_customers
317: where project_id = P_Project_Id
318: and customer_id = P_Customer_id ;
319:
320: /*Start of code changes for bug 9453939*/