DBA Data[Home] [Help]

APPS.POA_BIS_ALERTS dependencies on POA_BIS_SAVINGS

Line 316: poa_bis_savings poa

312: l_format_mask)
313: INTO l_leakage_percent, l_total_purchases, l_potential_savings,
314: l_leakage_amount
315: FROM gl_daily_rates gl,
316: poa_bis_savings poa
317: WHERE gl.from_currency (+) = poa.currency_code
318: AND gl.to_currency (+) = p_currency
319: AND gl.conversion_date (+) = poa.rate_date
320: AND gl.conversion_type (+) = NVL(poa.rate_type, 'Corporate')

Line 373: poa_bis_savings poa

369: l_format_mask)
370: INTO l_leakage_percent, l_total_purchases, l_potential_savings,
371: l_leakage_amount
372: FROM gl_daily_rates gl,
373: poa_bis_savings poa
374: WHERE gl.from_currency (+) = poa.currency_code
375: AND gl.to_currency (+) = p_currency
376: AND gl.conversion_date (+) = poa.rate_date
377: AND gl.conversion_type (+) = NVL(poa.rate_type, 'Corporate')

Line 431: poa_bis_savings poa

427: l_format_mask)
428: INTO l_leakage_percent, l_total_purchases, l_potential_savings,
429: l_leakage_amount
430: FROM gl_daily_rates gl,
431: poa_bis_savings poa
432: WHERE gl.from_currency (+) = poa.currency_code
433: AND gl.to_currency (+) = p_currency
434: AND gl.conversion_date (+) = poa.rate_date
435: AND gl.conversion_type (+) = NVL(poa.rate_type, 'Corporate')